Home » SQL & PL/SQL » SQL & PL/SQL » help with syntax error kind help (oracle 12c)
help with syntax error kind help [message #646168] Mon, 21 December 2015 01:03 Go to next message
vs140580
Messages: 70
Registered: December 2015
Member
CREATE TABLE "SYSTEM"."GRAPH" 
   (	"E1" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"E2" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"E3" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"E4" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"E5" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"E6" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"E7" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"E8" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"E9" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"E10" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"E11" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"E12" VARCHAR2(20 BYTE) NOT NULL ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "SYSTEM" 
  PARALLEL 12 ;


Some more code here

ORA-00936: missing expression
00936. 00000 - "missing expression"
*Cause:
*Action:
Error at Line: 4 Column: 1


[EDITED by LF: applied [spoiler] tags]

[Updated on: Mon, 21 December 2015 05:38] by Moderator

Report message to a moderator

Re: help with syntax error kind help [message #646172 is a reply to message #646168] Mon, 21 December 2015 01:38 Go to previous message
vs140580
Messages: 70
Registered: December 2015
Member
I found the error and is in the first statement if can suggest to improve code i am from math background making it shorter there some = in the middle.
Previous Topic: help to correct syntax error
Next Topic: how to checkout tablespace
Goto Forum:
  


Current Time: Tue Apr 23 04:39:59 CDT 2024