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
- 8211 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 is bdb (berkeleydb)? : Sql dba
What is an ndf file?
What is clause?
What is the difference between Union and Union all. Which is faster.
Does group by remove duplicates?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
what is the difference between sql and t-sql? : Transact sql
What is offset and limit in sql?
Why do we need view in sql?
What are the differences between implicit and explicit cursors?
What are pl/sql cursor exceptions?
What are different types of functions in sql?
give the syntax of grant and revoke commands? : Sql dba
What are sql functions? Describe in brief different types of sql functions?
what is 'mysqladmin' in mysql? : Sql dba
