SQL Insert Command Different Types

SQL Insert Command Different Types
Different type of SQL command are used to perform same operation  need to use at different time as per our requirement.We can use them in the next example  we are going to create a table name as TEST and heaving the following command.

Create Table command

CREATE TABLE TEST(ID NUMBER(10),NAME VARCHAR2(30));

Type-1

INSERT INTO TABLENAME(COLUMN1,COLUMN2) VALUES (VALUES1,VALUES2);

eg-insert into test(id,name) values(1,’shak’);

Type-2

eg-insert into test values(2,’data1′);

Type-3

eg-insert into test(‘&id’,’&name’);