Substr: retrieve a portion of the string : SUBSTR « Char Functions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Char Functions
  3. SUBSTR

Substr: retrieve a portion of the string

 

SQL> -- Substr: retrieve a portion of the string.
SQL>
SQL> -- SUBSTR(string, start_at_position, number_of_characters_to_retrieve)
SQL>
SQL> SELECT SUBSTR('Mississippi', 5, 3) FROM dual;

SUB
---
iss








Related examples in the same category

1.SUBSTR() returns a portion of string, beginning at numeric_position up to a specified substring_length characters long.
2.SUBSTR: get the sub-string
3.Simple demo for SUBSTR function
4.SUBSTR: from the right-hand side of original string
5.SUBSTR and INSTR are used together
6.select substr( '1234567890', 5 )
7.Use SUBSTR to decode a column
8.use substr in IF statement
9.substr(date value,8)+16