아래처럼 자동으로 컬럼명들이 들어간다!!



SELECT
EMPLOYEE_ID, FIRST_NAME, LAST_NAME,
   EMAIL, PHONE_NUMBER, HIRE_DATE,
   JOB_ID, SALARY, COMMISSION_PCT,
   MANAGER_ID, DEPARTMENT_ID
FROM HR.EMPLOYEES;




 UPDATE HR.EMPLOYEES
SET    EMPLOYEE_ID    = :EMPLOYEE_ID,
       FIRST_NAME     = :FIRST_NAME,
       LAST_NAME      = :LAST_NAME,
       EMAIL          = :EMAIL,
       PHONE_NUMBER   = :PHONE_NUMBER,
       HIRE_DATE      = :HIRE_DATE,
       JOB_ID         = :JOB_ID,
       SALARY         = :SALARY,
       COMMISSION_PCT = :COMMISSION_PCT,
       MANAGER_ID     = :MANAGER_ID,
       DEPARTMENT_ID  = :DEPARTMENT_ID
WHERE  EMPLOYEE_ID    = :EMPLOYEE_ID
;


INSERT INTO HR.EMPLOYEES (
   EMPLOYEE_ID, FIRST_NAME, LAST_NAME,
   EMAIL, PHONE_NUMBER, HIRE_DATE,
   JOB_ID, SALARY, COMMISSION_PCT,
   MANAGER_ID, DEPARTMENT_ID)
VALUES ( /* EMPLOYEE_ID */,
 /* FIRST_NAME */,
 /* LAST_NAME */,
 /* EMAIL */,
 /* PHONE_NUMBER */,
 /* HIRE_DATE */,
 /* JOB_ID */,
 /* SALARY */,
 /* COMMISSION_PCT */,
 /* MANAGER_ID */,
 /* DEPARTMENT_ID */ );