Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL problem

SQL problem

From: Johannes <jori_at_young-world.com>
Date: Wed, 6 Sep 2000 15:10:41 +0200
Message-ID: <8p5fpb$c6tvb$1@ID-3532.news.cis.dfn.de>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US