Urgent -Search column name by column number

[suhas mahajan]

Hi All,
How do we get exact column name by giving its column number?

Scenario,
We need to find column name by its position number in table.

E.g. I have emp table having fields (eno, ename, addr, email)

Now I will put the condition in where clause ---

Where column_number=2;
then it should take the ename. and returns the value.


How can I achieve it.

Thank in advance