7/25/2019 Bd Seminar 3(Update)

1/3

CREATE TABLE RAND_COMENZI

(NR_COMANDA NUMBER(12),

ID_PRODUS number(6),

PRET NUMBER(8,2),

CANTITATE NUMBER(6),

CONSTRAINT !_nr_"#m$n%$ &OREI'N E(NR_COMANDA) RE&ERENCES

COMENZI(NR_COMANDA),

CONSTRAINT !_*%_+r#%u &OREI'N E(ID_PRODUS) RE&ERENCES

PRODUSE(ID_PRODUS),

CONSTRAINT +!_r$n%_"#men-* PRIMAR E(NR_COMANDA, ID_PRODUS),

CONSTRAINT "!_+re. C/EC(PRET IS NOT NULL),

CONSTRAINT "!_"$n.*.$.e C/EC(CANTITATE BET0EEN 1 AND 1)

)

CREATE TABLE RAND_COMENZI

(NR_COMANDA NUMBER(12),

ID_PRODUS number(6),

PRET NUMBER(8,2),

CANTITATE NUMBER(6),

CONSTRAINT !_nr_"#m$n%$ &OREI'N E(NR_COMANDA) RE&ERENCES

COMENZI(NR_COMANDA),

CONSTRAINT !_*%_+r#%u &OREI'N E(ID_PRODUS) RE&ERENCES

PRODUSE(ID_PRODUS),

CONSTRAINT +!_r$n%_"#men-* PRIMAR E(NR_COMANDA, ID_PRODUS),

CONSTRAINT "!_+re. C/EC(PRET IS NOT NULL),

CONSTRAINT "!_"$n.*.$.e C/EC(CANTITATE BET0EEN 1 AND 1)

)

ALTER TABLE PRODUSE

7/25/2019 Bd Seminar 3(Update)

2/3

ADD STOC NUMBER()3

ALTER TABLE PRODUSE

MODI& STOC NUMBER(1)3

ALTER TABLE PRODUSE

ADD CONSTRAINT "!_.#" C/EC(STOC IS NOT NULL)3

ALTER TABLE PRODUSE

DISABLE CONSTRAINT "!_.#"3

ALTER TABLE PRODUSE

RENAME COLUMN STOC TO STOC_DISPONIBIL3

ALTER TABLE PRODUSE

RENAME TO BUNURI3

ALTER TABLE BUNURI

DROP COLUMN STOC_DISPONIBIL3

DROP TABLE RAND_COMENZI3

DROP TABLE COMENZI3

DROP TABLE CLIENTI3

DROP TABLE BUNURI3

7/25/2019 Bd Seminar 3(Update)

3/3

INSERT INTO +r#%ue

4ALUES(1,5C#"$C#7$5,5u"5,NULL,NULL,92)3

INSERT INTO +r#%ue (*%_+r#%u,%enum*re_+r#%u,%e"r*ere,+re._m*n)

4ALUES (2,5C#"$C#7$5,5u"5,:92)3

COMMIT3

S$ e m$re$"$ "u 1; $7$r*u7 $n