Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2010
    Posts
    1

    Unanswered: ORA-00907: missing right parenthesis

    when im trying to create table im getting the following error message
    SQL> CREATE TABLE orders
    2 (id INT IDENTITY(1,1) PRIMARY KEY,
    3 customer VARCHAR(50),
    4 day_of_order DATETIME,
    5 product VARCHAR(50),
    6 quantity INT);
    (id INT IDENTITY(1,1) PRIMARY KEY,
    *
    ERROR at line 2:
    ORA-00907: missing right parenthesis

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    "INT IDENTITY" is not an Oracle structure (MS SQL Server, perhaps?). This is Oracle 10g's CREATE TABLE documentation; study it.

Posting Permissions

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