Computer(IT)/Oracle

Oralce base query ex

약탄치킨 2011. 1. 20. 08:02
반응형
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;

반응형