摘要：
--1.列出至少有三个员工的所有部门和部门信息。SELECT D.DEPTNO, D.DNAME, D.LOC, T.COUNTS FROM DEPT D, (SELECT DEPTNO, COUNT(*) COUNTS FROM EMP GROUP BY DEPTNO) T WHERE D.DEPTNO = T.DEPTNO AND T.COUNTS >= 3; --2.列出受雇日... 阅读全文
posted @ 2017-09-16 20:32
Guangqin_Hu
阅读(2828)
评论(0)
推荐(0)
摘要：
--查询出当前用户下的所有表select table_name from user_tables;--执行顺序原则： from where group by having select order by--书写顺序原则： select from where group by having order by select * from dept;select * from ... 阅读全文
posted @ 2017-09-16 20:31
Guangqin_Hu
阅读(433)
评论(0)
推荐(0)
摘要：
select * from regions;select * from countries;select * from locations;select * from departments;select * from jobs;select * from employees;select * from job_history;1. 查询工资大于12000的员工姓名和工资select '姓名:' ... 阅读全文
posted @ 2017-09-16 20:30
Guangqin_Hu
阅读(317)
评论(0)
推荐(0)
摘要：
一.Oracle数据库的安装(安装在虚拟机的xp系统里) 1.安装虚拟机 2.虚拟机内安装xp系统,以下步骤在虚拟机内进行 3.双击setup.exe,在出现的界面中设置口令,及确认口令(此口令即为system账号的密码),点击下一步 4.先决条件检查,将"用户已验证前面的复选框打勾,下一步 5.概要界面,点击安装 6.安装完成后,自动运行配置向导 ... 阅读全文
posted @ 2017-09-16 20:29
Guangqin_Hu
阅读(621)
评论(0)
推荐(0)
浙公网安备 33010602011771号