script
-
Hi guys, how could i rewrite this for Oracle. could someone please help me out. IF NOT EXISTS (SELECT * FROM employee WHERE employee_TITLE='Main') BEGIN INSERT INTO employee (employee_TITLE) VALUES ('Main Page') END;
-
Hi guys, how could i rewrite this for Oracle. could someone please help me out. IF NOT EXISTS (SELECT * FROM employee WHERE employee_TITLE='Main') BEGIN INSERT INTO employee (employee_TITLE) VALUES ('Main Page') END;
Hi I am not really up on oracle, but maybe the following might help. http://www.experts-exchange.com/Databases/Oracle/Q_21171448.html[^] (With experts Exchange Scroll right to the bottom, the answers are there...) http://episteme.arstechnica.com/eve/forums/a/tpc/f/6330927813/m/431005360041[^] http://www.dbforums.com/ansi-sql/304714-if-not-exists-oracle.html[^] I hope this helps Rob
.NET Developer @ FactoryMaster Ltd "Software for TOUGH businesses"