Results 1 to 2 of 2

Thread: SQL query

  1. #1
    Join Date
    Mar 2011
    Posts
    1

    SQL query

    Hi i am using the following code to create a table in TOAD. But i am getting the error

    ORA-00922: missing or invalid option





    CREATE TABLE HSSE_ARTICLES
    (
    NO INT,
    SUBJECT VARCHAR(50),
    EXT VARCHAR(10),
    ADDRESS VARCHAR(100),
    ID_NO INT IDENTITY(1357,2)
    );


    How can i rectify the problem

    Thanks
    Ritwika

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    There is no IDENTITY column in Oracle, it is only in SQL Server. Also VARCHAR is VARCHAR2 in Oracle.

    You have to create Sequence in Oracle to get same things as IDENTITY.

Posting Permissions

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