Cherry's Playground
Journey
Home
Menu 1
Drop 1-1
Drop 1-2
Drop 1-3
Menu 2
Drop 2-1
Drop 2-2
Menu 3
Drop 3-1
Drop 3-2
Drop 3-3
Drop 3-4
Menu 4
Menu 5
AllBlogTools
Monday, August 11, 2008
Select column name from table
To select column names of a given table you can use the following query:
Select
column_name
from
user_tab_cols
where table_name
='TABLE_NAME';
Remember the table name should be in capital letters.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment