Query: blockstorage_block_volume_backup_policy_schedules

select
  s ->> 'period' as "Period",
  s ->> 'timeZone' as "Time Zone",
  s ->> 'hourOfDay' as "Hour Of Day",
  s ->> 'backupType' as "Backup Type",
  s ->> 'dayOfMonth' as "Day Of Month",
  s ->> 'offsetType' as "Offset Type",
  s ->> 'offsetSeconds' as "Offset Seconds",
  s ->> 'retentionSeconds' as "Retention Seconds"
from
  oci_core_volume as v,
  oci_core_volume_backup_policy as p,
  jsonb_array_elements(schedules) as s
where
  p.id = v.volume_backup_policy_id
  and v.id = $1
union
  select
  s ->> 'period' as "Period",
  s ->> 'timeZone' as "Time Zone",
  s ->> 'hourOfDay' as "Hour Of Day",
  s ->> 'backupType' as "Backup Type",
  s ->> 'dayOfMonth' as "Day Of Month",
  s ->> 'offsetType' as "Offset Type",
  s ->> 'offsetSeconds' as "Offset Seconds",
  s ->> 'retentionSeconds' as "Retention Seconds"
from
  oci_core_volume as v,
  oci_core_volume_default_backup_policy as p,
  jsonb_array_elements(schedules) as s
where
  p.id = v.volume_backup_policy_id
  and v.id = $1;