Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    35

    Unanswered: Create table error

    I want to create a table in 9i and I am getting a ORA-00906 error. I am using this statement.

    create table DATA.Region (
    RegionCode VARCHAR2 CONSTRAINT pk_RegionCode PRIMARY KEY,
    RegionName VARCHAR2 CONSTRAINT nn_RegionName NOT NULL CONSTRAINT upper_RegionName)

    Can anybody tell me what's wrong here..

    Thanks

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    You must supply a length in varchar2 declarations.

    e.g.RegionCode VARCHAR2(30)

Posting Permissions

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