Hi fellow humans..
I bet this will be quite a simple problem for most of you, but I've been trying for quite a while and I can't find my mistake.
Here's the table...
CREATE TABLE Joueur(
NoE INTEGER not null,
NoJ INTEGER not null,
NomJ VARCHAR2(80) NOT NULL,
Adresse VARCHAR2(80) NOT NULL,
Tel VARCHAR(20),
COJ VARCHAR(9) NOT NULL
);
I'll spare you the constraints...
The table creationg works well
Now here's the insert..
INSERT INTO JOUEUR VALUES(1,2,'Mirrione, Bastien','851 Rue Laurendeau','514-390-0579','X11944728');
I get the
[Error] Script lines: 1-1 --------------------------
ORA-01722: invalid number
Any ideas?
Much appreciated, thanks!