utl_raw.cast_to_raw : utl_raw « System Packages « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Packages
  3. utl_raw
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.








31.39.utl_raw
31.39.1.utl_raw.cast_to_raw
31.39.2.Use utl_raw.cast_to_raw to convert string to raw
31.39.3.select utl_raw.cast_to_varchar2(hextoraw('787878')) from dual
31.39.4.select utl_raw.cast_to_varchar2(hextoraw('534d495448')) from dual
31.39.5.Difference between utl_raw.length and length
31.39.6.Use utl_raw.substr