Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-02 |
|
|
View PDF |
The REMBYTES function removes one or more bytes from a text expression and returns the value that remains.
Return Value
TEXT
Syntax
REMBYTES(text-expression start [length])
Arguments
The TEXT
expression from which REMBYTES removes bytes. When the characters to be removed from text-expression contain embedded line breaks, these breaks are also removed. Other line breaks are preserved. Removed line breaks are not counted toward the total number of characters removed.
An INTEGER
that represents the character position at which to begin removing characters. The position of the first character in text-expression is 1
. When the value of start is greater than the length of text-expression, REMBYTES simply returns text-expression.
An INTEGER
that represents the number of characters to be removed. When length is not specified, only the character at start is removed.
Examples