Oracle LENGTH()

오라클 LENGTH()

 

LENGTH()

   - 문자열의 길이를 구해주는 함수

 

LENGTH(char)

의 형태

 

The LENGTH functions return the length of char. LENGTH calculates length using caracters as defined by the input character set. LENGTHB uses bytes instead of charactes. LENGTHC uses Unicode complete characters. LENGTH2 uses UCS2 code points. LENGTH4 uses UCS4 code points.

 

char can be any of the data types CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The exceptions are LENGTHC, LENGTH2, and LENGTH4, which do not allow char to be a CLOB or NCLOB. The return value is of data type NUMBER. If char has data type CHAR, then the length includes all trailing blanks. If char is null, then this function returns null.

 

Restriction on LENGTHB 

The LENGTHB function is supported for single-byte LOBs only. It cannot be used with CLOB and NCLOB data in a multibyte character set.

 

SQL> SELECT LENGTH('AAAAAAAAAAA') FROM DUAL;

   --> 11

 

SQL> SELECT LENGTH('A         A') FROM DUAL;

   --> 11

 

SQL> SELECT LENGTH('          A') FROM DUAL;

   --> 11

 

SQL> SELECT LENGTH(TRIM('          A')) FROM DUAL;

   --> 1