How to Insert Values into Table in Oracle Sql
Insert command
The insert command is used to insert records or rows in database table. Insert command is very simple in SQL, Insert keyword is used for inserting data in the database tables. Insert command of SQL inserts one record or row at a time.
The general syntax of insert command is as given below:
Insert into table name values( value1,value2,…);
Example
Insert into employee values(‘E001’,’ADAM’, ‘SYDNEY’);
In response to the above insert command , sql will generate the message “1 row(s) created”.
