Column name display from Data Dictionary Table.

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


 

Muhammad Abdullah Al Noor

Muhammad Abdullah Al Noor, An Oracle Apex Consultants and founder of Noors Technology (www.noorstech.com). Core Expertise : Database Administration, Oracle Forms and Reports Development, Oracle Apex Application Designer and Development, Linux Professional etc. Also the owner of TrainerBD Training and OraDemy E-Learning. WhatsApp +8801790721177

Post a Comment

Previous Post Next Post