1 Attachment(s)
Error when inserting values to an employee table !
Hi,
Can someone help me out with this ?
The problem is When I want to add :
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
7499 ALLEN SALESMAN 7698 15-AUG-98 1600 30
7521 WARD SALESMAN 7698 26-MAR -96 1550 300 30
7782 CLARK MANAGER 7839 10-APR-97 1250 10
7288 SCOTT ANALYST 7566 14-MAY-99 1300 20
the SQL code for individual insertions are:
INSERT INTO emp VALUES
(7499),'ALLEN','SALESMAN',7698,'15-AUG-98,1600,NULL,30);
INSERT INTO emp VALUES
(7521),'WARD','SALESMAN',7698,'26-MAR-96,1550,300,30);
INSERT INTO emp VALUES
(7782),'CLARK','MANAGER',7839,'10-APR-97,1250,NULL,10);
INSERT INTO emp VALUES
(7288),'SCOTT','ANALYST',7566,'14-MAY-99,1300,NULL,20);
But When I eventually type them out in the console and enter
This error pops up :
ERROR:
0RA-01756: quoted string not properly terminated
Can someone explain to me what this means ?
Thanks,
Kind Regards,
Manager00104,