Home » SQL & PL/SQL » SQL & PL/SQL » Multiple Inserts
Multiple Inserts [message #191871] Fri, 08 September 2006 07:53 Go to next message
Messages: 1
Registered: August 2006
Location: GUWAHATI
Junior Member
I have two tables sales and salesdetail .
in sales table there is column sales_nid (number)., sales_ndate(number)
in salesdetail salesdetail_nsalesid (number)., and salesdetail_ndate

sales_nid values is equal to salesdetail_nsalesid, sales_ndate has values but salesdetail_ndate column is null,
now i want to insert the contents of sales_ndate in salesdetail_ndate.
When I wrtoe this statement

insert into salesdetail( salesdetail_ndate)
values (select sales_ndate from sales where sales_nid=salesdetail_nsalesid)

It gives me error.
How can i do this

Thanks in advance.
Re: Multiple Inserts [message #191878 is a reply to message #191871] Fri, 08 September 2006 08:04 Go to previous message
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
What error?
Previous Topic: ORA-00907: missing right parenthesis
Next Topic: UTL_FILE extract to multiple files
Goto Forum:

Current Time: Sun Aug 20 12:30:52 CDT 2017

Total time taken to generate the page: 0.01127 seconds