但是有些地方说他会自动去掉插入值的前后空格,求真相
追答sys@DOO> create table test1(a varchar2(10));
Table created.
sys@DOO> insert into test1 values(' aa ');
1 row created.
sys@DOO> commit;
Commit complete.
sys@DOO> select length(a),a from test1;
LENGTH(A) A
---------- --------------------
4 aa
sys@DOO> insert into test1 values(trim(' bb '));
1 row created.
sys@DOO> commit;
Commit complete.
sys@DOO> select length(a),a from test1;
LENGTH(A) A
---------- --------------------
4 aa
2 bb
sys@DOO> select length(a),'--'||a||'--' from test1;
LENGTH(A) '--'||A||'--'
---------- ----------------------------
4 -- aa --
2 --bb--