How to get the 3rd column(i.e all the data along with the
column name)in a table?
Answer Posted / ramesh
Column Names of a table are stored in the data dictionary
table user_tab_columns along with column_id. By referring
column_id we can display the column name as :
select column_name from user_tab_columns where table_name
= 'EMP' and column_id = 3;
Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
Which join is default?
Is sql procedural language?
Is oracle and sql same?
What is raw datatype in sql?
How many clustered indexes can you have?
How can you get sql*loader to commit only at the end of the load file? : aql loader
How to order siblings in oracle hierarchy queries?
What is difference between pl and sql?
Does postgresql run on the cloud?
How do sql triggers work?
How do I run a program in pl sql?
What are the qualities of 2nf?
What is the file extension for sql database?
What are sql constraints?
What is sql exception?