Re: changed from ms sql to oracle

See this article:
http://govt.oracle.com/~tkyte/ResultSets/index.html

Good Luck!

"mike" <skyxx_at_263.net> wrote in message news:8pkgbg$oab$1_at_news.cz.js.cn...
> hi all:
> i created a procedure in mssql like below:
> --------------------------------------
> create procedure getData
> ( @tblName varchar(20)
> )
> as
> Begin
> declare @sql varchar(100)
> select @sql= 'select * from ' + @tblName
> exec(@sql)
> End
> --------------------------------------
> now i want to change it to oracle what should i do?
>
> Received on Wed Sep 13 2000 - 07:20:39 CDT