参考:https://blog.csdn.net/anmic123/article/details/81102399
打开cmd登录:
方式1:以超级用户登录
sqlplus / as sysdba(sysdba为超级用户)
方式二:以普通用户登录,如scott
sqlplus user/password (user填写你的用户,password填写你的密码)(我的用户是scott,密码是123)
1.查看SCOTT用户有哪些表:
select TABLE_NAME from all_tables where owner = 'SCOTT';
2.查看SCOTT用户下4个练习表的结构:
desc y_dept; (y_dept为你要查询的表名)(describe描述)
3.查询‘SMITH’的领导姓名:
SELECT ENAME FROM EMP WHERE EMPNO=(SELECT MGR FROM EMP where ENAME='SMITH');
4.查询部门名称是’ACCOUNTING’的员工姓名及薪水等级:
select ename,grade from emp ,salgrade ,dept where dname='ACCOUNTING' and sal between LOSAL and HISAL and EMP.deptno = DEPT.deptno ;
注:'ACCOUNTING'必须是单引号,双引号报错。
5.查询工作职位是’manager’的员工姓名,部门名称和薪水等级:
select ename,dname,grade from emp,dept,salgrade where job='MANAGER' and sal BETWEEN LOSAL and HISAL and EMP.DEPTNO=DEPT.DEPTNO;
6.查询公司中薪水最高的员工信息:
select * from emp where sal=(select max(sal) from emp);