RE: Code Conversion from MSSQL into Oracle

[Shiva Maran]

try oracle work bench from Oracle.   HTH ShivaM -----Original Message----- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED] Sent: Thursday, December 11, 2003 5:19 PM To: Multiple recipients of list ORACLE-L Subject: Code Conversion from MSSQL into Oracle   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     DISCLAIMER: This e-mail contains proprietary information some or all of which may be legally privileged. It is for the intended recipient only. If an addressing or transmission error has misdirected this e-mail, please notify the author by replying to this e-mail. If you are not the intended recipient, you must not use, save, disclose, distribute, copy, print or relay this e-mail.