[Sql] erreur dans un script

**fyren`** · 30/01/2006, 03h48

Bonjour,

Je me tourne vers vous suite à deux problèmes rencontré sur un script de création de table.

Au niveau d'une table se nommant t_clients tout d'abord :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
REM ##########################################
REM ##### Création de la table t_clients #####
REM ##########################################
 
PROMPT ****** Création de la table t_clients...
 
CREATE TABLE t_clients (
		client_id NUMBER(6),
		nom VARCHAR2(25) CONSTRAINT c_nn_t_clients_nom NOT NULL,
		prenom VARCHAR2(25) CONSTRAINT c_nn_t_clients_prenom NOT NULL,
		adresse VARCHAR2(100),
		telephone VARCHAR2(20),
		sexe CHAR(1),
		date_naissance DATE CONSTRAINT c_nn_t_clients_date_naissance NOT NULL,
		abonnement_id NUMBER(6),
		date_abonnement DATE
		);
 
ALTER TABLE t_clients ADD (
		CONSTRAINT pk_t_clients PRIMARY KEY (client_id),
		CONSTRAINT fk_t_abonnements_t_clients FOREIGN KEY (abonnement_id) REFERENCES t_abonnements (abonnement_id)
		);
 
CREATE SEQUENCE seq_t_clients
INCREMENT BY 1
START WITH 1
NOCYCLE
NOCACHE;
 
Prompt ****** Insertion des données dans la table ...
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Eustache','Josias','31 du Chateau Landon - F-75010 Paris','01.31.31.31.31','H',TO_DATE('12/05/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Geneix','Nicolas','32 du Chateau Landon - F-75010 Paris','01.32.32.32.32','H',TO_DATE('01/08/1982','DD/MM/YYYY'),'2','10/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Gheza','Gatien','33 du Chateau Landon - F-75010 Paris','01.33.33.33.33','H',TO_DATE('08/02/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Gilliers','Stephane','34 du Chateau Landon - F-75010 Paris','01.34.34.34.34','H',TO_DATE('03/08/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Girard','Loic','35 du Chateau Landon - F-75010 Paris','01.35.35.35.35','H',TO_DATE('12/02/1983','DD/MM/YYYY'),'1','23/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Godbert','Julien','36 du Chateau Landon - F-75010 Paris','01.36.36.36.36','H',TO_DATE('02/08/1983','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Goloubiatnikov','Mathieu','37 du Chateau Landon - F-75010 Paris','01.37.37.37.37','H',TO_DATE('20/10/1984','DD/MM/YYYY'),'3','14/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Grondin','Fabrice','38 du Chateau Landon - F-75010 Paris','01.38.38.38.38','H',TO_DATE('15/08/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Guy-Faure','Fabien','39 du Chateau Landon - F-75010 Paris','01.39.39.39.39','H',TO_DATE('08/04/1984','DD/MM/YYYY'),'2','11/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Herdhuin','Cyrille','40 du Chateau Landon - F-75010 Paris','01.40.40.40.40','H',TO_DATE('07/06/1982','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Jacquand','Marc','42 du Chateau Landon - F-75010 Paris','01.42.42.42.42','H',TO_DATE('24/06/1981','DD/MM/YYYY'),'3','07/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Jiwa','Rahim','43 du Chateau Landon - F-75010 Paris','01.43.43.43.43','H',TO_DATE('10/08/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Kaidi','Khireddine','44 du Chateau Landon - F-75010 Paris','01.44.44.44.44','H',TO_DATE('22/10/1981','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Krief','Jonathan','45 du Chateau Landon - F-75010 Paris','01.45.45.45.45','H',TO_DATE('14/06/1981','DD/MM/YYYY'),'1','02/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Labe','Hugues','46 du Chateau Landon - F-75010 Paris','01.46.46.46.46','H',TO_DATE('27/05/1982','DD/MM/YYYY'),'3','14/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Lachari','David','47 du Chateau Landon - F-75010 Paris','01.47.47.47.47','H',TO_DATE('23/05/1980','DD/MM/YYYY'),'2','08/08/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Languereau','Guillaume','48 du Chateau Landon - F-75010 Paris','01.48.48.48.48','H',TO_DATE('23/11/1982','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Lanouguere','Baptiste','49 du Chateau Landon - F-75010 Paris','01.49.49.49.49','H',TO_DATE('13/06/1984','DD/MM/YYYY'),'2','15/08/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Laplantif','Florian','50 du Chateau Landon - F-75010 Paris','01.50.50.50.50','H',TO_DATE('01/08/1980','DD/MM/YYYY'),'2','13/07/2004');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Lebosse','Guillaume','51 du Chateau Landon - F-75010 Paris','01.51.51.51.51','H',TO_DATE('23/11/1983','DD/MM/YYYY'),'3','12/08/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Leclere','Julien','52 du Chateau Landon - F-75010 Paris','01.52.52.52.52','H',TO_DATE('06/02/1982','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Lejet','Harold','53 du Chateau Landon - F-75010 Paris','01.53.53.53.53','H',TO_DATE('13/07/1983','DD/MM/YYYY'),'1','04/08/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Loyot','Guillaume','54 du Chateau Landon - F-75010 Paris','01.54.54.54.54','H',TO_DATE('03/10/1984','DD/MM/YYYY'),'3','01/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Luu-Huu','Thierry','55 du Chateau Landon - F-75010 Paris','01.55.55.55.55','H',TO_DATE('13/10/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Martinazzo','Jean-Paul','56 du Chateau Landon - F-75010 Paris','01.56.56.56.56','H',TO_DATE('05/02/1984','DD/MM/YYYY'),'1','15/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Maugard','Gregory','57 du Chateau Landon - F-75010 Paris','01.57.57.57.57','H',TO_DATE('02/02/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Mauron','Yannick','58 du Chateau Landon - F-75010 Paris','01.58.58.58.58','H',TO_DATE('07/05/1982','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Merniche','Amar','59 du Chateau Landon - F-75010 Paris','01.59.59.59.59','H',TO_DATE('13/05/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Meunier','Axel','60 du Chateau Landon - F-75010 Paris','01.60.60.60.60','H',TO_DATE('03/01/1983','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Mitel','Fabrice','61 du Chateau Landon - F-75010 Paris','01.61.61.61.61','H',TO_DATE('14/02/1983','DD/MM/YYYY'),'2','15/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Naulot','Jean','62 du Chateau Landon - F-75010 Paris','01.62.62.62.62','H',TO_DATE('27/10/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Ouahioune','Tarik','63 du Chateau Landon - F-75010 Paris','01.63.63.63.63','H',TO_DATE('25/01/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Panchakaran','Kanthappapillai','64 du Chateau Landon - F-75010 Paris','01.64.64.64.64','H',TO_DATE('04/01/1984','DD/MM/YYYY'),'2','09/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Pires','Michel','65 du Chateau Landon - F-75010 Paris','01.65.65.65.65','H',TO_DATE('10/09/1982','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Poinas','Xavier','66 du Chateau Landon - F-75010 Paris','01.66.66.66.66','H',TO_DATE('21/08/1981','DD/MM/YYYY'),'2','21/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Pradel','Regis','67 du Chateau Landon - F-75010 Paris','01.67.67.67.67','H',TO_DATE('02/05/1981','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Riss','Vincent','68 du Chateau Landon - F-75010 Paris','01.68.68.68.68','H',TO_DATE('27/11/1982','DD/MM/YYYY'),'1','03/08/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Riviere','Ludovic','69 du Chateau Landon - F-75010 Paris','01.69.69.69.69','H',TO_DATE('16/09/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Ropert','Francois','70 du Chateau Landon - F-75010 Paris','01.70.70.70.70','H',TO_DATE('11/06/1983','DD/MM/YYYY'),'3','11/08/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Rossignol','Eleonore','71 du Chateau Landon - F-75010 Paris','01.71.71.71.71','H',TO_DATE('03/06/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Sanou','David','72 du Chateau Landon - F-75010 Paris','01.72.72.72.72','H',TO_DATE('19/09/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Soldati','Dorian','73 du Chateau Landon - F-75010 Paris','01.73.73.73.73','H',TO_DATE('05/04/1984','DD/MM/YYYY'),'2','02/08/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Tall','Abdoulaye','74 du Chateau Landon - F-75010 Paris','01.74.74.74.74','H',TO_DATE('09/08/1983','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Thuillier','Romain','75 du Chateau Landon - F-75010 Paris','01.75.75.75.75','H',TO_DATE('07/10/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Tranchant','Jean-Baptiste','76 du Chateau Landon - F-75010 Paris','01.76.76.76.76','H',TO_DATE('04/10/1982','DD/MM/YYYY'),'1','24/07/2004');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Trang','William','77 du Chateau Landon - F-75010 Paris','01.77.77.77.77','H',TO_DATE('03/04/1983','DD/MM/YYYY'),'3','16/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Turken','Fatih','78 du Chateau Landon - F-75010 Paris','01.78.78.78.78','H',TO_DATE('24/10/1984','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Zachayus','Aurelien','79 du Chateau Landon - F-75010 Paris','01.79.79.79.79','H',TO_DATE('06/01/1980','DD/MM/YYYY'),'NULL','NULL');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Zini','Alexandra','80 du Chateau Landon - F-75010 Paris','01.80.80.80.80','H',TO_DATE('21/10/1982','DD/MM/YYYY'),'1','04/07/2005');
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Zwang','Arnaud','81 du Chateau Landon - F-75010 Paris','01.81.81.81.81','H',TO_DATE('11/06/1984','DD/MM/YYYY'),'NULL','NULL');

Je me retrouve avec l'erreur suivante :

****** Insertion des données dans la table ...
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Eustache','Josias','31 du Chateau Landon - F-75

ERREUR à la ligne 1 :
ORA-01722: invalid number

Ensuite au niveau de trois tables t_billets t_reservations et t_employees.
Je ne vous affiche que la table t_billets

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
REM ##########################################
REM ##### Création de la table t_billets #####
REM ##########################################
 
PROMPT ****** Création de la table t_billets...
 
CREATE TABLE t_billets (
		billet_id NUMBER(6),
		siege NUMBER(3) CONSTRAINT c_nn_t_billets_siege NOT NULL,
		client_id NUMBER(6) CONSTRAINT c_nn_t_billets_client_id NOT NULL,	  
		wag_tr_id NUMBER(6) CONSTRAINT c_nn_t_billets_wag_tr_id NOT NULL,
		reservation_id NUMBER(6) CONSTRAINT c_nn_t_billets_reservation_id NOT NULL,
		type VARCHAR2(10) CONSTRAINT c_nn_t_billets_type NOT NULL
		);
 
ALTER TABLE t_billets ADD (
		CONSTRAINT pk_t_billets PRIMARY KEY (billet_id),
		CONSTRAINT fk_t_clients_t_billets_1 FOREIGN KEY (client_id) REFERENCES t_clients (client_id),
		CONSTRAINT fk_t_reserv_t_billets_2 FOREIGN KEY (reservation_id) REFERENCES t_reservations (reservation_id),
		CONSTRAINT fk_t_wagons_trains_t_billets_3 FOREIGN KEY (wag_tr_id) REFERENCES t_wagons_trains (wag_tr_id)
		);
 
CREATE SEQUENCE seq_t_billets
INCREMENT BY 1
START WITH 1
NOCYCLE
NOCACHE;
 
Prompt ****** Insertion des données dans la table ...
INSERT INTO t_billets VALUES (seq_t_billets.nextval,10,43,122,15,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,16,47,118,15,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,17,47,122,15,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,10,18,24,16,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,3,33,84,17,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,10,33,88,17,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,8,43,115,18,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,13,43,116,18,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,14,53,114,18,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,6,53,116,18,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,14,66,133,19,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,16,59,2,20,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,4,30,22,21,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,6,39,44,22,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,9,46,62,23,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,10,46,63,23,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,17,75,78,23,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,15,53,97,24,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,2,33,98,25,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,3,45,105,26,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,14,52,126,27,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,7,52,127,27,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,13,59,1,28,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,14,59,5,28,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,7,37,94,29,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,7,41,3,30,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,18,41,7,30,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,3,41,53,30,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,10,41,55,30,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,16,50,1,31,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,8,50,8,31,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,8,72,13,31,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,17,72,17,31,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,17,34,37,32,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,14,39,134,33,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,18,69,10,34,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,16,69,16,34,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,16,15,33,35,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,13,27,59,36,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,15,54,8,37,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,19,77,8,38,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,17,49,12,39,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,15,49,17,39,'Retour');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,12,68,127,40,'Aller');
INSERT INTO t_billets VALUES (seq_t_billets.nextval,6,66,130,41,'Aller');

Je me retrouve avec l'erreur suivante :

INSERT INTO t_billets VALUES (seq_t_billets.nextval,6,66,130,41,'Aller')
*
ERREUR à la ligne 1 :
ORA-02291: integrity constraint (PAR_PS1_05.FK_T_RESERV_T_BILLETS_2) violated -
parent key not found

Pour ce qui est de la première erreur, je n'ai pas d'idée.
Pour ce qui est de la seconde, on m'a conseillé de desactiver les contraintes de clés étrangères ce que j'ai fait via le script trouvé ici : http://oracle.developpez.com/sources...active_fk_user

Mais malgès cela, ça ne fonctionne toujours pas.

J'espère que quelqu'un saura m'expliquer d'ou provient le problème et eventuellement comment le resoudre assez rapidement, etant donné que la deadline de rendu de la base approche à très grand pas (mercredi)

Je vous met ici une copie du script entier au cas ou vous auriez besoin d'information complémentaire : http://membres.lycos.fr/forumlv/tables.sql

Merci d'avance pour votre aide.

**plabrevo** · 30/01/2006, 04h22

La premiere erreur (ORA-1722) est due a l'insertion de la chaine 'NULL' dans ABONNEMENT_ID, qui est une colonne de type NUMBER. 'NULL' est une chaine de caractere. Peut-etre faudrait-il remplacer 'NULL' par NULL sans les quotes. La sanction sera similaire pour l'insertion du meme 'NULL' dans l'autre colonne DATE_ABONNEMENT, qui est elle du type DATE.

En passant, pour echapper a l'ORA-1843, non poste mais previsible, il faudra remplacer les dates en dur style '04/07/2005' avec un TO_DATE('04/07/2005','DD/MM/YYYY'), afin de preciser le format de la date a la francaise.

**plabrevo** · 30/01/2006, 04h40

Pour le second probleme, les billets ne peuvent pas etre inseres parce que les billets referencent des reservations qui n'existent pas.
Or ces reservations n'existent pas parce qu'elles n'ont pas pu etre inserees du fait qu'elles referencent des clients qui n'existent pas.
Or ces client n'existent pas parce que blablabla blablabla.

Il serait assez sale de desactiver les FKs juste pour faire passer le script. Il suffira de fixer le probleme d'insertion des clients, puis (eventuellement) celui des reservations, puis (eventuellement) celui des billets.

**fyren`** · 30/01/2006, 13h33

