json - ORACLE SQL, DeserializeJSON -

i have serialized json object follows:

{ "sender": "service", "type": "spiglassauditedorder", "data": "{\"header\":{\"id\":\"asdfdsa-8687689-asdfd\",\"eventtype\":\"order\"}" } 

in "data" path, want deserialize path. however, can't past one, of additional "\" , second, additional set of quotation marks before data -> header path.

i used following sql statement has json_table function:

with tmp (   select jt1.*   schema.table t,     json_table(t.payload, '$'     columns       sender path '$.sender',       type path '$.type',       data path '$.data') jt1     t.queue_config_fk = 37 ) select * tmp; 

but data returns null:

what prefer return actual deserialized json object.

any appreciated.

json_table creates virtual table json. try use json_query select 1 or more values.