第一次创建Oracle表下面是我遇到的问题,请多多指教。
CREATE TABLE STORAGE_DICT
(
STORAGE_NO VARCHAR (36),
STORAGE_NAME VARCHAR (30),
STORAGE_CLASS_NAME VARCHAR (20),
STORAGE_CLASS_CODE VARCHAR (10),
STORAGE_STATUS_NAME VARCHAR (20),
STORAGE_STATUS_CODE VARCHAR (10),
STORAGE_APP_NAME VARCHAR (20),
STORAGE_APP_CODE VARCHAR (20),
"COMMENT" VARCHAR (500),
CMD_FILE0 VARCHAR (10),
CMD_FILE1 VARCHAR (10),
CMD_FILE2 VARCHAR (10),
CMD_FILE3 VARCHAR (10),
CMD_FILE4 VARCHAR (10),
PRIMARY KEY (STORAGE_NO)
);CREATE TABLE STORAGE_CLASS_DICT
(
STORAGE_CLASS_CODE Varchar (10),
STORAGE_CLASS_NAME Varchar (20),
PRIMARY KEY (STORAGE_CLASS_CODE)
);下面是错误提示
invalid SQL statementCause: The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed.Action: Correct the syntax or install the Procedural Option.
CREATE TABLE STORAGE_DICT
(
STORAGE_NO VARCHAR (36),
STORAGE_NAME VARCHAR (30),
STORAGE_CLASS_NAME VARCHAR (20),
STORAGE_CLASS_CODE VARCHAR (10),
STORAGE_STATUS_NAME VARCHAR (20),
STORAGE_STATUS_CODE VARCHAR (10),
STORAGE_APP_NAME VARCHAR (20),
STORAGE_APP_CODE VARCHAR (20),
"COMMENT" VARCHAR (500),
CMD_FILE0 VARCHAR (10),
CMD_FILE1 VARCHAR (10),
CMD_FILE2 VARCHAR (10),
CMD_FILE3 VARCHAR (10),
CMD_FILE4 VARCHAR (10),
PRIMARY KEY (STORAGE_NO)
);CREATE TABLE STORAGE_CLASS_DICT
(
STORAGE_CLASS_CODE Varchar (10),
STORAGE_CLASS_NAME Varchar (20),
PRIMARY KEY (STORAGE_CLASS_CODE)
);下面是错误提示
invalid SQL statementCause: The statement is not recognized as a valid SQL statement. This error can occur if the Procedural Option is not installed and a SQL statement is issued that requires this option (for example, a CREATE PROCEDURE statement). You can determine if the Procedural Option is installed by starting SQL*Plus. If the PL/SQL banner is not displayed, then the option is not installed.Action: Correct the syntax or install the Procedural Option.
执行时用"Execute as script"就OK了