BILETUL 23

BILETUL 23

bilet23.a - select NUME,ADRESA,TELEFON from PERS where months_between(sysdate,data_ang)<12;
bilet23.b - create table SANCTIUNI as select NUME from PERS where SANCTIONAT='DA' and months_between(sysdate,DATA_SACTIUNII)<6;
bilet23.c - delete from SANCTIUNI where rownum<=5;