START_POSITION specifies which character in the supplied string to start with, and the optional length specifies how many characters to consider. : Dump « Char Functions « Oracle PL / SQL






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

START_POSITION specifies which character in the supplied string to start with, and the optional length specifies how many characters to consider.

  
SQL>
SQL> SELECT
  2     DUMP('ABC',1010,1)  type_info
  3  FROM dual;

TYPE_INFO
------------------------------------------------
Typ=96 Len=3 CharacterSet=WE8MSWIN1252: 65,66,67








Related examples in the same category

1.Syntax: DUMP(expression [,RETURN_FORMAT [START_POSITION] [LENGTH]])
2.dump table column
3.dump( ename, 16 )
4.Union all with dump reverse
5.dump(90101,16)
6.dump(reverse(90101),16)