Json array Count in Oracle sql

Question

I'm having below value in the column "c1" (which is of datatype clob) on table "t1" in oracle (version 19c )

Data

[{"ID":"1","DUPID":"1"},{"ID":"2","DUPID":"2"},{"ID":"3","DUPID":"3"},{"ID":"4","DUPID":"4"},{"ID":"5","DUPID":"5"},{"ID":"6","DUPID":"6"},{"ID":"7","DUPID":"7"}]

I would like to get the count of the array. I've queried like below. But would like to know if there is a better way to achieve this.

Query used:

select regexp_count ( c1,'},{' ) +1 from t1 ;

p3consulting · Accepted Answer · 2022-09-21 17:08:21Z

3

select 
    JSON_value('[0,1,2,3,4]', '$.size()')
from dual ;

answered Sep 21, 2022 at 17:08

p3consulting

5,4212 gold badges14 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Json array Count in Oracle sql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related