Can I retrieve column name using the column number of that column in the table? If yes then how?

Questions by deshaniprashant

Showing Answers 1 - 2 of 2 Answers

RK

  • Apr 24th, 2006
 

FOR EXAMPLE TO RETRIEVE 2ND COLUMN(ENAME)  IN EMP TABLE:

SELECT COLUMN_NAME FROM USER_TAB_COLUMNS

WHERE TABLE_NAME ='EMP'

AND COLUMN_ID = 2

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions