Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Packages

 

Difference between utl_raw length and length

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.length(r), length(r)/2 from t; UTL_RAW.LENGTH(R) LENGTH(R)/2 ----------------- -----------                10          10 SQL> SQL> drop table t; Table dropped. SQL>