CODEWITHSUNDEEP
sqloracle-databaseddl
Matthew Weingarten
Matthew Weingarten

Reputation: 3

Oracle: Invalid Datatype Error on Create Table

I'm trying to simply create an Oracle table and I'm getting an invalid datatype error, but it seems that's there nothing wrong with my create statement (unless I'm completely overlooking something).

    CREATE TABLE SCRIPT_LINE
    (
      ID INTEGER PRIMARY KEY NOT NULL,
      EPISODE_ID INTEGER NOT NULL,
      LINE_NUMBER INTEGER,
      RAW_TEXT VARCHAR(4000),
      TIMESTAMP NUMERIC,
      SPEAKING_LINE BOOLEAN,
      CHARACTER_ID INTEGER NOT NULL,
      LOCATION_ID INTEGER NOT NULL,
      CHARACTER VARCHAR(500),
      LOCATION VARCHAR(500),
      SPOKEN_WORD VARCHAR(4000),
      WORD_COUNT INTEGER
   );

Any idea where the error could be? Thanks in advance.

Upvotes: 0

Views: 929

Answers (2)

Naz
Naz

Reputation: 76

As Oracle does not support Boolean, the best alternative would be char(1) Y/N. alternatively use number (1) 0/1

Upvotes: 0

BobC
BobC

Reputation: 4432

Oracle does not have a BOOLEAN datatype

Upvotes: 3

Related Questions