Hi experts,
I have a question on sys_guid function. I want to use it to generate and store primary key values which is stored in a table as varchar2 data. What I read in the documentation is that sys_guid() function returns a raw value of up to 16 bytes. Now I don't want to define the column as RAW but as VARCHAR2. So for this need, can I directly use the output of sys_guid to insert in a VARCHAR2 column or should I use RAWTOHEX function to convert it and then use that value?