AS FOLLOWS:
CREATE TABLE t1(id NUMBER,name VARCHAR(20),pwd CHAR(20));
INSERT INTO t1 VALUES(1,'name','pwd');
COMMIT;
SELECT NAME,length(NAME),pwd,length(pwd)FROM t1;
NAME LENGTH(NAME) PWD LENGTH(PWD)
-------------------- ----------------------- -------------------- --------------------------------
name 4 pwd 20
注:char类型被填充了,应该是空格。
注:varchar是动态存储,不超过20字符。