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

"Viatcheslav V. Kopeikin" wrote:

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

I think there's no way to do it using embedded SQL. Use dynamic SQL instead.

Regards, Cristian

-- 

Cristian Veronesi ><(((( > http://www.crpa.it

General rule for life: avoid pain for as long as possible
unless doing so will ultimately cause more pain.