|
Sybernet / Supplied Functions Reference
Release 3.00 Oct 14, 2002 |
|
This function returns the part of the character expression starting the specified number of characters from the right. Return value has the same datatype as the character expression.
FUNCTION RIGHT
(
CHAR_EXP VARCHAR2
, N NUMBER
)
RETURN VARCHAR2;
| Parameter | Description |
|---|---|
char_exp |
The character string to be operated on. |
n |
The number of characters starting from the right to be returned. |
VARCHAR2
The following example illustrates how to call right.
select http.right('HelloWorld',5) from dual
--------------------------------------
World