Returns the length of its argument.
Argument type | Value returned |
---|---|
string | number of characters |
array | number of elements |
NULL | zero |
LOB | length if known (see below) |
string_session | number of bytes written into the session |
composite | sum of byte lengths of elements consisting the composite |
Integer length of the argument
SQL> select length('abacus'), length (NULL); callret callret INTEGER INTEGER _______________________________________________________________________________ 6 0 1 Rows. -- 11 msec. SQL> select max (length (ProductName)) from Demo.demo.Products; flag INTEGER _______________________________________________________________________________ 32 1 Rows. -- 61 msec.