| Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
View PDF |
| Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
View PDF |
The UNIQUELINES function removes duplicate lines in a multiline text value and sorts the lines in ascending order. The function returns a multiline text value composed of the resulting lines.
Return Value
TEXT or NTEXT
Syntax
UNIQUELINES(text-expression)
Arguments
A multiline text expression from which UNIQUELINES removes duplicate lines and in which it sorts the remaining lines. UNIQUELINES is case-sensitive when it checks for duplicates, and it compares all characters, including spaces.
When you specify a TEXT expression, the return value is TEXT. When you specify an NTEXT expression, the return value is NTEXT.
Examples
Example 8-156 Removing Duplicate Text Lines
In the following example, one line is removed from the value of officelist, and the lines are sorted.
The statement
SHOW officelist
produces the following output.
MIAMI Providence Miami Baltimore Saratoga Baltimore
The statement
show uniquelines(officelist)
produces the following output.
Baltimore Miami MIAMI Providence Saratoga
