oracle provides migration toolkit for this
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Saturday, December 13, 2003 6:14 AM
>
>
> 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
> =@branch_id and entity_id=@entity_id
> and addr_type='1' and entity_type='D') where entity_id=@entity_id 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
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: VIVEK_SHARMA
> INET: VIVEK_SHARMA_at_infosys.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: akshay
INET: akshay349_at_hotmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Mon Dec 15 2003 - 07:09:25 CST
