Hi,
Ran through the 26ai Duality Views tutorial steps by Layla, and at the end the last query returns the following:
SELECT JSON_VALUE(s.data, '$.name') AS attendee,
jt.sessionId,
jt.title,
jt.location,
jt.speakerId,
jt.speaker_name
FROM schedule_dv s
CROSS JOIN JSON_TABLE(
s.data, '$'
COLUMNS (
NESTED PATH '$.schedule[*]'
COLUMNS (
sessionId NUMBER PATH '$.sessionId' NULL ON ERROR,
title VARCHAR2(50) PATH '$.title' NULL ON ERROR,
location VARCHAR2(20) PATH '$.location' NULL ON ERROR,
speakerId NUMBER PATH '$.speakerId' NULL ON ERROR,
speaker_name VARCHAR2(50) PATH '$.name' NULL ON ERROR
)
)
) jt
ORDER BY attendee, sessionId
ATTENDEE SESSIONID TITLE LOCATION SPEAKERID SPEAKER_NAME
---------- --------- ----- -------- --------- ------------
Doug
Shashank
Elapsed: 00:00:00.013
2 rows selected.
So just the attendee appears in the output; I've checked the tables and they have data in them so was wondering if this query is correct or I've made a mistake.
Any ideas?
Thanks & regards
Gary