Re: PL/SQL: variable column & table name in select

In article <93jngj$j0o$1_at_alpha.main.vsu.ru>,   "Viatcheslav V. Kopeikin" <kvv_at_main.vsu.ru> wrote:
> Hi, All!
> Help me please, I've broken my head on this problem :). The situation
 is as
> follows: I need making a procedure on PL/SQL to get the max number
 of the
> first column in any table (of course if this column is numeric). How
 can I
> say in SELECT "first column in any table"? The procedure looks
 something
> alike:
> procedure max_number (table_name varchar2,
> maxnum number) is
> begin
> select max([What here?]) into maxnum from [What here?];
> dbms_output.enable;
> dbms_output.put_line('maxnum='||to_char(maxnum));
> end max_number;
>
> WBR, Viatcheslav.
>
>

In Oracle 7 and Oracle 8.0, you need to use dbms_sql to accomplish this. In Oracle 8i you can use Native Dynamic SQL. If you want a more specific answer, please post which version you are using.

Hth,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/