RE: Code Conversion from MSSQL into Oracle

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Fri, 12 Dec 2003 22:24:25 -0800
Message-ID: <F001.005D9B68.20031212222425@fatcity.com>

Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C3C141.9E54D39C" ------_=_NextPart_001_01C3C141.9E54D39C
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

=20

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

=20

SAMPLE :-

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

=20

DECLARE cur_temp_GEMT CURSOR FOR select

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

=20

OPEN cur_temp_GEMT =20

=20

FETCH NEXT FROM cur_temp_GEMT INTO

@branch_id,@entity_id

=20

WHILE @@FETCH_STATUS =3D 0 =20

BEGIN =20

=20

UPDATE GEMT SET other_party_name=3D(SELECT name from GEAT where = branch_id
=3D_at_branch_id and entity_id=3D_at_entity_id and addr_type=3D'1' and entity_type=3D'D') where entity_id=3D_at_entity_id and branch_id =3D = @branch_id

=20

FETCH NEXT FROM cur_temp_GEMT INTO

@branch_id,

@entity_id

=20

END =20

CLOSE cur_temp_GEMT

DEALLOCATE cur_temp_GEMT

=20

------_=_NextPart_001_01C3C141.9E54D39C
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html>

<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">

<style>
<!--

/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal

	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:purple;
	text-decoration:underline;}
span.emailstyle17
	{font-family:"Courier New";
	color:red;}
span.emailstyle18
	{font-family:"Courier New";
	color:red;}
span.EmailStyle19
	{font-family:"Courier New";
	color:red;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}

-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

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=3D'' and = entity_type=3D'D'

OPEN cur_temp_GEMT        =


        


FETCH = NEXT FROM
cur_temp_GEMT INTO

      @branch_id,@entity_id

     


WHILE @@FETCH_STATUS =3D 0

BEGIN

UPDATE = GEMT SET
other_party_name=3D(SELECT name from GEAT where branch_id =3D_at_branch_id = and
entity_id=3D_at_entity_id and  addr_type=3D'1' and entity_type=3D'D') = where
entity_id=3D_at_entity_id and branch_id =3D @branch_id

      @branch_id,

      @entity_id

END

CLOSE cur_temp_GEMT

DEALLOCATE
cur_temp_GEMT

</div>

</body>

</html>

=00
------_=_NextPart_001_01C3C141.9E54D39C--

------=_NextPartTM-000-e5817c19-0d90-4317-b351-1a952fa2ab58--

-- 
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).

Received on Sat Dec 13 2003 - 00:24:25 CST