Re: SQL problem

Replace <schemaowner> by schemaowner||'.'|| if you have such a variable.

Hth,

Sybrand Bakker, Oracle DBA

"Johannes" <jori_at_young-world.com> wrote in message news:8p5fpb$c6tvb$1_at_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 - 11:14:47 CDT