Union all with dump reverse : Dump « Char Functions « Oracle PL / SQL






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

Union all with dump reverse

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

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

3 rows selected.

SQL>
SQL> --








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.dump(90101,16)
6.dump(reverse(90101),16)