Interested to Buy Any Domain ? << Click Here >> for more details...
How to get the 3rd column(i.e all the data along with the
column name)in a table?
- 2 Answers
- 8220 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
What are the disadvantages of not performing database normalization?
What is an example of translating a date into julian format?
What is a record in a database?
What is difference between ms sql and mysql?
What is sql and db2?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
How to convert comma separated string to array in pl/sql?
What is scope and visibility in PL/SQL?
How do I save a sql query?
what are the different type of normalization? : Sql dba
Why do we use partitions in sql?
What are pl/sql packages?
Which data dictionary views have the information on the triggers that are available in the database?
what is union? : Sql dba
What are sql constraints?
