Write down a query for inserting 'n' rows into a table, prompting for the values each time a record is inserted

rajanen

 Profile Answers by rajanen Questions by rajanen

• Jul 19th, 2006

 

SYNTAX

insert into table_name &column1,..... values (.......);

e.g:

insert into emp (&emp_name,&emp_id) values ('aa',912);

rajanen

 Profile Answers by rajanen Questions by rajanen

• Jul 19th, 2006

 

SYNTAX

insert into table_name &column1,..... values (.......);

e.g:

insert into emp (emp_name,emp_id) values('&emp_name','&empid');

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 24th, 2007

 

SYNTAX:

INSERT INTO <TABLE_NAME> VALUES('&COLUMN1'(STRINGS,DATES),&COLUMN2);


EXAMPLE:

INSERT INTO EMP VALUES('&ENAME',&EMPNO);