반응형
CREATE TABLE EMPEX
(
EMPNO NUMBER(4) NOT
NULL,
ENAME VARCHAR2(10) ,
JOB VARCHAR2(9) ,
MGR NUMBER(4) ,
HIREDATE DATE ,
SAL NUMBER(7,2) ,
COMM NUMBER(7,2) ,
DEPTNO NUMBER(2) ,
PRIMARY KEY(EMPNO)
) ;
COMMENT ON TABLE EMPEX IS '사원테이블'
COMMENT ON COLUMN EMPEX.EMPNO IS
'사원번호'
COMMENT ON COLUMN EMPEX.ENAME IS
'사원이름'
COMMENT ON COLUMN EMPEX.JOB IS
'업무'
COMMENT ON COLUMN EMPEX.MGR IS
'직속상관'
COMMENT ON COLUMN EMPEX.HIREDATE IS '입사일'
COMMENT ON COLUMN EMPEX.SAL IS
'월급여'
COMMENT ON COLUMN EMPEX.COMM IS
'인센티브'
COMMENT ON COLUMN EMPEX.DEPTNO IS
'부서코드'
@C:\EMPEX.SQL;
INSERT INTO EMP (EMPNO, HIREDATE, DEPTNO)
VALUES(5555,TO_DATE('2007','YYYY'),30);
SELECT EMPNO, HIREDATE, DEPTNO
FROM EMP;
UPDATE EMP
SET DEPTNO = '10' WHERE ENAME ='SMITH';
SELECT *FROM EMP;
DELETE FROM EMP
WHERE JOB IS NULL;
반응형