On my 9.2.04 db, I am trying to run a MERGE statement and I get the following error: SP2-0734: unknown command beginning "merge into..." - rest of line ignored. SP2-0734: unknown command beginning "using ( se..." - rest of line ignored. SP2-0042: unknown command "MINUS" - rest of line ignored. I do not think it is my sql, because I copied an example from asktom and got the same error on his merge statement. Is there a script or setting I missed? ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------