declaret_name varchar2(100):='america';beginexecute immediate 'select * from'|| t_name;end;
Why don't you tell us? You didn't even post the error message.
You missed a space after from
execute immediate 'select * from '|| t_name;
Because it looks like you need to add a space after 'from' and add an INTO CLAUSE?
introduction to bulk pl/sql enhancements in 9i
sorry i forgot it....
the error message :00923. 00000 - "FROM keyword not found where expected"
thank you, i should have try to solve it by more tries....