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 !

  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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    This insert statement will not work because all of the values that you are inserting need to be wrapped in one set of () or Parentheses. Also you have a date value that is missing the right quote. So the error message told you exactly what the issue is.

    Code:
    INSERT INTO emp VALUES
    (7499),'ALLEN','SALESMAN',7698,'15-AUG-98,1600,NULL,30);
    This is what the inserts should look like.
    Code:
    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);
    this space intentionally left blank

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