Tout d'abord merci pour tes réponses, j'ai essayer ce que tu as dis c'est à dire remplacer le 'NULL' par NULL, je me retrouve donc avec :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
REM ##########################################
REM ##### Création de la table t_clients #####
REM ##########################################
 
PROMPT ****** Création de la table t_clients...
 
CREATE TABLE t_clients (
		client_id NUMBER(6),
		nom VARCHAR2(25) CONSTRAINT c_nn_t_clients_nom NOT NULL,
		prenom VARCHAR2(25) CONSTRAINT c_nn_t_clients_prenom NOT NULL,
		adresse VARCHAR2(100),
		telephone VARCHAR2(20),
		sexe CHAR(1),
		date_naissance DATE CONSTRAINT c_nn_t_clients_date_naissance NOT NULL,
		abonnement_id NUMBER(6),
		date_abonnement DATE
		);
 
ALTER TABLE t_clients ADD (
		CONSTRAINT pk_t_clients PRIMARY KEY (client_id),
		CONSTRAINT fk_t_abonnements_t_clients FOREIGN KEY (abonnement_id) REFERENCES t_abonnements (abonnement_id)
		);
 
CREATE SEQUENCE seq_t_clients
INCREMENT BY 1
START WITH 1
NOCYCLE
NOCACHE;
 
