Oracle PL/SQL/System Packages/utl raw

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

utl_raw.bit_and

   <source lang="sql">

SQL> SQL> select utl_raw.bit_and( "01", "0302" ) from dual; UTL_RAW.BIT_AND("01","0302")

0102 1 row selected. SQL> -- 

</source>


utl_raw.bit_complement

   <source lang="sql">

SQL> SQL> select utl_raw.bit_complement( "010203" ) from dual; UTL_RAW.BIT_COMPLEMENT("010203")

FEFDFC 1 row selected. SQL> -- 

</source>


utl_raw.bit_or

   <source lang="sql">

SQL> SQL> select utl_raw.bit_or( "01", "0302" ) from dual; UTL_RAW.BIT_OR("01","0302")

0302 1 row selected. SQL> -- 

</source>


utl_raw.bit_xor

   <source lang="sql">

SQL> SQL> select utl_raw.bit_xor( "01", "0302" ) from dual; UTL_RAW.BIT_XOR("01","0302")

0202 1 row selected. SQL> -- 

</source>


utl_raw.cast_from_binary_integer

   <source lang="sql">

SQL> SQL> select utl_raw.cast_from_binary_integer( 12345 ) from dual; UTL_RAW.CAST_FROM_BINARY_INTEGER(12345)

00003039 1 row selected. SQL> -- 

</source>


utl_raw.cast_from_number

   <source lang="sql">

SQL> SQL> select utl_raw.cast_from_number( 123.45 ) from dual; UTL_RAW.CAST_FROM_NUMBER(123.45)

C202182E 1 row selected. SQL> -- 

</source>


utl_raw.cast_to_binary_integer

   <source lang="sql">

SQL> SQL> select utl_raw.cast_to_binary_integer( "00003039" ) from dual; UTL_RAW.CAST_TO_BINARY_INTEGER("00003039") 

                                    12345

1 row selected. SQL> SQL> -- 

</source>


utl_raw.cast_to_number

   <source lang="sql">

SQL> SQL> select utl_raw.cast_to_number( "c202182e" ) from dual; UTL_RAW.CAST_TO_NUMBER("C202182E") 

                           123.45

1 row selected. SQL> -- 

</source>


utl_raw.cast_to_raw

   <source lang="sql">

SQL> SQL> select utl_raw.cast_to_raw( "Hello World!" ) data 

 2    from dual;

DATA

48656C6C6F20576F726C6421 1 row selected. SQL> SQL> -- 

</source>


utl_raw.cast_to_raw( "Cameron" )

   <source lang="sql">

SQL> SQL> select utl_raw.cast_to_raw( "Cameron" ) from dual; UTL_RAW.CAST_TO_RAW("CAMERON")

43616D65726F6E 1 row selected. SQL> -- 

</source>


utl_raw.cast_to_varchar2( "43616D65726F6E")

   <source lang="sql">

SQL> SQL> select utl_raw.cast_to_varchar2( "43616D65726F6E") from dual; UTL_RAW.CAST_TO_VARCHAR2("43616D65726F6E")

Cameron 1 row selected. SQL> -- 

</source>


utl_raw.compare( "010203", "01020304", "04" )

   <source lang="sql">

SQL> SQL> SQL> select utl_raw.rupare( "010203", "01020304", "04" ) from dual; UTL_RAW.ruPARE("010203","01020304","04") 

                                       0

1 row selected. SQL> -- 

</source>


utl_raw.compare( "01050304", "01020304" )

   <source lang="sql">

SQL> SQL> select utl_raw.rupare( "01050304", "01020304" ) from dual; UTL_RAW.ruPARE("01050304","01020304") 

                                    2

1 row selected. SQL> -- 

</source>


utl_raw.concat( "9", "0102", "ff", "0a2b" )

   <source lang="sql">

SQL> SQL> select utl_raw.concat( "9", "0102", "ff", "0a2b" ) from dual; UTL_RAW.CONCAT("9","0102","FF","0A2B")

090102FF0A2B 1 row selected. SQL> SQL> -- 

