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
- 8025 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 to get help at the sql prompt?
What is difference between sql and mysql?
What is multiple columns?
how do you know the version of your mysql server? : Sql dba
Cite the differences between execution of triggers and stored procedures?
Write a sql select query that only returns each name only once from a table?
What do you know by pl/sql cursors?
What are the basic sql commands?
What are tables in sql?
How to create an array in pl/sql?
What is a variable in sql?
What is the use of desc in sql?
What is cursor in pl sql with examples?
Which certification is best for sql?
How can we make an if statement within a select statement?
