Laboratorul Nr.2
2
Exercitiul 1. SELECT empno, ename, job, hiredate FROM emp; Exercitiul 3. SELECT distinct job FROM emp; Exercitiul 5. SELECT ename ||','||' '|| job as "Employee and Title" From emp; Exercitiul 6. desc emp SELECT empno ||','|| ename ||','|| job ||','|| hiredate ||','|| sal as THE_OUTP UT FROM emp; Exercitiul 7. 7.1 SELECT empno, ename, job, hiredate FROM emp WHERE hiredate between '20-FEB-81' and '01-MAY-81'; 7.2 SELECT empno, ename, job, hiredate FROM emp WHERE hiredate between '20-FEB-81' and '01-MAY-81' order by hiredate asc; Exercitiul 8. SELECT ename, deptno FROM emp WHERE deptno in (10,30) ORDER by ename asc; Exercitiul 9. SELECT ename,sal FROM emp WHERE deptno in (10,30) and sal>1500; Exercitiul 10. SELECT ename, hiredate FROM emp Where hiredate between '01-JAN-1982' and '31-DEC-1982'; Exercitiul 11. SELECT ename, job FROM emp WHERE mgn is NULL; Exercitiul 13. SELECT name FROM emp
description
...
Transcript of Laboratorul Nr.2
Exercitiul 1.SELECT empno, ename, job, hiredateFROM emp;
Exercitiul 3.SELECT distinct jobFROM emp;
Exercitiul 5.SELECT ename ||','||' '|| job as "Employee and Title"From emp;
Exercitiul 6.desc emp SELECT empno ||','|| ename ||','|| job ||','|| hiredate ||','|| sal as THE_OUTPUTFROM emp;
Exercitiul 7.7.1 SELECT empno, ename, job, hiredateFROM empWHERE hiredate between '20-FEB-81' and '01-MAY-81';
7.2 SELECT empno, ename, job, hiredateFROM empWHERE hiredate between '20-FEB-81' and '01-MAY-81' order by hiredate asc;
Exercitiul 8.SELECT ename, deptnoFROM empWHERE deptno in (10,30)ORDER by ename asc;
Exercitiul 9.SELECT ename,salFROM empWHERE deptno in (10,30) and sal>1500;
Exercitiul 10.SELECT ename, hiredateFROM empWhere hiredate between '01-JAN-1982' and '31-DEC-1982';
Exercitiul 11.SELECT ename, jobFROM empWHERE mgn is NULL;
Exercitiul 13.SELECT nameFROM emp
WHERE ename LIKE '%L%L%L' and deptno ='30' OR mgr='7782';
Exercitiul 14.SELECT ename, job, salFROM empWHERE job is ("ANALIST')
