SQL> create table t (c1 varchar2(32));
 
Table created.
 
SQL> insert into t values(sys_guid());  --This is WRONG because I am inseting raw data into varchar2 column , am I right?
1 row created.
 
 
 
 SQL> insert into t values(rawtohex(sys_guid()));   --this is the right way to insert the data , correct? 
 
1 row created.
 
SQL > commit;
 
Commit complete.
 
SQL > select * from t;
 
C1
--------------------------------
C800DC90BC14936BE040050A749536C1
C800DC90BC15936BE040050A749536C1
 
SQL>