SHARE
TWEET

Untitled

a guest Sep 22nd, 2017 86 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- Создайте индексно-организованную таблицу DEPT1. Заполните ее содержимым из DEPT.
  2. DROP TABLE DEPT1;
  3. CREATE TABLE DEPT1
  4. (
  5.     DEPTNO NUMBER(2,0) CONSTRAINT DEPTNO_NN NOT NULL,
  6.     DNAME VARCHAR2(14),
  7.     LOC VARCHAR2(13),
  8.     CONSTRAINT DEPTNO_PK PRIMARY KEY(DEPTNO)
  9. )
  10. ORGANIZATION INDEX;
  11. INSERT INTO DEPT1 VALUES (10, 'ACCOUNTING', 'NEW YORK');
  12. INSERT INTO DEPT1 VALUES (20, 'RESEARCH', 'DALLAS');
  13. INSERT INTO DEPT1 VALUES (30, 'SALES', 'CHICAGO');
  14. INSERT INTO DEPT1 VALUES (40, 'OPERATIONS', 'BOSTON')
  15. /
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top