User_Tab_Columns1

SELECT COLUMN_ID, COLUMN_NAME, DATA_TYPE FROM USER_TAB_COLUMNS WHERE TABLE_NAME ='EMP' ORDER BY COLUMN_ID