From the course: Oracle Database 19c: Basic SQL

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

UPDATE table rows

UPDATE table rows

From the course: Oracle Database 19c: Basic SQL

Start my 1-month free trial

UPDATE table rows

- [Instructor] In this lesson, you'll get the syntax of the UPDATE statement, and the rules for updating one or more column values in a table, how to specify the columns, and when you don't have to specify a column list. The UPDATE statement is the primary way, you'll change a row that already exists in a table, and it's usually the only way. First, I'd like to define DML statements. Simply they make changes to a table. They can add one or many rows, insert into a table, update them, delete them, and even merge into them, with merge being a combo of the first three. Truncate is sort of a DML statement in that it does a mass delete, but it's more of a DDL, data definition command. Any DML statement can affect zero, one or many rows. In this lesson, we're going to focus on UPDATE, and inserting one row or multiple rows, whether in OLTP or data warehouse system. The UPDATE statement is really straightforward. You specify the table and schema name, if you don't own the table, include a…

Contents