Can one use dynamic SQL statements from PL/SQL?
How can I use a variable for the columns/tables in the select statements?

try using execute immediate 'sql statement' ;

yes,u can use dynamic sql statements in pl/sql.check the below code..

declare

        v_empno emp.empno%type  :=&empno;

       v_ename emp.ename%type;

       v_sal emp.sal%type;

begin

     select ename,sal  into v_ename,v_sal from emp where empno=v_empno;

     dbms_output.put_line('name  : '||v_ename||'    sal is  :'||v_sal);

end;

(u have to set the serveroutput environment option to on)

This is also another method..

 Oracle Supports a built-in package

DBMS_SQL by this we can execure

We must use the following methods.

 PARSE()

BIND()

Thanks&REgds

Ramki,TCS,Hyd

You can use execute_imediate in PL/SQL.