Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The NUMLINES function counts the number of lines in each value of a text expression. The result returned by NUMLINES has the same dimensions as the specified expression.
NUMLINES accepts either a TEXT or NTEXT argument. It does not perform an automatic conversion to either data type.
INTEGER
NUMLINES(text-expression)
The text expression whose lines are to be counted.
OLADM1801Example 8-44 Counting the Number of Lines
In this example, you want to determine the number of lines in the multiline text variable LASTNAMES. The LASTNAMES variable has the following values.
Adamson Jones Smith Taylor
The statement
SHOW NUMLINES(lastnames)
produces the following output.
4