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
|
- Code Conversion from MSSQL into Oracle VIVEK_SHARMA
- RE: Code Conversion from MSSQL into Oracle Shiva Maran
- Re: Code Conversion from MSSQL into Oracle Tim Gorman
- RE: Code Conversion from MSSQL into Oracle Hallas, John, Tech Dev
- RE: Code Conversion from MSSQL into Oracle VIVEK_SHARMA
- Re: Code Conversion from MSSQL into Oracle Akshay Kumar
- Code Conversion from MSSQL into Oracle VIVEK_SHARMA
- Code Conversion from MSSQL into Oracle VIVEK_SHARMA
- Re: Code Conversion from MSSQL into Oracle akshay