Help::: Convertng Sql(T-Sql) Stored Proc To Oracle(Pl-Sql)

[mtkr]

[quote name='cherlapalli_jailer' timestamp='1355172514' post='1302926761']


no need to connect to DB

Store ur function in a file and convert

After see ur Q
I downloaded and converted and pasted the result also

Kaani as i suggested complete convertion not advisable..specific conversion and syntax is good

Coz some times those tools take long route to get the solution
[/quote]
thnx mama...
wil chk

[mtkr]

...

[deals2buy]

future lo same thaadu naaku panikostademo

[Ka NTR i]

Oracle SQL developer lo vuntadhi mama conversions.

Go to Tools>Migration>Translation Scratch Editor>

two windows open avuthai.... first window lo top left corner lo select chesuko.. "Microsoft SQL server T-SQL to PL/SQL" and then copy your T-SQL code into first window and then click on ">>" button. you will get equivalent PL/SQL code. If you know PL/SQL you could understand the PL/SQL code and then modify it accordingly as per your requirement.

Note:1.Oracle SQL developer is free s/w. you can download it from Oracle site.
2. You do not need to connect to any Data Base.
3. Translated Pl/SQL is not 100% correct. you might need to modify as per PL/SQL best practices...

Let me know if you need any more help.

[mtkr]

[quote name='deals2buy' timestamp='1355190502' post='1302929027']
future lo same thaadu naaku panikostademo
[/quote]

Might be

[mtkr]

[quote name='BlueBerry' timestamp='1355190748' post='1302929043']
Oracle SQL developer lo vuntadhi mama conversions.

Go to Tools>Migration>Translation Scratch Editor>

two windows open avuthai.... first window lo top left corner lo select chesuko.. "Microsoft SQL server T-SQL to PL/SQL" and then copy your T-SQL code into first window and then click on ">>" button. you will get equivalent PL/SQL code. If you know PL/SQL you could understand the PL/SQL code and then modify it accordingly as per your requirement.
[/quote]

oracle sql dev ante 3 rd party tool aa mama???

[Ka NTR i]

[quote name='mtkr' timestamp='1355190970' post='1302929052']
oracle sql dev ante 3 rd party tool aa mama???
[/quote]
No its Oracle's tool.

[mtkr]

[quote name='BlueBerry' timestamp='1355190748' post='1302929043']
Oracle SQL developer lo vuntadhi mama conversions.

Go to Tools>Migration>Translation Scratch Editor>

two windows open avuthai.... first window lo top left corner lo select chesuko.. "Microsoft SQL server T-SQL to PL/SQL" and then copy your T-SQL code into first window and then click on ">>" button. you will get equivalent PL/SQL code. If you know PL/SQL you could understand the PL/SQL code and then modify it accordingly as per your requirement.

Note:1.Oracle SQL developer is free s/w. you can download it from Oracle site.
2. You do not need to connect to any Data Base.
3. Translated Pl/SQL is not 100% correct. you might need to modify as per PL/SQL best practices...

Let me know if you need any more help.
[/quote]

let me try it n wil get bck 2 u...
thnx a lot mama..

[lolliman]

[quote name='mtkr' timestamp='1355191054' post='1302929057']
let me try it n wil get bck 2 u...
thnx a lot mama..
[/quote]


idi best option anukuntaaa baaa... try this one

[mrudhula99]

Good one..

informative

[lolliman]

[quote name='mrudhula99' timestamp='1355193293' post='1302929188']
Good one..

informative
[/quote]

[mtkr]

[quote name='lolliman' timestamp='1355193092' post='1302929173']



idi best option anukuntaaa baaa... try this one
[/quote]
ya mama....
thnx

[quote name='mrudhula99' timestamp='1355193293' post='1302929188']
Good one..

informative
[/quote]

ans/suggsn ei ante sappatlu koduthu dancingulu kaduthunnavaa!!!

[mrudhula99]

[quote name='mtkr' timestamp='1355193951' post='1302929240']
ya mama....
thnx



ans/suggsn ei ante sappatlu koduthu dancingulu kaduthunnavaa!!!
[/quote]
nakem radhu mtkr..

naku kuda stored proc nerchukovalani undhiii.. ee thread bookmark cheskunnaa...

malli nenu edho oka cooment cheyyaganee comedy chestharu... spamming start ayyedhiii.. andhukee em cheppatledhu....


job vcahindhaa????

[Silver_mani]

iTeachSAP

[lolliman]

[quote name='Silver_mani' timestamp='1355197033' post='1302929491']
iTeachSAP
[/quote]


deeniki you da man uncle (!>< (!><