</source>


utl_raw.copies( "010203", 4 )

   <source lang="sql">

SQL> SQL> select utl_raw.copies( "010203", 4 ) from dual; UTL_RAW.COPIES("010203",4)

010203010203010203010203 1 row selected. SQL> -- 

</source>


utl_raw.length( "43616D65726F6E")

   <source lang="sql">

SQL> SQL> SQL> select utl_raw.length( "43616D65726F6E") from dual; UTL_RAW.LENGTH("43616D65726F6E") 

                              7

1 row selected. SQL> -- 

</source>


utl_raw.overlay( "aabb", "010203" )

   <source lang="sql">

SQL> SQL> SQL> select utl_raw.overlay( "aabb", "010203" ) from dual; UTL_RAW.OVERLAY("AABB","010203")

AABB03 1 row selected. SQL> -- 

</source>


utl_raw.overlay( "aabb", "010203", 2 )

   <source lang="sql">

SQL> SQL> SQL> select utl_raw.overlay( "aabb", "010203", 2 ) from dual; UTL_RAW.OVERLAY("AABB","010203",2)

01AABB 1 row selected. SQL> -- 

</source>


utl_raw.overlay( "aabb", "010203", 2, 1 )

   <source lang="sql">

SQL> SQL> select utl_raw.overlay( "aabb", "010203", 2, 1 ) from dual; UTL_RAW.OVERLAY("AABB","010203",2,1)

01AA03 1 row selected. SQL> -- 

</source>


utl_raw.overlay( "aabb", "010203", 5 )

   <source lang="sql">

SQL> SQL> SQL> select utl_raw.overlay( "aabb", "010203", 5 ) from dual; UTL_RAW.OVERLAY("AABB","010203",5)

01020300AABB 1 row selected. SQL> -- 

</source>


utl_raw.overlay( "aabb", "010203", 5, 1, "FF" )

   <source lang="sql">

SQL> SQL> select utl_raw.overlay( "aabb", "010203", 5, 1, "FF" ) from dual; UTL_RAW.OVERLAY("AABB","010203",5,1,"FF")

010203FFAA 1 row selected. SQL> -- 

</source>


utl_raw.reverse( "0102030405" )

   <source lang="sql">

SQL> SQL> select utl_raw.reverse( "0102030405" ) from dual; UTL_RAW.REVERSE("0102030405")

0504030201 1 row selected. SQL> -- 

</source>


utl_raw.substr( "0102030405", 3, 2 )

   <source lang="sql">

SQL> SQL> SQL> select utl_raw.substr( "0102030405", 3, 2 ) from dual; UTL_RAW.SUBSTR("0102030405",3,2)

0304 1 row selected. SQL> -- 

</source>


utl_raw.translate( "0102030405", "0203", "06" )

   <source lang="sql">

SQL> SQL> SQL> select utl_raw.translate( "0102030405", "0203", "06" ) from dual; UTL_RAW.TRANSLATE("0102030405","0203","06")

01060405 1 row selected. SQL> -- 

</source>


utl_raw.transliterate( "010203040502", "0809", "01020304", "0a" )

   <source lang="sql">

SQL> SQL> select utl_raw.transliterate( "010203040502", "0809", "01020304", "0a" ) from dual; UTL_RAW.TRANSLITERATE("010203040502","0809","01020304","0A")

08090A0A0509 1 row selected. SQL> -- 

</source>


utl_raw.xrange( "01", "11" )

   <source lang="sql">

SQL> SQL> select utl_raw.xrange( "01", "11" ) from dual; UTL_RAW.XRANGE("01","11")

0102030405060708090A0B0C0D0E0F1011 1 row selected. SQL> -- 

</source>


utl_raw.xrange( "fa", "06" )

   <source lang="sql">

SQL> SQL> select utl_raw.xrange( "fa", "06" ) from dual; UTL_RAW.XRANGE("FA","06")

FAFBFCFDFEFF00010203040506 1 row selected. SQL> -- 

</source>
Источник — «http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Packages/utl_raw&oldid=1309»