Read the pl/sql users guide. You do NOT want to do a direct port from
SQLServer to Oracle. At work I had to deal with this - someone porting
their stored proc from SQL server to Oracle. They were trying to move their
150 lines of code to Oracle and I was able to do it in about 15 (didn't need
all those temp tables etc., just direct sql).
There are much different beasts and a direct port will fail.
Jim
"Harpreet Singh" <harpreet_at_ruksun.com> wrote in message
news:at7eof$953$1_at_news.vsnl.net.in...
> Hi
> For learning Oracle I am porting my SQL server code to Oracle. In SQL
> server if a variable has an DML stmt in it and if we want to execute that
> the syntax is
>
> set @Str = "Select * from abc"
> exec (@str)
>
> How do we do this in Oracle.
>
> --Harpreet
>
> --
> "Science is organized knowledge. Wisdom is organized life."
>
>
Received on Wed Dec 11 2002 - 09:58:57 CST
