Re: PL/SQL - Variables in select statement

From: Justin Stopforth <jstopforth_at_icon.co.za>
Date: Tue, 29 Dec 1998 08:32:40 GMT
Message-ID: <36889362.1178592_at_news.icon.co.za>


Check out the Dynamic SQL chapter in your nearest PL/SQL manual.

ciao

Justin

On Tue, 29 Dec 1998 02:06:38 GMT, "Phack" <phack_at_vip.cybercity.dk> wrote:

>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
>
>

Justin Stopforth
Custom Development Consultant
Oracle Cape Town (South Africa) Received on Tue Dec 29 1998 - 09:32:40 CET

Original text of this message