create table aa (CITEMID VARCHAR2(20) CHECK (LENGTHB(translate(CITEMID,'0123456789'||CITEMID,'0000000000'))=20));INSERT INTO AA VALUES('0123456789012345678A') * ERROR at line 1: ORA-02290: check constraint (ZHU.SYS_C0019589) violated 1* INSERT INTO AA VALUES('01234567890123456789') SQL> /1 row created.SQL> EDIT Wrote file afiedt.buf 1* INSERT INTO AA VALUES('0123456789012345678') SQL> / INSERT INTO AA VALUES('0123456789012345678') * ERROR at line 1: ORA-02290: check constraint (ZHU.SYS_C0019589) violated SQL> EDIT Wrote file afiedt.buf 1* INSERT INTO AA VALUES('012345678901234567890') SQL> / INSERT INTO AA VALUES('012345678901234567890') * ERROR at line 1: ORA-01401: inserted value too large for column
zheyang ?我没试过,你自己测试一下吧
*
ERROR at line 1:
ORA-02290: check constraint (ZHU.SYS_C0019589) violated 1* INSERT INTO AA VALUES('01234567890123456789')
SQL> /1 row created.SQL> EDIT
Wrote file afiedt.buf 1* INSERT INTO AA VALUES('0123456789012345678')
SQL> /
INSERT INTO AA VALUES('0123456789012345678')
*
ERROR at line 1:
ORA-02290: check constraint (ZHU.SYS_C0019589) violated
SQL> EDIT
Wrote file afiedt.buf 1* INSERT INTO AA VALUES('012345678901234567890')
SQL> /
INSERT INTO AA VALUES('012345678901234567890')
*
ERROR at line 1:
ORA-01401: inserted value too large for column