Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- Создайте индексно-организованную таблицу DEPT1. Заполните ее содержимым из DEPT.
- DROP TABLE DEPT1;
- CREATE TABLE DEPT1
- (
- DEPTNO NUMBER(2,0) CONSTRAINT DEPTNO_NN NOT NULL,
- DNAME VARCHAR2(14),
- LOC VARCHAR2(13),
- CONSTRAINT DEPTNO_PK PRIMARY KEY(DEPTNO)
- )
- ORGANIZATION INDEX;
- INSERT INTO DEPT1 VALUES (10, 'ACCOUNTING', 'NEW YORK');
- INSERT INTO DEPT1 VALUES (20, 'RESEARCH', 'DALLAS');
- INSERT INTO DEPT1 VALUES (30, 'SALES', 'CHICAGO');
- INSERT INTO DEPT1 VALUES (40, 'OPERATIONS', 'BOSTON')
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement