PL/SQL question: how to use a parameter of a procedure as a table name for select statement???

I have a question on PL/SQL (Oracle 817)

I want to write a procedure to process a table but the table name and the col name are passed in the procedure as parameters.

Inside the procedure, I will have a select statement as follows:

     select <colName> from <tableName>

where colName and tableName are passed in as arguments.

Is this possible? If so, how to do it?

Thanks,
Terrence Received on Fri Apr 19 2002 - 09:14:16 CDT