How to get field names from empty table by using SELECT statement;

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 8th, 2008

SELECT   cnameFROM   COLWHERE   Tname ='EMP'/*Any table can be used here*/;

hemant.agarwal03

 Profile Answers by hemant.agarwal03 Questions by hemant.agarwal03

• Mar 18th, 2008

Select column_name from user_tab_columns where table_name = ''/

Answer Question  Select Best Answer