Prompt ****** Insertion des données dans la table ...
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Aknin','Julien','01 du Chateau Landon - F-75010 Paris','01.01.01.01.01','H',TO_DATE('07/07/1980','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Amiel','Michael','02 du Chateau Landon - F-75010 Paris','01.02.02.02.02','H',TO_DATE('07/01/1984','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Arfaoui','Mejdi','03 du Chateau Landon - F-75010 Paris','01.03.03.03.03','H',TO_DATE('21/02/1980','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Asgaraly','Amine','04 du Chateau Landon - F-75010 Paris','01.04.04.04.04','H',TO_DATE('20/06/1984','DD/MM/YYYY'),1,TO_DATE('09/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Augerd','Maxime','05 du Chateau Landon - F-75010 Paris','01.05.05.05.05','H',TO_DATE('12/03/1983','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Balpe','Devi','06 du Chateau Landon - F-75010 Paris','01.06.06.06.06','H',TO_DATE('16/10/1984','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Bausseron','Julien','07 du Chateau Landon - F-75010 Paris','01.07.07.07.07','H',TO_DATE('18/02/1982','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Benaim','Yoni','08 du Chateau Landon - F-75010 Paris','01.08.08.08.08','H',TO_DATE('05/03/1981','DD/MM/YYYY'),2,TO_DATE('25/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Benzekri','Sebastien','09 du Chateau Landon - F-75010 Paris','01.09.09.09.09','H',TO_DATE('15/10/1984','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Bichet','Sebastien','10 du Chateau Landon - F-75010 Paris','01.10.10.10.10','H',TO_DATE('27/03/1982','DD/MM/YYYY'),3,TO_DATE('17/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Biyong','Arthur','11 du Chateau Landon - F-75010 Paris','01.11.11.11.11','H',TO_DATE('18/03/1983','DD/MM/YYYY'),3,TO_DATE('12/08/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Blanchard','Jerome','12 du Chateau Landon - F-75010 Paris','01.12.12.12.12','H',TO_DATE('15/07/1984','DD/MM/YYYY'),2,TO_DATE('23/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Blondeau','Olivier','13 du Chateau Landon - F-75010 Paris','01.13.13.13.13','H',TO_DATE('05/08/1984','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Bortoli','Jean-Raynald','14 du Chateau Landon - F-75010 Paris','01.14.14.14.14','H',TO_DATE('09/03/1983','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Bouflih','Samir','15 du Chateau Landon - F-75010 Paris','01.15.15.15.15','H',TO_DATE('08/10/1982','DD/MM/YYYY'),1,TO_DATE('23/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Breuille','Julien','16 du Chateau Landon - F-75010 Paris','01.16.16.16.16','H',TO_DATE('02/06/1984','DD/MM/YYYY'),2,TO_DATE('25/08/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Briet','Max','17 du Chateau Landon - F-75010 Paris','01.17.17.17.17','H',TO_DATE('16/11/1981','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Buot','Nicolas','18 du Chateau Landon - F-75010 Paris','01.18.18.18.18','H',TO_DATE('05/07/1983','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Carzunel','Xavier','19 du Chateau Landon - F-75010 Paris','01.19.19.19.19','H',TO_DATE('21/02/1980','DD/MM/YYYY'),2,TO_DATE('02/08/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Chemla','Jonathan','20 du Chateau Landon - F-75010 Paris','01.20.20.20.20','H',TO_DATE('11/03/1980','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Colas','Vivien','21 du Chateau Landon - F-75010 Paris','01.21.21.21.21','H',TO_DATE('26/09/1981','DD/MM/YYYY'),2,TO_DATE('18/08/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Contet','Yannick','22 du Chateau Landon - F-75010 Paris','01.22.22.22.22','H',TO_DATE('10/07/1981','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Cordin','Pierre-Olivier','23 du Chateau Landon - F-75010 Paris','01.23.23.23.23','H',TO_DATE('26/10/1984','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Couderette','Thomas','24 du Chateau Landon - F-75010 Paris','01.24.24.24.24','H',TO_DATE('03/01/1980','DD/MM/YYYY'),3,TO_DATE('21/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Derlot','Yoann','25 du Chateau Landon - F-75010 Paris','01.25.25.25.25','H',TO_DATE('03/06/1982','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Desse','Christophe','26 du Chateau Landon - F-75010 Paris','01.26.26.26.26','H',TO_DATE('23/08/1980','DD/MM/YYYY'),3,TO_DATE('02/08/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Drame','Adja','27 du Chateau Landon - F-75010 Paris','01.27.27.27.27','H',TO_DATE('21/03/1980','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Druault','Alexandre','28 du Chateau Landon - F-75010 Paris','01.28.28.28.28','H',TO_DATE('17/06/1982','DD/MM/YYYY'),2,TO_DATE('04/05/2004','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Duhamel','Yvan','29 du Chateau Landon - F-75010 Paris','01.29.29.29.29','H',TO_DATE('26/05/1984','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Elkoufa','Zakia','30 du Chateau Landon - F-75010 Paris','01.30.30.30.30','H',TO_DATE('14/08/1981','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Eustache','Josias','31 du Chateau Landon - F-75010 Paris','01.31.31.31.31','H',TO_DATE('12/05/1980','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Geneix','Nicolas','32 du Chateau Landon - F-75010 Paris','01.32.32.32.32','H',TO_DATE('01/08/1982','DD/MM/YYYY'),2,TO_DATE('10/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Gheza','Gatien','33 du Chateau Landon - F-75010 Paris','01.33.33.33.33','H',TO_DATE('08/02/1984','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Gilliers','Stephane','34 du Chateau Landon - F-75010 Paris','01.34.34.34.34','H',TO_DATE('03/08/1980','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Girard','Loic','35 du Chateau Landon - F-75010 Paris','01.35.35.35.35','H',TO_DATE('12/02/1983','DD/MM/YYYY'),1,TO_DATE('23/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Godbert','Julien','36 du Chateau Landon - F-75010 Paris','01.36.36.36.36','H',TO_DATE('02/08/1983','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Goloubiatnikov','Mathieu','37 du Chateau Landon - F-75010 Paris','01.37.37.37.37','H',TO_DATE('20/10/1984','DD/MM/YYYY'),3,TO_DATE('14/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Grondin','Fabrice','38 du Chateau Landon - F-75010 Paris','01.38.38.38.38','H',TO_DATE('15/08/1984','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Guy-Faure','Fabien','39 du Chateau Landon - F-75010 Paris','01.39.39.39.39','H',TO_DATE('08/04/1984','DD/MM/YYYY'),2,TO_DATE('11/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Herdhuin','Cyrille','40 du Chateau Landon - F-75010 Paris','01.40.40.40.40','H',TO_DATE('07/06/1982','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Jacquand','Marc','42 du Chateau Landon - F-75010 Paris','01.42.42.42.42','H',TO_DATE('24/06/1981','DD/MM/YYYY'),3,TO_DATE('07/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Jiwa','Rahim','43 du Chateau Landon - F-75010 Paris','01.43.43.43.43','H',TO_DATE('10/08/1980','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Kaidi','Khireddine','44 du Chateau Landon - F-75010 Paris','01.44.44.44.44','H',TO_DATE('22/10/1981','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Krief','Jonathan','45 du Chateau Landon - F-75010 Paris','01.45.45.45.45','H',TO_DATE('14/06/1981','DD/MM/YYYY'),1,TO_DATE('02/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Labe','Hugues','46 du Chateau Landon - F-75010 Paris','01.46.46.46.46','H',TO_DATE('27/05/1982','DD/MM/YYYY'),3,TO_DATE('14/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Lachari','David','47 du Chateau Landon - F-75010 Paris','01.47.47.47.47','H',TO_DATE('23/05/1980','DD/MM/YYYY'),2,TO_DATE('08/08/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Languereau','Guillaume','48 du Chateau Landon - F-75010 Paris','01.48.48.48.48','H',TO_DATE('23/11/1982','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Lanouguere','Baptiste','49 du Chateau Landon - F-75010 Paris','01.49.49.49.49','H',TO_DATE('13/06/1984','DD/MM/YYYY'),2,TO_DATE('15/08/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Laplantif','Florian','50 du Chateau Landon - F-75010 Paris','01.50.50.50.50','H',TO_DATE('01/08/1980','DD/MM/YYYY'),2,TO_DATE('13/07/2004','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Lebosse','Guillaume','51 du Chateau Landon - F-75010 Paris','01.51.51.51.51','H',TO_DATE('23/11/1983','DD/MM/YYYY'),3,TO_DATE('12/08/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Leclere','Julien','52 du Chateau Landon - F-75010 Paris','01.52.52.52.52','H',TO_DATE('06/02/1982','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Lejet','Harold','53 du Chateau Landon - F-75010 Paris','01.53.53.53.53','H',TO_DATE('13/07/1983','DD/MM/YYYY'),1,TO_DATE('04/08/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Loyot','Guillaume','54 du Chateau Landon - F-75010 Paris','01.54.54.54.54','H',TO_DATE('03/10/1984','DD/MM/YYYY'),3,TO_DATE('01/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Luu-Huu','Thierry','55 du Chateau Landon - F-75010 Paris','01.55.55.55.55','H',TO_DATE('13/10/1980','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Martinazzo','Jean-Paul','56 du Chateau Landon - F-75010 Paris','01.56.56.56.56','H',TO_DATE('05/02/1984','DD/MM/YYYY'),1,TO_DATE('15/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Maugard','Gregory','57 du Chateau Landon - F-75010 Paris','01.57.57.57.57','H',TO_DATE('02/02/1984','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Mauron','Yannick','58 du Chateau Landon - F-75010 Paris','01.58.58.58.58','H',TO_DATE('07/05/1982','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Merniche','Amar','59 du Chateau Landon - F-75010 Paris','01.59.59.59.59','H',TO_DATE('13/05/1984','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Meunier','Axel','60 du Chateau Landon - F-75010 Paris','01.60.60.60.60','H',TO_DATE('03/01/1983','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Mitel','Fabrice','61 du Chateau Landon - F-75010 Paris','01.61.61.61.61','H',TO_DATE('14/02/1983','DD/MM/YYYY'),2,TO_DATE('15/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Naulot','Jean','62 du Chateau Landon - F-75010 Paris','01.62.62.62.62','H',TO_DATE('27/10/1980','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Ouahioune','Tarik','63 du Chateau Landon - F-75010 Paris','01.63.63.63.63','H',TO_DATE('25/01/1980','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Panchakaran','Kanthappapillai','64 du Chateau Landon - F-75010 Paris','01.64.64.64.64','H',TO_DATE('04/01/1984','DD/MM/YYYY'),2,TO_DATE('09/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Pires','Michel','65 du Chateau Landon - F-75010 Paris','01.65.65.65.65','H',TO_DATE('10/09/1982','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Poinas','Xavier','66 du Chateau Landon - F-75010 Paris','01.66.66.66.66','H',TO_DATE('21/08/1981','DD/MM/YYYY'),2,TO_DATE('21/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Pradel','Regis','67 du Chateau Landon - F-75010 Paris','01.67.67.67.67','H',TO_DATE('02/05/1981','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Riss','Vincent','68 du Chateau Landon - F-75010 Paris','01.68.68.68.68','H',TO_DATE('27/11/1982','DD/MM/YYYY'),1,TO_DATE('03/08/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Riviere','Ludovic','69 du Chateau Landon - F-75010 Paris','01.69.69.69.69','H',TO_DATE('16/09/1984','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Ropert','Francois','70 du Chateau Landon - F-75010 Paris','01.70.70.70.70','H',TO_DATE('11/06/1983','DD/MM/YYYY'),3,TO_DATE('11/08/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Rossignol','Eleonore','71 du Chateau Landon - F-75010 Paris','01.71.71.71.71','H',TO_DATE('03/06/1984','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Sanou','David','72 du Chateau Landon - F-75010 Paris','01.72.72.72.72','H',TO_DATE('19/09/1980','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Soldati','Dorian','73 du Chateau Landon - F-75010 Paris','01.73.73.73.73','H',TO_DATE('05/04/1984','DD/MM/YYYY'),2,TO_DATE('02/08/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Tall','Abdoulaye','74 du Chateau Landon - F-75010 Paris','01.74.74.74.74','H',TO_DATE('09/08/1983','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Thuillier','Romain','75 du Chateau Landon - F-75010 Paris','01.75.75.75.75','H',TO_DATE('07/10/1984','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Tranchant','Jean-Baptiste','76 du Chateau Landon - F-75010 Paris','01.76.76.76.76','H',TO_DATE('04/10/1982','DD/MM/YYYY'),1,TO_DATE('24/07/2004','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Trang','William','77 du Chateau Landon - F-75010 Paris','01.77.77.77.77','H',TO_DATE('03/04/1983','DD/MM/YYYY'),3,TO_DATE('16/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Turken','Fatih','78 du Chateau Landon - F-75010 Paris','01.78.78.78.78','H',TO_DATE('24/10/1984','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Zachayus','Aurelien','79 du Chateau Landon - F-75010 Paris','01.79.79.79.79','H',TO_DATE('06/01/1980','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Zini','Alexandra','80 du Chateau Landon - F-75010 Paris','01.80.80.80.80','H',TO_DATE('21/10/1982','DD/MM/YYYY'),1,TO_DATE('04/07/2005','DD/MM/YYYY'));
INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Zwang','Arnaud','81 du Chateau Landon - F-75010 Paris','01.81.81.81.81','H',TO_DATE('11/06/1984','DD/MM/YYYY'),NULL,TO_DATE('NULL','DD/MM/YYYY'));

