From the course: Oracle Database 12c: Basic SQL

Unlock the full course today

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

Updating values

Updating values - Oracle Database Tutorial

From the course: Oracle Database 12c: Basic SQL

Start my 1-month free trial

Updating values

“

- [Instructor] In addition to the insert and delete DML commands we saw earlier in our chapter which allows us to insert and delete records from our table. We can also use the DML update command to modify values of specific columns for specific rows in our database. So let's see the DML update command in action. We'll start by selecting all rows from our test table. So I'll type select star from test table one and execute the command. As we see we have two records in our table at the moment. Both records have a value of test row for column one and different values off eleven and twelve for column two. So let's say we want to update only the first row. The row where column two has a value of eleven. In order to accomplish that all we have to do is type update, test table, one, which is the table name, set, col one, which is the first column name, equals, and specify a value such as updated value where and specify the condition. Column two, which is the name of my second column, equals…

Contents