Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT *
FROM   JSON_TABLE(
         '{
           "widget": {
             "debug": "on",
             "window": {
               "title": "Sample Konfabulator Widget",
               "name": "main_window",
               "width": 500,
               "height": 500
             },
             "image": { 
               "src": "Images/Sun.png",
               "name": "sun1",
               "hOffset": 250,
               "vOffset": 250,
               "alignment": "center"
             },
             "text": {
               "data": "Click Here",
               "size": 36,
               "style": "bold",
               "name": "text1",
               "hOffset": 250,
               "vOffset": 100,
               "alignment": "center",
               "onMouseUp": "sun1.opacity = (sun1.opacity / 100) * 90;"
             }
           }
         }',
         '$.widget'
         COLUMNS
           debug       VARCHAR2(3)  PATH '$.debug',
           title       VARCHAR2(50) PATH '$.window.title',
           window_name VARCHAR2(20) PATH '$.window.name',
           width       NUMBER(5,0)  PATH '$.window.width',
           height      NUMBER(5,0)  PATH '$.window.height',
           src         VARCHAR2(50) PATH '$.image.src',
           image_name  VARCHAR2(20) PATH '$.image.name',
           hOffset     NUMBER(5,0)  PATH '$.image.hOffset',
           vOffset     NUMBER(5,0)  PATH '$.image.vOffset',
           align       VARCHAR2(10) PATH '$.image.alignment'
       );

DEBUG	TITLE	WINDOW_NAME	WIDTH	HEIGHT	SRC	IMAGE_NAME	HOFFSET	VOFFSET	ALIGN
on	Sample Konfabulator Widget	main_window	500	500	Images/Sun.png	sun1	250	250	center