Oracle 资料 第4章 SQL查询 CREATE TABLE employees ( employee_id NUMBER, employee_name VARCHAR2(20), employee_position VARCHAR2(20), employee_age NUMBER, employee_address VARCHAR2(100) ); INSERT INTO employees(employee_id,employee_name,employee_position,employee_age,employee_address) VALUES (1,'王晓','开发经理',37,'解放北路23号'); INSERT INTO employees(employee_id,employee_name,employee_position,employee_age,employee_address) VALUES (2,'钟小平','高级工程师',32,'建设3路12号'); INSERT INTO employees(employee_id,employee_name,employee_position,employee _age,employee_address) VALUES (3,'刘俊','高级工程师',27,'人民路20号'); INSERT INTO employees(employee_id,employee_name,employee_position,employee_age,employee_address) VALUES (4,'王龙','工程师',26,'前进路27号'); INSERT INTO employees(employee_id,employee_name,employee_position,employee_age,employee_address) VALUES (5,'钟文','工程师',26,'大风路15号'); INSERT INTO employees(employee_id,employee_name,employee_position,employee_age,employee_address) VALUES (6,'张三','测试工程师',25,'前进路18号'); INSERT INTO employees(employee_id,employee_name,employee_position,employee_age,employee_address) VALUES (7,'李四','测试工程师',24,'前进路27号'); INSERT INTO employees(employee_id,employee_name,employee_position,employee_age,employee_address) VALUES (8,'王五','测试工程师',25,'前进路66号'); CREATE TABLE salary ( salary_id NUMBER, employee_id NUMBER, month VARCHAR2(20), salary NUMBER, currency VARCHAR2(10) ); INSERT INTO salary(salary_id,employee_id,month,salary,currency) VALUES (1,1,'1月',8500,'人民币'); INSERT INTO salary(salary_id,employee_id,month,salary,currency) VALUES (2,2,'1月',6800,'人民币'); INSERT INTO salary(salary_id,employee_id,month,salary,currency) VALUES (3,3,'1月',4000,'人民币'); INSERT INTO salary(salary_id,employee_id,month,salary,currency) VALUES (4,4,'1月',4000,'人民币'); INSERT INTO salary(salary_id,employee_id,month,salary,currency) VALUES (5,5,'1月',4500,'人民币'); INSERT INTO salary(salary_id,employee_id,month,salary,currency) VALUES (6,1,'2月',8500,'人民币'); INSERT INTO salary(salary_id,employee_id,month,salary,currency) VALUES (7,2,'2月',6800,'人民币'); INSERT INTO salary(salary_id,employee_id,month,salary,currency) VALUES (8,3,'2月',4000,'人民币'); INSERT INTO salary(salary_id,employee_id,month,salary,currency) VALUES (9,4,'2月',4000,'人民币'); INSERT INTO salary(salary_id,employee_id,month,salary,currency) VALUES (10,5,'2月',4500,'人民币');