How to get the 3rd column(i.e all the data along with the
column name)in a table?
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
Do we need commit after truncate?
What is pragma in sql?
what is the difference difference between procedure and packages
what are the differences between char and varchar? : Sql dba
What is output spooling in sql*plus?
What are inner outer left and right joins in sql?
How do you bind variables in pl sql?
Can you skip header records while loading? : aql loader
What is the difference between left outer join and left join?
How to run sql statements through the web interface?
What is the use of stored procedures?
What are tuples in sql?
What are commit, rollback, and savepoint?
what is 'trigger' in sql? : Sql dba
Does pdo prevent sql injection?