PL/SQL - Variables in select statement

From: Phack <phack_at_vip.cybercity.dk>
Date: Tue, 15 Dec 1998 18:40:28 +0100
Message-ID: <7566pr$fgo$1_at_news.cybercity.dk>

[Quoted] 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 [Quoted] to do the following

create or replase search_tabel (tabel_name IN varchar2) is

    cursor c_table is
    Select * from tabel_name
[Quoted] [Quoted]     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 - 18:40:28 CET