From the course: Learning Oracle Database 19c

Unlock the full course today

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

Add rows to a table

Add rows to a table - Oracle Database Tutorial

From the course: Learning Oracle Database 19c

Start my 1-month free trial

Add rows to a table

- [Instructor] You retrieve data from the database with the select statement, but how do you put it in there in the first place? With the insert statement, of course. I'll talk about the various forms the insert statement takes. How you can save your inserted data permanently, and how to throw it out and go back to where you started. Let's start out with the syntax of the insert statement. There are two clauses, the insert clause and the values clause. You specify the table name as the destination for your new row or rows and optionally, the column names you're going to fill in. The values clause is where you provide the actual column data for the row. You don't have to specify the column names but it's easier to understand and you have to specify them if you want to provide the column data in a particular order. Let's try out some insert statements. On the left you see the definition of the departments table. If you select the data tab right next to the columns tab, you see the…

Contents