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 |