1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| CREATE TABLE demandes
(
id_demande NUMBER(10),
logincre CHAR(8) NOT NULL,
loginclo CHAR(8),
dateclo DATE,
loginrej CHAR(8),
daterej DATE,
motifrej CLOB,
loginsup CHAR(8),
datesup DATE,
id_etat NUMBER(10) NOT NULL,
CONSTRAINT PK_demandes PRIMARY KEY (id_demande),
CONSTRAINT FK_demandes FOREIGN KEY (id_etat)
REFERENCES etats(id_etat),
);
UPDATE demandes SET
loginrej ='dcollart',
daterej = SYSDATE,
motifrej = 'aaaaaaa.... plus de 2000 caractères .....aaaaaaaaa',
id_etat = 5
WHERE id_demande = 28; |
Partager