Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Dual with Insert into select from

Dual with Insert into select from

From: <elizabeth1000_at_my-deja.com>
Date: Tue, 07 Dec 1999 21:15:26 GMT
Message-ID: <82jtda$snv$1@nnrp1.deja.com>

I have a huge table in a database and need various columns in it to populate other "sub-tables". However these tables don't just have values from the master table, they have an id column that I need to pull in from dual, and date columns. Can I mix up these kind of insert functions? Should I populate the columns coming from the master table and then update the id and date columns?

Thanks for any help.

E

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 07 1999 - 15:15:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US