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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: