Oracle Insert Statement

The INSERT statement is used to add one or more new rows of data to a database table.

Syntax:

INSERT INTO Table_name VALUES(...);

To create a table follow this Oracle Create Table Statement

Example:

To insert values in the table use below statement:

INSERT INTO stu VALUES('Radha','B',180,'science');

You will get output 1 row(s) inserted. if row is inserted successfully. You can verify the complete table data using below command:

select * from stu;

the select * command displayed only one record because that is the only record in our table.