Column Names of a table are stored in the data dictionary table user_tab

How to get the 3rd column(i.e all the data along with the
column name)in a table?

Question Posted / ramesh

2 Answers
7996 Views
Logica CMG, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

How can we debug in PL/SQL?

1090

What is data definition language?

1044

Why is a primary key important?

967

What is dense_rank in sql?

916

What are sql objects?

1012

What is a sql trace file?

977

How do you modify a column in sql?

938

What is dml with example?

1011

How do I run sql?

1093

What is the execution plan in sql?

973

Explain two easy sql optimizations.

960

What is record in pl sql?

1009

What is the difference between delete and truncate commands?

975

What is data profiling in sql?

1020

How do I run a pl sql program?

1064