Oracle PL/SQL: String Functions: SUBSTR - The substr functions allows you to extract a substring from a string.<br />

Quick Search:

Oracle PL/SQL: String Functions: SUBSTR

Jump to:

Category: >> Oracle PL/SQL >> String Functions: SUBSTR

<< last

next >>

Snippet Name: String Functions: SUBSTR

Description: The substr functions allows you to extract a substring from a string.

Comment: If start_position is 0, then substr treats start_position as 1 (ie: the first position in the string).

If start_position is a positive number, then substr starts from the beginning of the string.

If start_position is a negative number, then substr starts from the end of the string and counts backwards.

If length is a negative number, then substr will return a NULL value.

Language:
Highlight Mode: PLSQL
Last Modified: March 03rd, 2009

SELECT SUBSTR('This is great', 6, 2) FROM dual; 
returns 'is' 
 
 
SUBSTR('This is great', 6) FROM dual;
returns 'is great'