컬럼명 편하게 넣어보자
Toad / 2012.01.18 06:24
아래처럼 자동으로 컬럼명들이 들어간다!!
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 */ );
'Toad' 카테고리의 다른 글
| 컬럼명 편하게 넣어보자 (0) | 2012.01.18 |
|---|---|
| 예약어 대문자로 자동변환 (0) | 2012.01.18 |
| null값 노란색 배경으로 변경 (0) | 2012.01.18 |