Is there a table to select all the column names for any table???
Thanks
SM
[Edited by supermega on 10-24-2000 at 11:48 AM]
Is there a table to select all the column names for any table???
Thanks
SM
[Edited by supermega on 10-24-2000 at 11:48 AM]
Hi supermega.
If you are using TOAD, you can select a column name(not all columns) in all tables.
Thanks
ABC
select name from sys.col$;
you must be either sys or have dba access.
DBA_TAB_COLUMNS, columns of all tables, views and clusters in the database.
Hi
ALL_TAB_COLUMNS will also be able to fetch u the table_name and its column names.See if this is Ok for u
Bye