5 Replies Latest reply: Jul 29, 2013 10:41 AM by 4280d4a5-e01a-4515-a3fb-ce430d118bf8 RSS

    why does this select statement fail.....

    4280d4a5-e01a-4515-a3fb-ce430d118bf8


      declare
      t_name varchar2(100):='america';
      begin
      execute immediate '
      select * from'|| t_name;
      end;