ORA-00906:左括号缺失 [英] ORA-00906: missing left parenthesis

问题描述

create table widep(
 cac NUMBER,
 ddate DATE,
 dtime TIMESTAMP,
 type VARCHAR2,
 amount NUMBER(10,2),
 constraint qwe foreign key(cac) references cust(cac)
)

推荐答案

完成错误消息指出Error at Command Line:5 Column:15 是此位置:

The complete error message states Error at CommandLine:5 Column:15 which is this location:

type VARCHAR2,
            ^^^

VARCHAR2 需要一个size参数来定义最大值字符数.使用类似的东西

VARCHAR2 requires a size parameter to define the maximum number of characters. Use something like

create table widep(
 cac NUMBER,
 ddate DATE,
 dtime TIMESTAMP,
 type VARCHAR2(100),
 amount NUMBER(10,2),
 constraint qwe foreign key(cac) references cust(cac)
);

这篇关于ORA-00906:左括号缺失的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！