From the course: Oracle Database 12c: Basic SQL

Unlock this course with a free trial

Join today to access over 25,300 courses taught by industry experts.

Updating values

Updating values - Oracle Database Tutorial

From the course: Oracle Database 12c: Basic SQL

Start my 1-month free trial Buy for my team

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.…

Contents