SQL ORACLE

Ĉ¿ Segue abaixo alguns exemplos:

1- SELECT *
FROM SALGRADE;

2- SELECT *
FROM EMP;

3- SELECT ENAME, DEPTNO, SAL
FROM EMP
WHERE SAL BETWEEN 1000 AND 2000;

4- SELECT DEPTNO, JOB
FROM DEPT
ORDER BY DNAME;

5- SELECT DISTINCT JOB
FROM EMP;

6- SELECT *
FROM EMP
WHERE DEPTNO IN (10,20)
ORDER BY ENAME;

7- SELECT ENAME, JOB
FROM EMP
WHERE JOB = 'CLERK'
AND DEPTNO = 20;

8- SELECT ENAME
FROM EMP
WHERE ENAME LIKE '%TH%'
OR ENAME LIKE '%LL%';

9- SELECT ENAME, JOB, SAL
FROM EMP
WHERE MGR IS NOT NULL;

10- SELECT ENAME, SAL*12+NVL(COMM,0) REMUNERATION
FROM EMP;

11- SELECT ENAME, DEPTNO, HIREDATE
FROM EMP
WHERE HIREDATE LIKE '%83';

12- SELECT ENAME, SAL*12 ANNUAL_SAL, COMM
FROM EMP
WHERE SAL>COMM
AND JOB = 'SALESMAN'
ORDER BY SAL DESC, ENAME:

13- SELECT ENAME||
' HAS HELD THE POSITION OF '||
JOB||
' IN DEPT '||
DEPTNO||
' SINCE '||
HIREDATE "Who, what and when"
FROM EMP;

14- SELECT *
FROM EMP
ORDER BY NVL(MGR,9999);