Hi,
Following code works in sql server but IF NOT EXISTS dosn't work in
oracle
how
can we modify this code so that it should work on both sql server and
oracle
if not exists (
if not exists (
select
col1
from
t_suspended_txn
where
col2 ='A'
begin
col2 ='A'
begin
insert into
t_suspended_txn
select 'A' , 'B'
end
Thanks
--Harvinder