CODEWITHSUNDEEP
sqloracle-database
Majestic
Majestic

Reputation: 938

ORACLE : Create table - Missing right parenthesis

I do not understand why my function raises this error :

CREATE TABLE "CVAULTIMPORTLOG" (
   "ID"       RAW(16) DEFAULT sys_guid(),
   "DATE"     TIMESTAMP(6),
   "TYPE"     NUMBER,
   "CODE"     NUMBER,
   "MESSAGE"  VARCHAR2(500 BYTE),
   CONSTRAINT "PK_CVAULTIMPORTLOG" PRIMARY KEY ("ID")
);

I use SQL Developer, thanks !

Upvotes: 1

Views: 735

Answers (2)

Majestic
Majestic

Reputation: 938

Ok guys do not blame me... As Alex Poole just said it, I forgot to refresh the explorer view... Too much computer science for today...

Anyways, thank all of you for you help ! Have a nice day !

Upvotes: 0

Lalit Kumar B
Lalit Kumar B

Reputation: 49082

I have no issues creating the table:

SQL> CREATE TABLE "CVAULTIMPORTLOG"
  2    (
  3      "ID" RAW(16) DEFAULT sys_guid(),
  4      "DATE"    TIMESTAMP(6),
  5      "TYPE"    NUMBER,
  6      "CODE"    NUMBER,
  7      "MESSAGE" VARCHAR2(500 BYTE),
  8      CONSTRAINT "PK_CVAULTIMPORTLOG" PRIMARY KEY ("ID")
  9    );

Table created.

SQL>

On a side note, be aware of the double-quotation marks. A quoted identifier begins and ends with double quotation marks ("). If you name a schema object using a quoted identifier, then you must use the double quotation marks whenever you refer to that object.

Upvotes: 0

Related Questions