How to create a TLV QR Code ?

 

Hex Representation 

SELECT '01'||TO_CHAR(12, 'FM0X')||RAWTOHEX('Bobs Records')||

 '02'||TO_CHAR(15, 'FM0X')||RAWTOHEX('310122393500003')||

  '03'||TO_CHAR(20, 'FM0X')||RAWTOHEX('2022-04-25t15:30:000Z') ||

   '04'||TO_CHAR(7, 'FM0X')||RAWTOHEX('1000.00') ||

    '05'||TO_CHAR(6, 'FM0X')||RAWTOHEX('150.00') AS hex_representation FROM dual;

Base64 Representation 

SELECT UTL_RAW.CAST_TO_VARCHAR2(

UTL_ENCODE.BASE64_enCODE(

'01'||TO_CHAR(12, 'FM0X')||RAWTOHEX('Bobs Records')||

 '02'||TO_CHAR(15, 'FM0X')||RAWTOHEX('310122393500003')||

  '03'||TO_CHAR(20, 'FM0X')||RAWTOHEX('2022-04-25t15:30:000Z') ||

   '04'||TO_CHAR(7, 'FM0X')||RAWTOHEX('1000.00') ||

    '05'||TO_CHAR(6, 'FM0X')||RAWTOHEX('150.00')

    

)) AS base64_representation FROM dual;