| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: pl/sql dup_val_on_index
On Tue, 06 Dec 2005 04:05:16 -0800, nugster wrote:
>
> any ideas?
merge into table T
using (select) S
ON ( T.col1 =S.col2)
WHEN NOT MATCHED THEN INSERT INTO T(...) VALUES (S....);
-- http://www.mgogala.comReceived on Wed Dec 07 2005 - 07:51:20 CST
 |
 |