Slide 14
Slide 14 text
【補足】JSON Relational Duality View
Copyright © 2024, Oracle and/or its affiliates
14
CREATE JSON RELATIONAL DUALITY VIEW team_dv AS
SELECT JSON {
'teamId' : t.team_id,
'name' : t.name,
'points' : t.points,
'driver' :
[ SELECT JSON {'driverId' : d.driver_id,
'name' : d.name,
'points' : d.points WITH NOCHECK}
FROM driver d WITH INSERT UPDATE
WHERE d.team_id = t.team_id ]
}
FROM team t WITH INSERT UPDATE DELETE;
JSON Relational Duality View 構成する表
'{"teamId" : 301,
"name" : "Red Bull",
"points" : 0,
"driver" : [ {"driverId" : 101,
"name" : "Max Verstappen",
"points" : 0},
{"driverId" : 102,
"name" : "Sergio Perez",
"points" : 0} ]}'
Insert into xxx
JSON
Select