HI
My database is 11.2..0.2.0. I have the below JSON String. I would like to extract the values against the attributes in the string:
[{“FirstName” : “abc”,”Lastname” : “xyz” ,”Mpi” :10002},{“FirstName” : “cbd”,”Lastname” : “adc” ,”Mpi” :10003}]
I am using the below query for reading the independent values to start with, But no luck:
SELECT
TRIM('?' FROM
REGEXP_SUBSTR(
'[{“FirstName” : “abc”,”Lastname” : “xyz” ,”Mpi” :10002},{“FirstName” : “cbd”,”Lastname” : “adc” ,”Mpi” :10003}]',
'[^[{":",]+',1,4)
)
FROM DUAL;
Please help me in this.