emp 表創(chuàng)建語句 包含哪些字段？
視頻中提出的emp表 中有哪些字段？ 有沒有創(chuàng)建表時的sql 語句？
qq_云端_8
2019-05-29
2 回答
舉報
0/150
提交
取消
2019-07-10
解鎖scott用戶后自帶表。
? CREATE TABLE "SCOTT"."EMP"?
? ?( "EMPNO" NUMBER(4,0),?
"ENAME" VARCHAR2(10 BYTE),?
"JOB" VARCHAR2(9 BYTE),?
"MGR" NUMBER(4,0),?
"HIREDATE" DATE,?
"SAL" NUMBER(7,2),?
"COMM" NUMBER(7,2),?
"DEPTNO" NUMBER(2,0),?
CONSTRAINT "PK_EMP" PRIMARY KEY ("EMPNO")
? USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS?
? STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
? PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
? TABLESPACE "USERS"? ENABLE,?
CONSTRAINT "FK_DEPTNO" FOREIGN KEY ("DEPTNO")
? REFERENCES "SCOTT"."DEPT" ("DEPTNO") ENABLE
? ?) SEGMENT CREATION IMMEDIATE?
? PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
? STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
? PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
? TABLESPACE "USERS" ;
2019-06-05
scott 用戶下自帶表