в 13:45, 26 мая 2010

2010-05-26T13:45:46Z

Admin: 1 версия

2010-05-26T10:06:00Z

1 версия

Новая страница

== Difference between utl_raw.length and length==



<source lang="sql">
SQL>
SQL> create table t ( r raw(10) );
Table created.
SQL>
SQL>
SQL> insert into t values ( utl_raw.cast_to_raw("helloWorld" ) );
1 row created.
SQL>
SQL> select utl_raw.length(r), length(r)/2 from t;
UTL_RAW.LENGTH(R) LENGTH(R)/2
----------------- -----------
10 10
SQL>
SQL>
SQL> drop table t;
Table dropped.
SQL></source>

== select utl_raw.cast_to_varchar2(hextoraw("534d495448")) from dual==



<source lang="sql">
SQL>
SQL>
SQL> select utl_raw.cast_to_varchar2(hextoraw("534d495448")) from dual;
UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW("534D495448"))
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SMITH
SQL></source>

== select utl_raw.cast_to_varchar2(hextoraw("787878")) from dual==



<source lang="sql">
SQL>
SQL>
SQL> select utl_raw.cast_to_varchar2(hextoraw("787878")) from dual;
UTL_RAW.CAST_TO_VARCHAR2(HEXTORAW("787878"))
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
xxx
SQL></source>

== Use utl_raw.cast_to_raw to convert string to raw==



<source lang="sql">
SQL>
SQL>
SQL> select utl_raw.cast_to_raw( "Hello World!" ) data
2 from dual;
DATA
--------------------------------------------------------------------------------
48656C6C6F20576F726C6421
SQL></source>

== Use utl_raw.substr==



<source lang="sql">
SQL>
SQL> create table t ( r raw(10) );
Table created.
SQL>
SQL> insert into t values ( utl_raw.cast_to_raw("helloWorld" ) );
1 row created.
SQL>
SQL> select utl_raw.substr(r,2,3) r1, hextoraw(substr(r,3,6)) r2 from t
2
SQL> drop table t;
Table dropped.
SQL></source>

== utl_raw.cast_to_raw==



<source lang="sql">
SQL>
SQL> create table demo
2 ( id int primary key,
3 theBlob blob
4 )
5 /
Table created.
SQL> update demo set theBlob = utl_raw.cast_to_raw("Hello World") where id = 1
2 /
0 rows updated.
SQL> drop table demo;
Table dropped.</source>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL Tutorial/System Packages/utl raw - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия