By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
REGEXP_SUBSTR(S,'[^{}]+',1,2*1) |
---|
property1_string |
REGEXP_SUBSTR(S,'[^{}]+',1,2*2) |
---|
property2_string |
REGEXP_SUBSTR(S,'[^{}]+',1,2*3) |
---|
property3_string |
REGEXP_SUBSTR(S,'[^{}]+',1,2*4) |
---|
property4_string |