鏁版嵁鏌ヨ閮ㄥ垎娴嬮獙
姣忛
6
鍒嗭紝鍏?/p>
100
鍒嗭紝鏃堕棿
90
鍒嗛挓銆?/p>
瑕佹眰鎷疯礉鍛戒护鎴浘銆傚畬鎴愬悗锛屾敼鏂囦欢鍚嶄负锛氬鍙?/p>
+
濮撳悕
+
鏁版嵁鏌ヨ娴嬮獙锛屾彁浜ゃ�?/p>
鐩爣锛氭帉鎻″湪鏁版嵁琛ㄤ笂杩涜
select
鏌ヨ鎿嶄綔锛屽寘鎷瓙鏌ヨ銆侀泦鍚堟搷浣溿�佽繛鎺ユ煡璇㈢瓑銆?/p>
鍑嗗锛氭帴鏀舵枃浠?/p>
b.dmp
锛屽鍏ユ暟鎹簱鏁版嵁鏂囦欢锛屾娆℃搷浣滃潎鍦ㄨ鏁版嵁搴撲笂瀹屾垚銆?/p>
棣栧厛锛屽缓绔嬭繍琛岀幆澧冿紝鏈緥涓暟鎹〃瀹氫箟濡備笅锛?/p>
琛ㄤ竴锛?/p>
IT_EMPLOYEES
瀹冪敱缂栧彿
EMPLOYEE_ID
銆佸悕
FIRST_NAME
銆佸
LAST_NAME
銆侀偖绠?/p>
銆佺數璇濆彿鐮?/p>
PHONE_NUMBER
銆?/p>
閮ㄩ棬缂栧彿
JOB_ID
銆?/p>
钖祫
SALARY
銆?/p>
閮ㄩ棬缁忕悊缂栧彿
MANAGER_ID
鍜岄泧鍛樼敓
鏃?/p>
BIRTHDATE
涔濅釜灞炴�х粍鎴愩�?/p>
create table IT_EMPLOYEES
(
EMPLOYEE_ID NUMBER(6) not null unique,
FIRST_NAME V
ARCHAR2(20),
LAST_NAME VARCHAR2(25) not null,
EMAIL V
ARCHAR2(25),
PHONE_NUMBER V
ARCHAR(20),
JOB_ID V
ARCHAR2(10),
SALARY NUMBER(8,2),
MANAGER_ID NUMBER(6),
BIRTHDA
TE DATE;
);
瀹為獙鏁版嵁鍙嚜宸卞畾涔夛紝
濡傦細
000001
鍥?/p>
鏉?/p>
aa@163.com
11111111 001 2000 000000
锛?/p>
01-1
鏈?/p>
-1980
琛ㄤ簩锛?/p>
COUNTRIES
瀹冪敱鍥藉缂栧彿
COUNTRY_ID
銆佸浗鍚?/p>
COUNTRY_NAME
銆?/p>
REGION_ID
create table COUNTRIES
(
COUNTRY_ID NUMBER(6) not null unique,
COUNTRY_NAME V
ARCHAR2(20) not null,
REGION_ID NUMBER(6)
);
瀹為獙鏁版嵁鍙嚜宸卞畾涔夛紝
濡?/p>
3001 china 3,1001 france 1,2001 mexico 2,4001 egypt 4
琛ㄤ笁锛?/p>
EMPLOYEES
锛堢粨鏋勪笌
IT_EMPLOYEES
鐩镐技锛?/p>
瀹冪敱缂栧彿
EMPLOYEE_ID
銆佸悕
FIRST_NAME
銆佸
LAST_NAME
銆侀偖绠?/p>
銆佺數璇濆彿鐮?/p>
PHONE_NUMBER
銆?/p>
閮ㄩ棬缂栧彿
DEPARTMENT_ID
銆?/p>
钖祫
SALARY
鍜岄儴闂ㄧ粡鐞嗙紪鍙?/p>
MANAGER_ID
鍏釜灞炴�х粍鎴愩�?/p>
琛ㄥ洓锛氶儴闂ㄨ〃
DEPARTMENT
閮ㄩ棬缂栧彿
DEPARTMENT_ID
锛岄儴闂ㄥ悕
DEPARTMENT_NAME
锛屽湴鍖哄彿
location_id