Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
Functions, 91 of 121
SUBSTR
returns a portion of char, beginning at character m, n characters long.
Floating-point numbers passed as arguments to SUBSTR
are automatically converted to integers.
SELECT SUBSTR('ABCDEFG',3,4) "Substring" FROM DUAL; Substring --------- CDEF
SELECT SUBSTR('ABCDEFG',-5,4) "Substring" FROM DUAL; Substring --------- CDEF
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|