Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
View PDF |
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.
Return Value
INTEGER
Syntax
MAXBYTES(text-expression)
Arguments
The TEXT
expression whose bytes for each line are to be counted.
Examples
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