Et la en faites ben j'ai encore une erreur :

INSERT INTO t_clients VALUES (seq_t_clients.nextval,'Arfaoui','Mejdi','03 du Chateau Landon - F-7501

ERREUR à la ligne 1 :
ORA-01858: a non-numeric character was found where a numeric was expected

Partant sur ta base j'ai essayer egalement un NVL pour remplacer NULL par 0, mais ça marche pas, egalement un TO_NUMBER qui n'a pas fonctionner, et divers conneries pas très utiles.

Donc une fois de plus je bloque :/

**yvesguep** · 30/01/2006, 16h31

Remplace

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
 
TO_DATE('NULL','DD/MM/YYYY')

Par NULL

pour voir

**plabrevo** · 30/01/2006, 19h23

TO_DATE(NULL,<>) est une operation valide. Le remplacement de toutes les occurences de 'NULL' par NULL devrait te permettre d'avancer.

J'espere que l'erreur de syntaxe a ete bien comprise.

**fyren`** · 02/02/2006, 18h19

J'ai fait comme vous me l'aviez dit.

Le soucis est que je dois utiliser des formules d'insertions excel.
Par conséquent si je fais un TO_DATE(NULL,DD/MM/YYYY), je l'apllique aussi sur les lignes qui ont une valeur TO_DATE(01/01/2001,DD/MM/YYYY) et la forcément ça ne marche plus :/

Bref je sais pas quoi faire :/

**plaineR** · 02/02/2006, 18h25

Envoyé par plabrevo

TO_DATE(NULL,<>) est une operation valide.

Je suppose que tu voulais dire TO_DATE('NULL',<>), car il est bien évidemment possible de faire un TO_DATE(NULL,<>)

**plaineR** · 02/02/2006, 18h28

Envoyé par fyren`

J'ai fait comme vous me l'aviez dit.

Le soucis est que je dois utiliser des formules d'insertions excel.
Par conséquent si je fais un TO_DATE(NULL,DD/MM/YYYY), je l'apllique aussi sur les lignes qui ont une valeur TO_DATE(01/01/2001,DD/MM/YYYY) et la forcément ça ne marche plus :/

Bref je sais pas quoi faire :/

Même si ce n'est pas très conseillé, tu peux peut-être faire to_date ('', 'DD/MM/YYYY') au lieu de faire to_date (null, 'DD/MM/RRRR'), puisque pour Oracle la chaine vide ou null c'est pareil (du moins pour l'instant).