RE: UTL_RAW.CAST_TO_VARCHAR2

From: Neil Chandler <neil_chandler@xxxxxxxxxxx>
To: <leizeng2003@xxxxxxxxx>, Oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Sun, 3 Mar 2013 00:54:34 +0000

If you are interested in using the UTL_RAW.CAST_TO_VARCHAR2, then the correct 
input is raw hex, rather than the contents of optimizer_env.
For example, it's quite useful in decoding the low/high values in 
DBA_TAB_COLUMNS
  1*  select 
table_name,column_name,low_value,utl_raw.cast_to_varchar2(low_value) Actual 
from user_tab_columns where table_name = 'TEST1'SQL> /
TABLE_NAME                     COLUMN_NAME                    LOW_VALUE         
   ACTUAL------------------------------ ------------------------------ 
-------------------- --------------------TEST1                          COL1    
                       4141414141           AAAAA

SQL> select min(col1) from test1;
MIN(COL1)----------AAAAA
If you are interested in the contents of v$sql.optimizer_env (or 
dba_hist_optimizer_env), I'm afraid I don't know how to decode that. I think 
Julian Dyke may have an explanation for it somewhere on his website? Maybe.
regards
Neil Chandler.
> Date: Mon, 4 Feb 2013 14:09:21 -0800
> From: leizeng2003@xxxxxxxxx
> SQL>  select
> utl_raw.cast_to_varchar2(OPTIMIZER_ENV)
>   from D  2  BA_HIST_OPTIMIZER_ENV where
> optimizer_env_hash_value)66359101;
>  
> UTL_RAW.CAST_TO_VARCHAR2(OPTIMIZER_ENV)
> --------------------------------------------------------------------------------
> &
> = 3 VAEUQ!UUUETUXYUDeUUUQUQQ"UT
>
> How
> I can get a meaningful string from UTL_RAW.CAST_TO_VARCHAR2?
> Did I miss anything?

                                          
--
//www.freelists.org/webpage/oracle-l

RE: UTL_RAW.CAST_TO_VARCHAR2

Other related posts: