How to get the 3rd column(i.e all the data along with the
column name)in a table?
- 2 Answers
- 7546 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
How do you optimize a stored procedure query?
What is foreign key in sql with example?
What is crud stand for?
What are the types of variable use in pl sql?
Are pl sql variables case sensitive?
What are the datatypes available in pl/sql ?
What is mutating error in pl sql?
How many clustered indexes can be created on a table?
How does sql*loader handles newline characters in a record? : aql loader
explain the advantages and disadvantages of stored procedure? : Sql dba
What is the source code of a program?
How do you explain an index?
how to extract a unit value from a date and time? : Sql dba
What is rtm in testing?
What is the advantage of index in sql?
