Oracle PL/SQL Tutorial/Character String Functions/DUMP

Материал из SQL эксперт
Перейти к: навигация, поиск

dump(90101,16)

   <source lang="sql">

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</source>

dump(reverse(90101),16)

   <source lang="sql">

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

SQL> SQL></source>

Источник — «http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Character_String_Functions/DUMP&oldid=4357»