Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

Substr retrieves a portion of the string

The general format for this function is: SUBSTR(string, start_at_position, number_of_characters_to_retrieve) SQL> SQL> SELECT SUBSTR('Mississippi', 5, 3) FROM dual; SUB --- iss SQL>