Re: changed from ms sql to oracle

mike wrote:
>
> 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?

You *definetly* should RTFM.

Get familiar with "PL/SQL User's Guide and Reference" and DBMS_SQL package.

Juhan

-- 
+-----------------+
|NB! Please remove|
|   .NICHT-SPAM   |
|  when replying  |
|    to get my    |
|     *REAL*      |
| e-mail address! |
|                 |
|  Cheers, Juhan  |
+-----------------+