gordon_at_panix.com schreef:
> I'm having some trouble with an SQL insert statement taking waaay too
> long
> to run. It's been suggested that maybe I'm using inefficient SQL, and
> that there might be a faster way to achieve the results.
>
> I have two tables with identical structure, and I want to copy all
> records
> that exist in table A but not in table B, into table B.
>
Depending on your version, you could use
a merge statement.
Here's an example: http://psoug.org/reference/merge.html
http://tahiti.oracle.com is your entry into documentation heaven
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Tue Mar 20 2007 - 14:24:34 CDT
