Oracle SQL PLSQL 12C Tutorial 7 - How to Insert Record or Data in Table

This Video Tutorial Will Describe how to insert values or data into the table in oracle 12C version. This command will also work on other versions of database like Oracle 11g Database, Oracle 10g Database, Oracle 9i Database, Oracle 8i Database, Oracle 8 Database and so on.

Whenever you create a new table in oracle, you need to insert some data into that table otherwise that table is not usable. Example to select data, to update data and delete data, you first need to insert some data.

Full Syntax will be given in this video tutorial about how to insert records in oracle database table.

Along with the live example to insert records.

All the keywords, format, mandatory clauses etc are described in this video.

In this video, I use the INSERT command to add an entire record into a table. When using the command you must also use the keyword VALUES. If you want to enter a null value (one that has no value) for a field you can use the keyword NULL. Be sure to put single quotes around data types that are not numbers. Values need to be entered in the order the fields appear in the table.