DROP TABLE studenti;
CREATE TABLE studenti (
ID NUMBER(38) NOT NULL,
NR_MATRICOL VARCHAR2(6) NOT NULL,
NUME VARCHAR2(15) NOT NULL,
PRENUME VARCHAR2(30) NOT NULL,
AN NUMBER(1),
GRUPA CHAR(2),
BURSA NUMBER(6),
DATA_NASTERE DATE,
EMAIL VARCHAR2(40),
CREATED_AT DATE,
UPDATED_AT DATE
);
INSERT INTO studenti VALUES ('1','224MJ0','Ciobotaru','Vladut','2','A2','3000','27-DEC-74','ciobotaru.vladut@info.ro','28-FEB-18','28-FEB-18');
INSERT INTO studenti VALUES ('2','882QE2','Minuti','Maria','1','A4','3000','16-NOV-74','minuti.maria@info.ro','28-FEB-18','28-FEB-18');
INSERT INTO studenti VALUES ('3','466ZG8','Cojocaru','Aurelian','3','B2','2461','14-SEP-74','cojocaru.aurelian@info.ro','28-FEB-18','28-FEB-18');
INSERT INTO studenti VALUES ('4','570UC0','Carp','Diana Ileana','2','B1','3000','18-MAR-74','carp.diana@gmail.com','28-FEB-18','28-FEB-18');