2 Replies Latest reply on Jan 24, 2013 10:53 AM by Paul Horth

    Help With Error ORA-00906

    986806
      Hey guys,

      I'm really just learning SQL, and when entering this into my command line, I get the error: ORA_00906: Missing Left Parenthesis when I run this script:

      /* =====Create table LOCATION ===== */

      Create table LOCATION
      (Locid NUMBER(5) CONSTRAINT PK_LOCATION PRIMARY KEY,
      Bldg_Code VARCHAR2(10) NOT NULL,
      Room VARCHAR2(6) NOT NULL,
      Capacity NUMBER(5));

      /* =====Insert Data into LOCATION table===== */

      INSERT INTO LOCATION
      VALUES (53, 'BUS', 424, 45);
      INSERT INTO LOCATION
      VALUES (54, 'BUS', 402, 35);
      INSERT INTO LOCATION
      VALUES (55, 'BUS', 433, 100);

      SELECT * FROM TABLE LOCATION;

      Since I am just learning this, I didn't know what I was missing. Any help is appreciated!