Question

insert插入数据时 SQL 错误: ORA-01722: 无效数字

CREATE TABLE DTUserType(
UserTypeID varchar2(4) not null /*类型编号*/
check(UserTypeID like 'U'+'T'+'[0-9][0-9]'),
UserType varchar2(10) not null /*用户类型*/
check(UserType in ('管理员','送菜服务员','结账服务员','会员顾客','普通顾客')),
Invalid number(1) default 0 /*是否作废*/
check(Invalid between 0 and 1) not null,
constraint DTUserTypePK primary key(UserTypeID)
);
建表没有错误
为什么插入数据时报错：insert into ODUser values('1234567890','11','会员');
错误报告:
SQL 错误: ORA-01722: 无效数字
01722. 00000 - "invalid number"

Answer 1

你把insert into ODUser values('1234567890','11','会员');的‘11’的引号去掉
这样 insert into ODUser values('1234567890',11,'会员');