Answers for "substr from a field value oracle"

SQL
0

oracle right characters

-- For Oracle only

-- syntax 
SUBSTR(<main-string>,-<number-of-characters>)

-- example 
SUBSTR('Useless stuff',-9) -- OUTPUT: ess stuff

-- practical example
SELECT SUBSTR('Useless stuff',-9)
FROM DUAL;
Posted by: Guest on May-12-2020
1

ORACLE SQL SUBSTR

SUBSTR(string, :START_POS, :SUBSTR_LENGTH);

SELECT SUBSTR('ABCDEFG',3,4) FROM DUAL;
--OUTPUT: CDEF
Posted by: Guest on November-27-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language