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.

Inserting a new row to a table

Inserting a new row to a table - Oracle Database Tutorial

From the course: Oracle Database 12c: Basic SQL

Start my 1-month free trial

Inserting a new row to a table

“

- [Instructor] Now it's time to insert our very first record into our newly-created table. In order to accomplish that, we'll use the SQL insert command. So I'll type "insert into" followed by the table name, in my case, "test_table1" followed by the values keyword and inside brackets values corresponding to the different columns in my table. So, for example, hello for the first column. Remember, the first column in our test table one, the table we created in our previous video, is a varchar column, so it expects characters. And since I'm inserting a string of characters, I have to enclose it with quotation marks, comma, and the second value for the second column in my table. This is a numeric column, so I need to input a number. For example, let's input the number four. Let's close the brackets and execute this SQL statement. As you can see, we got output from our database that one row was inserted. Let's also insert a second row, so we will replace hello with world and four with…

Contents