Re: converting transactSQL to PLSQL

Vince <vincent@ wrote:

> Hi there!
>
> I have some trSQL procedures to rewrite in PLSQL, is there any way to
> convert transactSQL code to PLSQL code...freewares..links...
> Anymay, what is the similar oracle exe for 'osql' of SQLServer, in
> order to insert by command shell SQL code ?
>
> Thanks a lot :)
> ++
> Vince

Not that you would want to use. There is a migration workbench from Oracle but what it writes will at best be syntactically correct: It will not be good code.

The most important consideration here should be that you would not want to just rewrite ... when you need to rearchitect. For example in Oracle one can, but never, uses temp tables. You are moving to an architecture where reads don't block writes and writes don't block reads and things work differently.

Get a copy of Tom Kyte's book Expert one-on-one Oracle, read it cover to cover but pay special attention to the first three chapters. It is going to be a far happier experience if you understand Oracle, make a few changes to the schema, and then code appropriately.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)