how to modify query

[Harvinder Singh]

Title: Ora 29540 error

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 (

select

col1

from

t_suspended_txn

where 
col2  ='A'  
begin

insert into t_suspended_txn

select  'A' ,  'B'  

end

 

Thanks

--Harvinder