GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Tech FAQs  >  Oracle
Go To First  |  Previous Question  |  Next Question 
 Oracle  |  Question 40 of 244    Print  
Write down a query for inserting 'n' rows into a table, prompting for the values each time a record is inserted

  
Total Answers and Comments: 3 Last Update: October 24, 2007     Asked by: NarendraChowdary 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 19, 2006 05:57:24   #1  
rajanen Member Since: July 2006   Contribution: 5    

RE: Write down a query for inserting 'n' rows into a t...

SYNTAX

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

e.g:

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


 
Is this answer useful? Yes | No
July 19, 2006 06:01:42   #2  
rajanen Member Since: July 2006   Contribution: 5    

RE: Write down a query for inserting 'n' rows into a t...

SYNTAX

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

e.g:

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


 
Is this answer useful? Yes | No
October 24, 2007 05:01:40   #3  
shravanam Member Since: August 2007   Contribution: 22    

RE: Write down a query for inserting 'n' rows into a t...
SYNTAX:

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


EXAMPLE:

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

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape