Slide 63
Slide 63 text
SQL/JSONパス式の項目メソッドの追加
追加された項目メソッド
• データ型変換:float()、double()、binary()、ymInterval()、dsInterval()
• 集計:avg()、count()、minNumber()、maxNumber()、minString()、maxString()、sum()
SQL/JSON構文の改善
Copyright © 2021, Oracle and/or its affiliates
63
集計の例
with jtab as (select JSON_Array(1,2,3,4,5,6) jcol from dual)
select jtab.jcol[*].maxNumber() from jtab jtab;
JTAB.JCOL[*].MAXNUMBER()
------------------------
6
with jtab as (select JSON_Array(1,2,3,4,5,6) jcol from dual)
select jtab.jcol[*].sum() from jtab jtab;
JTAB.JCOL[*].SUM()
------------------
21
with jtab as (select JSON_Array(1,2,3,4,5,6) jcol from dual)
select jtab.jcol[*].avg() from jtab jtab;
JTAB.JCOL[*].AVG()
------------------
3.5