Syntax: DUMP(expression [,RETURN_FORMAT [START_POSITION] [LENGTH]]) : Dump « Char Functions « Oracle PL / SQL






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

Syntax: DUMP(expression [,RETURN_FORMAT [START_POSITION] [LENGTH]])

  

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

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








Related examples in the same category

1.START_POSITION specifies which character in the supplied string to start with, and the optional length specifies how many characters to consider.
2.dump table column
3.dump( ename, 16 )
4.Union all with dump reverse
5.dump(90101,16)
6.dump(reverse(90101),16)