oracle函数length

oracle函数length

SQL> select length(123) from dual ;

LENGTH(123)----------- 3

SQL> select length('abc') from dual ;

LENGTH('ABC')------------- 3

SQL> select length(afda123) from dual;select length(afda123) from dual *第 1 行出现错误:ORA-00904: "AFDA123": 标识符无效

SQL> select length('afda123') from dual ;

LENGTH('AFDA123')----------------- 7

SQL> select length('大地') from dual ;

LENGTH('大地')-------------- 2

oracle提示已经很清楚了, 123asd这个是什么标识符? asd 又是? 'asd' 是字符串, 123是数字,

标签：oracle,length,函数