build / execute string in stored procedure 1

[vadimg]

hi gurus.
Newbie to Oracle.

I need to pass a table name as a parameter to a stored procedure and then select from that table.

In sql server this would require building / executing a string (code below). What would be the equivalent syntax in pl-sql?

Alternatively, can you use a variable table name in a select statement in pl-sql?

create procedure blah @table nvarchar(255)
as
declare @command varchar(8000)
select  @command = 'select * from '+@table
exec sp_executesql @command

thanks!

 

[LKBrwnDBA]

About the same:

create procedure blah (table varchar2)
is
command varchar(8000);
Begin
 command:= 'select * from '||table;
 execute immediate command into ...;
End;
...

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb