Use Oracle utl_raw as the dump Inverse Function

Generally, dump content cannot intuitively understand the desired information. You can use utl_raw.

1. convert numbers

An integer of 1.1

SQL> select dump (175185, 16) from dual;

Dump (175185, 16)

------------------------

Typ = 2 Len = 4: C3, 12, 34, 56

SQL> select utl_raw.cast_to_number ('c3123456') value from dual;

Value

----------

175185

It is more convenient to add a replace function.

SQL> select utl_raw.cast_to_number (replace ('c3, 12,34, 56', ',') value from dual;

Value

----------

175185

1.2 decimal places

SQL> select dump (1751.85, 16) from dual;

Dump (1751.85, 16)

------------------------

Typ = 2 Len = 4: C2, 12, 34, 56

SQL> select utl_raw.cast_to_number (replace ('c2, 12,34, 56', ',') value from dual;

Value

----------

1751.85

2 conversion string

SQL> select dump ('oracle Tom ', 16) A from dual;

A

--------------------------------------------

Typ = 96 Len = 10: 6f, 63, 6C, 74, 6f, 6d

SQL> select utl_raw.cast_to_varchar2 (replace ('6f, 63, 6C, 74, 6f, 6d ',', ') value from dual;

Value

--------------------------------------------------------------------------------

Oracle Tom

 

I do not know whether the data types such as time can be converted.