使用length验证char有空格.txt

orale培训教材包括了所有的sql说明和实例

drop table SM_NAME;
CREATE TABLE  SM_NAME(name varchar2(10),
telno char(10));

insert into sm_name values('a','a');

insert into sm_name values('我','我');
insert into sm_name values('我们','我们');


select length(name),name ,length(telno),telno
from sm_name;