Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The MAXBYTES function counts the number of bytes in the longest line of a multiline text expression. The result returned by MAXBYTES has the same dimensions as the specified expression.
INTEGER
MAXBYTES(text-expression)
The TEXT
expression whose bytes for each line are to be counted.
Example 8-22 Finding the Length of the Longest Line Using Bytes
You would like to know the length of the longest line in a text variable called mytext
. The following example shows the value of the variable and the result returned by MAXBYTES.
The statement
SHOW mytext
produces the following output.
This is a multiline text variable. The longest line is this one in the middle. The third line is short.
The statement
SHOW MAXBYTES(mytext)
produces the following output.
43