Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    1

    Unanswered: creating tables missing left paranthesis error

    Hi,

    I'm pretty noob at oracle and with this one table no matter what I try I keep getting a missing left paranthesis. Can anyone tell me where the error comes about?


    CREATE TABLE test
    (test_date DATE,
    test_time DATE,
    test_result CHAR (4)
    CONSTRAINT ck_test_result CHECK,
    Reason_failed VARCHAR2 (19)
    CONSTRAINT ck_reason_failed CHECK,
    CONSTRAINT test_pk
    PRIMARY KEY (test_date, test_time));

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Your check constraint definitions are incomplete
    If you reformat your statement you can easily see it:
    Code:
    CREATE TABLE test
    (
      test_date DATE,
      test_time DATE,
      test_result CHAR (4) CONSTRAINT ck_test_result CHECK ???,
      Reason_failed VARCHAR2 (19) CONSTRAINT ck_reason_failed CHECK ???,
      CONSTRAINT test_pk PRIMARY KEY (test_date, test_time)
    );
    Instead of the ??? you need some kind of expression that defines the check constraint.

Posting Permissions

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