SQL> create table t (value clob, constraint check_json check(value is json));

Table created.

SQL>
SQL> insert into t
  2     select '{"Id" : 1, "Name": "ios" }' from dual
  3     union all
  4     select '{"id" : 2, "name": "android" }' from dual;

2 rows created.

SQL>
SQL> select t.value.Id
  2        ,t.value.Name
  3        ,t.value.id
  4        ,t.value.name
  5    from t t;

ID                             NAME                           ID                             NAME
------------------------------ ------------------------------ ------------------------------ ------------------------------
1                              ios
                                                              2                              android

select json_query("T"."VALUE" format json,
                  '$.Id' returning varchar2(4000) asis without array wrapper null on error) "ID",
       json_query("T"."VALUE" format json,
                  '$.Name' returning varchar2(4000) asis without array wrapper null on error) "NAME",
       json_query("T"."VALUE" format json,
                  '$.id' returning varchar2(4000) asis without array wrapper null on error) "ID",
       json_query("T"."VALUE" format json,
                  '$.name' returning varchar2(4000) asis without array wrapper null on error) "NAME"
  from "T" "T";

create table c(cust_id, name) as
select rownum, 'name'||rownum from dual
connect by level <= 3;

create table ord(cust_id,dt,value) as
select 1,add_months(date'2016-01-01',rownum-1),100+rownum from dual connect by level <= 12
union all
select 2,trunc(sysdate),12345 from dual;

select c.*, ord.*
  from c left join ord partition by(trunc(dt, 'mm')) on c.cust_id = ord.cust_id;

select *--c.*, ord.*
  from c left join ord partition by(trunc(dt, 'mm')) on c.cust_id = ord.cust_id;

SELECT bals, s.period
  FROM
(
SELECT bals,
       TO_CHAR(:p_datak,'month YYYY')period
  FROM (
        SELECT 1 bals
          FROM TABLE(Get_Spis_Integer(1)) -- табличная функция
      ) sel1

) s
GROUP BY s.bals