SELECT utl_raw.cast_to_Nvarchar2(dbms_lob.substr(raw_col,1000,1)) FROM test;

this select out put SHOULD BE LIKE YE 195 45

SO THE OUT PUT FOR CHARTER IS OK (YE)

BUT THE OUTPUT FOR NUMBERS IS [] LIKE THIS NOT NUMBERS

THIS IS THE PROBLEM HOW CAN I CONVERT HEXA TO NUMBERS