Re: PL/SQL - Variables in select statement

[Quoted] Take a look at the DBMS_SQL package. It provides the functionality that you need.

[Quoted] Phack wrote in message <7566pr$fgo$1_at_news.cybercity.dk>...
>I want to make the same select from several tables, and for that I want to
>create a stored procedure that I call with at parameter consisting of the
>table name. But I reach a dead-end of my knowledge and ability to find
>information about how the select statement can use the variable. I am
trying
>to do the following
>
>create or replase search_tabel (tabel_name IN varchar2) is
>
> cursor c_table is
> Select * from tabel_name
> where ...;
>
>Begin
> ...
>
>Apparrently this use of the parameter (tabel_name) is not valid. Could you
>help me with how I should do this, and if it is possible at all?
>
>Thank's in advance,
>
>Paw
>
>
Received on Tue Dec 15 1998 - 19:34:55 CET