Re: variables in sql-statements

Try this :
(it will only work in 8i)  

 declare
 tab_name varchar2(20);
 col_name varchar2(20);  

 begin
 tab_name:='labor';
 col_name:='name';  

 execute immediate('select * from ' || tab_name ||

                   ' where ' || col_name || ' =''ROM34''');
 

 end; Received on Wed Jun 13 2001 - 16:28:48 CEST