Oracle Substring & Instring Functions Substr Instr

Oracle Substring & Instring Functions Substr Instr


Substring Beginning Of String
SELECT SUBSTR(, 1, )
FROM dual;

SELECT SUBSTR('Take the first four characters', 1, 4) FIRST_FOUR
FROM dual;

Substring Middle Of String
SELECT SUBSTR(, , )
FROM dual.

SELECT SUBSTR('Take the first four characters', 16, 4) MIDDLE_FOUR
FROM dual;

Substring End of String
SELECT SUBSTR(, )
FROM dual.
SELECT SUBSTR('Take the first four characters', 16, 15) SIXTEEN_TO_END
FROM dual;