|Oracle® OLAP DML Reference
11g Release 1 (11.1)
|PDF · Mobi · ePub|
REMBYTES(text-expression start [length])
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.
Tip:When you must use this function on NTEXT values, use the CONVERT or TO_CHAR function to convert the NTEXT value to TEXT.
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.
INTEGER that represents the number of characters to be removed. When length is not specified, only the character at start is removed.