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
- 8093 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 a unique key?
give the syntax of grant and revoke commands? : Sql dba
What are different functions in sql?
What is pessimistic concurrency control? : Transact sql
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What is sql not null constraint?
how is myisam table stored? : Sql dba
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What's the difference between a primary key and a clustered index?
Can we create index on primary key?
List different type of expressions with the example.
What is out parameter used for eventhough return statement can also be used in pl/sql?
How to add, remove, modify users using sql?
Can ddl statements be used in pl/sql?
What are reports usually used for?
