Oracle简单查询，常用函数（SQL语句集）

--全表查询
SELECT * FROM 表名;
SELECT * FROM EMP;
--字段查询
SELECT 字段,字段 FROM 表名;
SELECT EMPNO,ENAME,SAL,DEPTNO FROM EMP;
--查询所有用户
SELECT USERNAME FROM DBA_USERS;
--查看用户的表
SELECT TABLE_NAME FROM USER_TABLES;
SELECT TABLE_NAME FROM DBA_TABLES WHERE OWNER='SYS';
--查看表结构
SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME='EMP';
--条件查询
SELECT 字段... FROM 表名 WHERE 条件;
SELECT * FROM EMP WHERE SAL>2000;
SELECT * FROM EMP WHERE SAL>2000 AND SAL<3000;
SELECT * FROM EMP WHERE SAL BETWEEN 2000 AND 3000;
SELECT * FROM EMP WHERE DEPTNO =10;
--逻辑查询 OR 或 AND 与
SELECT * FROM EMP WHERE DEPTNO=10 AND JOB='MANAGER'
SELECT * FROM EMP WHERE DEPTNO=20 AND JOB='ANALYST';
SELECT * FROM EMP WHERE (DEPTNO=10 AND JOB='MANAGER') OR (DEPTNO=20 AND JOB='ANALYST');
--IN
SELECT * FROM EMP WHERE EMPNO=7782 OR EMPNO=7788 OR EMPNO=7369;
SELECT 字段 FROM EMP WHERE 字段 IN(字段值);
SELECT * FROM EM