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
- 8143 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 many types of functions are there in sql?
how to create a table index in mysql? : Sql dba
what are the difference between clustered and a non-clustered index? : Sql dba
how are mysql timestamps seen to a user? : Sql dba
describe transaction-safe table types in mysql : sql dba
Is id a reserved word in sql?
Why commit is not used in triggers?
What is a unique key?
Does oracle use sql?
What is an example of translating a date into julian format?
What is the difference between a primary key and a clustered index?
what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql
What is the meaning of disabling a trigger?
what is a constraint? : Sql dba
What is difference between sql and mysql?
