Home » SQL & PL/SQL » SQL & PL/SQL » insert multiple rows
insert multiple rows [message #221968] Thu, 01 March 2007 05:57 Go to next message
aditiC
Messages: 38
Registered: February 2006
Location: INDIA
Member
Hi All,

Please let me know how can i insert multiple rows into a table?
I am thinking of using a for loop, but my table is having composite primary key, one of number datatype & other of char datatype. How do i increment the char primary key while inserting the multiple records?
Re: insert multiple rows [message #221973 is a reply to message #221968] Thu, 01 March 2007 06:10 Go to previous message
friendarora
Messages: 24
Registered: February 2007
Junior Member

If the primary key is of composite type

why do you want to increment the other char field ?
Composite means the combination to be unique and not all fields individually to be unique.


Nitin
Previous Topic: SNAPSHOT NOT REFLECTED AUTOMATICALLY
Next Topic: How to remove carriage return?
Goto Forum:
  


Current Time: Sat Dec 10 10:54:07 CST 2016

Total time taken to generate the page: 0.04430 seconds