Column Name Display from Data Dictionary table:
SELECT COLUMN_NAME
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME='EMPLOYEES'
ORDER BY COLUMN_ID;
output :
COLUMN_NAME
-----------------------
EMPLOYEE_ID
FIRST_NAME
LAST_NAME
EMAIL
PHONE_NUMBER
HIRE_DATE
JOB_ID
SALARY
COMMISSION_PCT
MANAGER_ID
DEPARTMENT_ID
Tags:
Oracle SQL