Are there any TOOLs for converting Sample Code (like the following) from MSSQL into Oracle?

 

SAMPLE :-

--------

DECLARE @entity_id char(32), @branch_id char(9)

 

DECLARE  cur_temp_GEMT CURSOR FOR select

         branch_id,entity_id from GEMT where other_party_name='' and entity_type='D'

 

OPEN cur_temp_GEMT       

        

FETCH NEXT FROM cur_temp_GEMT INTO

      @branch_id,@entity_id

     

WHILE @@FETCH_STATUS = 0

 

BEGIN

 

 

UPDATE GEMT SET other_party_name=(SELECT name from GEAT where branch_id [EMAIL PROTECTED] and [EMAIL PROTECTED] and  addr_type='1' and entity_type='D') where [EMAIL PROTECTED] and branch_id = @branch_id

 

FETCH NEXT FROM cur_temp_GEMT INTO

      @branch_id,

      @entity_id

 

 

END

 

CLOSE cur_temp_GEMT

DEALLOCATE cur_temp_GEMT

 

 

Reply via email to