Error when inserting values to an employee table !
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Error when inserting values to an employee table !

Threaded View

  1. #1
    Join Date
    Jan 2013
    Posts
    1

    Exclamation 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,
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width