WHENEVER ERROR

SET ECHO ON SET TIME ON DEFINE PP_SCRIPT_PATH = 'C:\script_run_batch\st1_pc_assetload\' WHENEVER SQLERROR EXIT ROLLBACK SPOOL &&PP_SCRIPT_PATH.ST1_ASSET_LOAD_kickouts_SQL.sql.log @&&PP_SCRIPT_PATH.ST1_ASSET_LOAD_kickouts_SQL.sql

SPOOL OFF

SQL Help

Insert into With Not Exists clause INSERT INTO clients(client_id, client_name, client_type) SELECT 10345, 'IBM', 'advertising' FROM dual WHERE not exists (select * from clientswhere clients.client_id = 10345);