Query: nosql_table_children_for_nosql_table

with recursive child_tables as (
  select
    name,
    id
  from
    oci_nosql_table
  where
    id = $1
  union
  select
    t.name,
    t.id
  from
    oci_nosql_table t
    inner join child_tables s ON t.name like s.name || '.' || '%'
)
select
  id as child_table_id
from
  child_tables