oracle
DESCRIPTION
BileteTRANSCRIPT
ORACLE
Bilet 1
SELECT last_name, salary+salary*0.08 + 1.75
FROM f_staffs;
Bilet 2
SELECT '***' || first_name|| '***' || last_name||'***' AS"Angajatii lunii"
FROM f_staffs;
Bilet 3.
SELECT 'Atestat' || ' ' || 'profesional' AS "EXAMEN"
FROM DUAL;
Bilet nr 4
SELECT INSTR(' Competene Digitale ', 'D')AS "Pozitie"
FROM DUAL;
Bilet nr 5
SELECT RPAD('Oracle',8,'#')||RPAD('Internet',10,'#')||'Academy' AS "OIA"
FROM DUAL;
Bilet nr 6
SELECT last_name,salary,round(salary/2.15,3)
FROM employees
WHERE employee_id BETWEEN 105 AND 204;
Bilet nr 7
SELECT last_name,salary,trunc(salary+salary*1.03,2)
FROM employees
WHERE employee_id=102;
Bilet nr. 8 (error la describe)
SELECT last_name,salary
FROM employees
WHERE mod(salary,6)=0;
DESCRIBE employees;
Bilet nr 9.
SELECT LAST_DAY(SYSDATE)AS "Deadline "
FROM DUAL;
Bilet nr. 10.
SELECT first_name, TO_CHAR(birthdate, 'Month fmDD, YYYY')AS "Birthday"
FROM f_staffs;
Bilet nr.11
SELECT FIRST_NAME,SALARY,TO_CHAR(SALARY+1275,'$999,999.00')AS "New salary"
FROM EMPLOYEES
WHERE LAST_NAME='Abel'AND FIRST_NAME='Ellen';
Bilet nr 12.
SELECT MIN(salary) AS "Minumum Salary"
FROM f_staffs
WHERE manager_id = 19;
Bilet. Nr 13
SELECT department_id, last_name, salary AS "New Salary",CASE department_id WHEN 80 THEN salary*1.65
WHEN 90 THEN salary*1.75
WHEN 110 THEN salary*1.85
ELSE salary END As "New Salary"
FROM employees;
Bilet nr 14.
SELECT AVG(salary) AS "Average Salary"
FROM f_staffs
WHERE manager_id = 19;
Bilet nr 15.
SELECT last_name, department_id, salary
FROM employees
WHERE salary = ANY (SELECT MAX(salary)
FROM employees
GROUP BY department_id);
Bilet nr 16.
SELECT last_name, department_id, salary
FROM employees
WHERE salary = ANY (SELECT MIN(salary)
FROM employees
GROUP BY department_id);
Bilet nr.17
SELECT first_name, department_id, commission_pct
FROM employees
WHERE commission_pct