list

SELECT
    column_id        AS col_no,
    column_name,
    data_type
FROM user_tab_columns
WHERE table_name = UPPER('your_table_name')
ORDER BY column_id;