alter user scott account unlock;
alter user scott identified by scott;
select e.empno,e.ename,d.dname from emp e join dept d on e.deptno=d.deptno;----内连接
select e.empno,e.ename,d.dname from emp e,dept d where e.deptno=d.deptno;----多表连接
insert into emp(empno,ename,job) values(9527,'EAST','SALESMAN');
select e.empno,e.ename,e.job,d.deptno,d.dname from emp e left join dept d on e.deptno=d.deptno;----左外连接(查询emp所有的记录)
select e.empno,e.ename,e.job,d.deptno,d.dname from emp e right join dept d on e.deptno=d.deptno;----右外连接(查询dept所有的记录)
select e.empno,e.ename,e.job,d.deptno,d.dname from emp e full join dept d on e.deptno=d.deptno;----完全外连接(查询emp,dept所有的记录)
----自然连接,自然连接强制要求表之间必须具有相同的列名称。
select empno,ename,job,dname from emp natural join dept where sal>2000;