SUBSTR « Char Functions « Oracle PL / SQL

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

10.substr(date value,8)+16