help with dinamic sql [message #57448] |
Mon, 16 June 2003 15:56 |
Eugene
Messages: 44 Registered: August 2001
|
Member |
|
|
I need to come up with sql that dinamically build a list of columns for the table. Can someone help me with that, plese? Here is the sql that I am running:
select column_name||','
from all_tab_columns
where table_name = 'PHPICK00' and
column_name not in ('BATCH_ID','ARCHIVE_BY','ARCHIVE_DATE')
order by column_id
Thanks,
Eugene
|
|
|
|
Re: help with dinamic sql [message #57461 is a reply to message #57450] |
Tue, 17 June 2003 08:37 |
Eugene
Messages: 44 Registered: August 2001
|
Member |
|
|
Thanks Maaher,
How about adding owner = (schema_owner) to the query?
All I need is to build dynamic sql to be like that:
select (list of columns)
from dba_tab_columns
where owner = (schema owner) and
table_name = (table name)
Is it possible via dynamic sql?
Eugene
|
|
|
|