How to get the 3rd column(i.e all the data along with the
column name)in a table?
- 2 Answers
- 7378 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 can I use instead of union in sql?
What is indexing in sql and its types?
what is difference between delete and truncate commands? : Sql dba
tell me about various levels of constraint. : Sql dba
Explain constraints in sql?
Give the order of sql select?
What is t sql in sql server?
Is not equal in sql?
What are the different datatypes available in PL/SQL?
Can sql function call stored procedure?
What is bulk collect in pl sql?
What is replication id?
How many parts of a pl sql block are optional?
What do you understand by exception handling in pl/sql?
How to add, remove, modify users using sql?
