Can i use Select * from variable_name;

Hi,

I wonder can I select from some table such that table name is stored in a variable.i.e;

DECLARE
   tablename varchar(5);
BEGIN
   tablename:='table';
   select * from tablename;
END;
/

Thanks,
Cheema Received on Sun Aug 19 2007 - 21:41:02 CDT