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.