-
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
Vish M P
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|