select t.*
from vf_customer_registers r
left join (json_table(r.register,
'$' columns(day_price varchar2(80) path '$.DAY_PRICE' null on empty,
base_price number path '$.BASE_PRICE' null on empty,
base_hours number path '$.BASE_HOURS' null on empty,
refreshments varchar2(80) path '$.REFRESHMENTS' null on empty,
penalty_hour number path '$.PENALTY_HOUR' null on empty,
long_day format json path '$.LONG_DAY' null on empty,
long_day_lunch number path '$.LONG_DAY_LUNCH' null on empty,
discount_sibling varchar2(80) path '$.DISCOUNT_SIBLING' null on empty,
discount_refreshments varchar2(80) path '$.DISCOUNT_REFRESHMENTS' null on empty,
discount_kindergarten number path '$.DISCOUNT_KINDERGARTEN' null on empty,
discount_sports number path '$.DISCOUNT_SPORTS' null on empty))) t on 1 = 1
order by r.customer, r.valid_from desc;