Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> SQL problem
Hi everybody,
does anyone know the reason why following statment produces just a
string-output, but is
not executed?
entered statement: select 'select * from <SchemaOwner>.' || table_name ||
';' from dba_tables where table_name like'%TPFHT'; output-string: select * from <SchemaOwner>.xyzTPFHT;
Thanx for every tip!
Bye
Johannes
Received on Wed Sep 06 2000 - 08:10:41 CDT
![]() |
![]() |