SHARE
TWEET

Untitled

a guest Feb 27th, 2020 86 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. INSERT INTO angajati(id_angajat, nume, prenume, functie, id_sef, id_departament, data_angajarii)
  2. VALUES(4003, 'Pop', 'Alina', 'Analist', 1001, 20, '21-NOV-1995');
  3.  
  4. INSERT INTO angajati(id_angajat, nume, prenume, functie, id_sef, id_departament, data_angajarii)
  5. VALUES(4004, 'Pop', 'Calin', 'Tester', 1001, 20, '01-JAN-1980');
  6.  
  7. INSERT INTO angajati(id_angajat, nume, prenume, functie, id_sef, id_departament, data_angajarii)
  8. VALUES(4005, 'Pop', 'Andrei', 'Manager', 1001, 20, '14-FEB-1995');
  9.  
  10. SELECT nume, prenume, data_angajarii,comision
  11. FROM angajati;
  12.  
  13. DELETE FROM angajati
  14. WHERE nume = 'Pop' AND prenume='Alina';
  15.  
  16. SELECT nume, prenume, data_angajarii, comision
  17. FROM angajati;
  18.  
  19. DELETE FROM angajati
  20. WHERE data_angajarii < '01-JAN-1985';
  21.  
  22. SELECT nume, prenume, data_angajarii, comision
  23. FROM angajati;
  24.  
  25. DELETE FROM angajati
  26. WHERE comision IS NULL;
  27.  
  28. SELECT nume, prenume, data_angajarii, comision
  29. FROM angajati;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top