Re: implement sql server procedure into oracle(Expanding Hierarchies)

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 15 Sep 2001 18:36:02 +0200
Message-ID: <tq70s95o703k37@news.demon.nl>

"Vishal Lavti" <vishal_lavti_at_yahoo.com> wrote in message news:bfd4391d.0109150714.6faa1ca6_at_posting.google.com...
> Hi all i just put my legs into computer field.I want to implement the
> following procdure into oracle as below
> Please help me out...................
>

[transact code sniped]

Oracle has CONNECT BY to represent hierarchical data. No temporary tables and other crap needed to format a hierarchy above. Please refer to the SQL reference manual for further details and examples.

All people exposed to sqlserver and migrating to Oracle make 3 common mistakes:
1 They think Oracle is just a sqlserver *clone* which it is not, it is much more.
2 They think they will get a working application by just porting their bad sqlserver habits into Oracle
3 They never read any manuals, usenet archives, and FAQ-sites.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Sat Sep 15 2001 - 11:36:02 CDT