tig mark as string [message #1724] |
Fri, 24 May 2002 04:49 |
Lars Winter
Messages: 1 Registered: May 2002
|
Junior Member |
|
|
Hi,
I like to use a tig mark as a string. How can I mark the tig mark in my select statement?
Example:
SELECT 'SELECT '||TABLE_NAME||' AS TABLE_NAME,
COUNT (*)
FROM '||TABLE_NAME||';' AS SQL
FROM USER_TABLES;
I like to have the first TABLE_NAME in the result with
tig marks('TABLE_NAME')
Kind Regards,
Lars
|
|
|
Re: tig mark as string [message #1726 is a reply to message #1724] |
Fri, 24 May 2002 05:10 |
Miguel
Messages: 14 Registered: April 2001
|
Junior Member |
|
|
You need to use multiple tick (tig) marks and Concatenate them, like this
select 'select '''||table_name||''''
from user_tables
this will return:
select 'Table1'
select 'Table2'
select 'Table3'
HTH
Miguel
|
|
|