数据库语句大全、

select deptNo,dName,loc form dept;
select * from dept;

column empno format 9999;
column ename format a8;
column mgr format 9999;
column job format 9999;
column sal format 9999.99;
column comm format 9999.99;
column deptNo format 9999;

column empno format 9999;
column ename format a8;
column mgr format 9999;
column job format a8;
column sal format 9999.99;
column comm format 9999.99;
column deptno format 9999;
column loc format a8;
column dname format a8;





grant connect resource 


selcet emp.empNo, emp.eName, emp.deptNo, dept.deptNo,dept.dName,dept.loc
from emp,dept where emp.deptNo = dept.deptNo and dept.loc = 'NEW YORK'