DJ Dunk

iTrader: (5)

I'm stuck !!

Syntax has got me stumpted. I need to copy the values of a tables' field called "barcode" into another tables' barcode field. They need to be created as new records.

How do I do this in Oracle SQL ?

Something like:

insert into long051002010.barcode values(select barcode from boxes051002) ????

[Edited by DJ Dunk - 8/27/2002 2:41:19 PM]

GaryK

Dunk,

I think you just need to drop the VALUES clause:

INSERT INTO <table> (SELECT ....)

Not at a machine where can I try it.

Gary

DJ Dunk

iTrader: (5)

Thanks Gary that sorted it

. . . kind of. The table has a not-null column in it, going to need more work methinks

GaryK

Dunk

you could try including a literal value in the SELECT to populate the NOT NULL column, depends if you need the data to be specific so

INSERT INTO <table> (SELECT col1, "literal" AS col2, col3, etc.)

worth a go

Gary

DJ Dunk

iTrader: (5)

Will give it a go. The not-null values will be overwritten afterwards anyway.

Thanks for the help, most appreciated