Oracle SQL
Przy próbie wstawienia danych wyrzuca mi błąd, o co może chodzić?
CREATE TABLE Employee
(id NUMBER GENERATED ALWAYS AS IDENTITY NOT NULL PRIMARY KEY,
FirstName VARCHAR2(128) NOT NULL,
SecondName VARCHAR2(128),
LastName VARCHAR2(128) NOT NULL,
Gender VARCHAR2(1),
BirthDate DATE NOT NULL,
Salary FLOAT(4) NOT NULL,
DepartmnentId NUMBER NOT NULL,
HireDate DATE NOT NULL,
RelieveDate DATE,
Active NUMBER(1));
INSERT INTO Employee(FirstName, SecondName, LastName, Gender, BirthDate, Salary, DepartmnentId, HireDate, RelieveDate, Active)
VALUES ('Mary',NULL,'Smith','W',TO_DATE('18-DEC-1985'),2000.00,1,TO_DATE('06-MAY-2011'),NULL,1);
Error starting at line : 14 in command -
INSERT INTO Employee(FirstName, SecondName, LastName, Gender, BirthDate, Salary, DepartmnentId, HireDate, RelieveDate, Active)
VALUES ('Mary',NULL,'Smith','W',TO_DATE('18-DEC-1985'),'2000.00',1,TO_DATE('06-MAY-2011'),NULL,1)
Error report -
ORA-01858: tam, gdzie spodziewano się cyfry, znaleziono literę
