[ORACLE] (Scott User) Create Table SALGRADE (Test) [오라클]

--오라클 테스트 테이블 SALGRADE 생성입니다.

CREATE TABLE SALGRADE
(
   GRADE   NUMBER,
   LOSAL   NUMBER,
   HISAL   NUMBER
)
TABLESPACE tablespaceName
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (INITIAL 64 K
         NEXT 1 M
         MINEXTENTS 1
         MAXEXTENTS UNLIMITED
         PCTINCREASE 0
         BUFFER_POOL DEFAULT)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;

INSERT INTO SALGRADE (GRADE, LOSAL, HISAL)
     VALUES (1, 700, 1200);

INSERT INTO SALGRADE (GRADE, LOSAL, HISAL)
     VALUES (2, 1201, 1400);

INSERT INTO SALGRADE (GRADE, LOSAL, HISAL)
     VALUES (3, 1401, 2000);

INSERT INTO SALGRADE (GRADE, LOSAL, HISAL)
     VALUES (4, 2001, 3000);

INSERT INTO SALGRADE (GRADE, LOSAL, HISAL)
     VALUES (5, 3001, 9999);

COMMIT;