SUBSTRING and SUBSTR operate on the following types of arguments:
- Character
- Byte
- Numeric
A numeric string_expression argument is implicitly converted to CHARACTER type.