开发工具:
文件大小: 38kb
下载次数: 0
上传时间: 2012-10-16
详细说明： 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,'人民币'); ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
