dump(90101,16) : Dump « Char Functions « Oracle PL / SQL






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

dump(90101,16)

   

SQL>
SQL>
SQL> select 90101, dump(90101,16) from dual
  2  union all
  3  select 90102, dump(90102,16) from dual
  4  union all
  5  select 90103, dump(90103,16) from dual
  6  /

     90101 DUMP(90101,16)
---------- ---------------------
     90101 Typ=2 Len=4: c3,a,2,2
     90102 Typ=2 Len=4: c3,a,2,3
     90103 Typ=2 Len=4: c3,a,2,4








Related examples in the same category

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