|Oracle® OLAP DML Reference
11g Release 2 (11.2)
|PDF · Mobi · ePub|
EXTLINES(text-expression [start [numlines]])
NTEXT expression from whose values one or more lines are to be extracted.
INTEGER that represents the line number at which to begin extracting. The position of the first line in text-expression is
1. When you omit this argument, EXTLINES begins with line 1.
INTEGER representing the number of lines to be extracted. When you do not specify numlines, or when you specify a number greater than the number of lines from start to the end of text-expression, all the lines from start to the end of text-expression are copied.
This example shows how to extract the second line from a multiline text value in a variable called
mktglist variable has the following values.
Salespeople Products Services
SHOW EXTLINES(mktglist 2 1)
produces the following output.