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
Can we rollback truncate?
What is pls integer?
what is transaction? : Sql dba
What is left join in postgresql?
How do I add a primary key to a table?
Why is sql important?
What does joining a thread mean?
What is a temp table?
What is the difference between functions, procedures, and packages in pl/sql?
What are all the different normalization?
when MSQL8.0 is in market
What operating systems are supported by oracle sql developer?
What is an invalid partition table?
What is mdb stand for?
How do I make my sql query run faster?