Insert Data into Oracle Table By Using Column Address

Syntax:

          insert into <table_name) values (&col1, &col2, &col3 …. &coln);

     This will prompt you for the values but for every insert you have to use forward        slash.

   
Example:

            SQL>  INSERT INTO student VALUES (&no, '&name', &marks);

Enter value for no: 1

Enter value for name: Jagan

Enter value for marks: 300

old   1: insert into student values(&no, '&name', &marks)

new   1: insert into student values(1, 'Jagan', 300)

SQL> /

Enter value for no: 2

Enter value for name: Naren

Enter value for marks: 400

old   1: insert into student values(&no, '&name', &marks)
new   1: insert into student values(2, 'Naren', 400)

INSERT VALUES INTO SPECIFIED COLUMNS BY USING ADDRESS

Syntax:

          insert into <table_name)(col1, col2, col3 … coln) values (&col1, &col2, &col3 …. &coln);

     This will prompt you for the values but for every insert you have to use forward
slash.

Example:

            SQL> INSERT INTO student (no, name) VALUES (&no, '&name');

Enter value for no: 5

Enter value for name: Visu

old   1:  insert into student (no, name) values(&no, '&name')

new   1:  insert into student (no, name) values(5, 'Visu')

SQL> /

Enter value for no: 6

Enter value for name: Rattu

old   1:  insert into student (no, name) values(&no, '&name')
new   1:  insert into student (no, name) values(6, 'Rattu')