Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE products (products_id INT, raw16column RAW(16));
INSERT INTO products( products_id, raw16column )
VALUES (1, HEXTORAW('000102030405060708090A0B0C0D0E0F') );
1 rows affected

select p.*,
       RAWTOHEX(raw16column)
from   PRODUCTS p
order by PRODUCTS_ID desc
fetch next 20 rows only


PRODUCTS_ID
RAW16COLUMN
RAWTOHEX(RAW16COLUMN)


1
0x000102030405060708090A0B0C0D0E0F
000102030405060708090A0B0C0D0E0F


select p.*,
       SUBSTR(raw16column,7,2)
       ||SUBSTR(raw16column,5,2)
       ||SUBSTR(raw16column,3,2)
       ||SUBSTR(raw16column,1,2)
       ||'-'
       ||SUBSTR(raw16column,11,2)
       ||SUBSTR(raw16column,9,2)
       ||'-'
       ||SUBSTR(raw16column,15,2)
       ||SUBSTR(raw16column,13,2)
       ||'-'
       ||SUBSTR(raw16column,17,16)
         AS guid
from   PRODUCTS p
order by PRODUCTS_ID desc
fetch next 20 rows only


PRODUCTS_ID
RAW16COLUMN
GUID


1
0x000102030405060708090A0B0C0D0E0F
03020100-0504-0706-08090A0B0C0D0E0F