in pl/sql - can we process dynamically JSON keys and elements and convert into table rows and columns
{"Result":{"RequestID":"60c6ca54-b7f2-4e56-b742-02a9e6701004", "Offset":"1", "Size":"90000", "TotalCount":"4", "RelationshipReferenced":["ProductToCountry", "BundleToCountry", "ProductToBundle", "BundleToBundle", "ProductToBrands", "BundleToBrands", "EditedVersion"], "Product":[{"CommonSpecUpdateTimestamp":"2018-11-29T05:00:15.555-08:00", "Uri":"entities/1UvAaLX", "UpdatedTime":"2018-11-29T05:01:49.203-08:00", "MPMNumber":"2044719", "VideoVersionNumber":"6000101536", "EditEIDR":null, "ProductionCompany":"Warner Bros.", "ParentTitleID":"389247", "Type":"Season", "LibraryTitle":"Lucifer:S1 (13eps)", "WorldwideTitle":"Lucifer: The Complete First Season", "EpisodicFlag":null, "VersionCategoryCode":"5", "IsVoid":"No", "LOB":"Home Entertainment", "MPMFamilyNumber":null, "SeriesName":"WB - UNEXPLODED VIDEO VERSION NON - IP", "Brand":["Vertigo"], "SAPSeasonID":null, "ALID":"0188376276761", "AbstractEIDR":null}, {"CommonSpecUpdateTimestamp":"2018-04-01T09:15:27.507-07:00", "Uri":"entities/1Pms3vz", "UpdatedTime":"2018-11-29T05:12:27.764-08:00", "MPMNumber":"2003271", "VideoVersionNumber":"6000000520", "EditEIDR":"10.5240/4F96-A0A3-87EC-C203-0F6A-F", "ProductionCompany":"Warner Home Video", "ParentTitleID":"10314", "Type":"Feature", "LibraryTitle":"Batman: Mask of the Phantasm", "WorldwideTitle":"Batman: Mask of the Phantasm", "EpisodicFlag":null, "VersionCategoryCode":"1", "IsVoid":"No", "LOB":"Home Entertainment", "ISAN":"0000-0000-0062-0000-A-0000-0000-7", "ALID":"3013746122653", "AbstractEIDR":"10.5240/12B5-CAE3-64A6-AFD5-27A4-W", "MPMFamilyNumber":null, "SeriesName":null, "SeasonParentTitleID":null, "Runtime":null, "Brand":["DC Comics"], "SAPSeasonID":null, "Country":[{"Uri":"relations/7syONY0", "UpdatedTime":"2018-11-29T05:12:28.745-08:00", "Name":"BE", "CountryDescription":"Belgium", "Franchise":["KID"], "EpisodeNumber":null, "AiringInfo":[null], "Ratings":[{"ID":"UR, CCFC", "Advisory":null, "RatingLanguage":"de", "DisplayValue":null}, {"ID":"6, Kijkwijzer", "Advisory":null, "RatingLanguage":"nl", "DisplayValue":null}, {"ID":"Invalid, Invalid", "Advisory":null, "RatingLanguage":"nl", "DisplayValue":null, "IsVoid":"Yes"}, {"ID":"6, CCFC", "Advisory":null, "RatingLanguage":"fr", "DisplayValue":null}], "TheatricalReleaseDate":null, "SeasonNumber":null, "InitialBroadcastDate":null, "Language":[{"CountryLanguage":"nl", "LanguageDescription":"Dutch", "ShortSynopsis":"Donkere gestalten bedreigen Gotham City, dus is het tijd voor de etrugkeer van Batman, de zwarte wreker.", "LongSynopsis":"Donkere gestalten bedreigen Gotham City, dus is het tijd voor de etrugkeer van Batman, de zwarte wreker. Batman en de Geest is een unieke lagspeeltekenfilm die, vanwege de perfecte animatie, jong en oud weer in veroering brengt.", "GenericSynopsis":"Donkere gestalten bedreigen Gotham City, dus is het tijd voor de etrugkeer van Batman, de zwarte wreker. Batman en de Geest is een unieke lagspeeltekenfilm die, vanwege de perfecte animatie, jong en oud weer in veroering brengt.", "EpisodeName":null, "DisplayTitle":"Batman En De Geest", "Genre":["Adventure"], "Copyright":"© 1993 Warner Bros. Entertainment Co. All Rights Reserved.", "CriticQuote":"\"The film is stylishly dark in the manner of the Tim Burton \"Batman\" films and the graphic novels of the late '80s\" - Richard Harrington, Washington Post", "AppleVendorIDs":[{"VID":"883316108314", "IsActive":"Yes"}], "IsVoid":"No"}, {"CountryLanguage":"fr", "LanguageDescription":"French", "ShortSynopsis":"Un parrain de la pègre est assassiné par un homme en cape noire. Le nouveau procureur Arthur Reeves accuse Batman. Désormais traqué, Batman enquête pour retrouver le véritable meurtrier.", "LongSynopsis":"Unmasking the Phantasm is just one of the twists in Batman: Mask of Phantasm, \"one of the most imaginative films of the past year\" (Chuck Rich, Westwood One). Only here will you discover all-new revelations about Batman's past, his archrival the Joker and the most grueling battle of Batman's life - the choice between his love of a beautiful woman and his vow to be the defender of right.\n\n\n\nBatman: Mask of Phantasm is a \"mystery that is genuinely absorbing, suspenseful and moving\" (Cincinnati Enquirer) and a film no fan should be without! Can the Dark Knight elude the police, capture the Phantasm and clear his name?\n\n\n\nYear: 1993\n\nDirector: Eric Radomski\n\nStarring: Kevin Conroy, Mark Hamill, Dana Delany, Hart Bochner, Abe Vigoda", "GenericSynopsis":"Un parrain de la pègre est assassiné par un homme en cape noire. Le nouveau procureur Arthur Reeves accuse Batman. Désormais traqué, Batman enquête pour retrouver le véritable meurtrier. Mais dans le même temps, Bruce Wayne retrouve aussi une ancienne petite-amie, Andréa Beaumont, dont le père fut autrefois mêlé aux affaires des gangsters tués. L'occasion pour le chevalier noir de replonger dans son passé, à l'époque où il faillit renoncer à devenir un justicier...", "EpisodeName":null, "DisplayTitle":"Batman Contre Le Fantome Masque", "Genre":["Action", "Adventure"], "Copyright":"© 1993 Warner Bros. Entertainment Co. All Rights Reserved.", "CriticQuote":"\"The film is stylishly dark in the manner of the Tim Burton \"Batman\" films and the graphic novels of the late '80s\" - Richard Harrington, Washington Post", "AppleVendorIDs":[{"VID":"883316759325", "IsActive":"Yes"}], "IsVoid":"No"}, {"CountryLanguage":"de", "LanguageDescription":"German", "ShortSynopsis":"The Batman legend continues in this story that tells of Batman's most difficult battle, as well as his confrontation with a mysterious killer, who holds the key to Batman's secret past.", "LongSynopsis":"Unmasking the Phantasm is just one of the twists in Batman: Mask of Phantasm, \"one of the most imaginative films of the past year\" (Chuck Rich, Westwood One). Only here will you discover all-new revelations about Batman's past, his archrival the Joker and the most grueling battle of Batman's life - the choice between his love of a beautiful woman and his vow to be the defender of right.\n\n\n\nBatman: Mask of Phantasm is a \"mystery that is genuinely absorbing, suspenseful and moving\" (Cincinnati Enquirer) and a film no fan should be without! Can the Dark Knight elude the police, capture the Phantasm and clear his name?\n\n\n\nYear: 1993\n\nDirector: Eric Radomski\n\nStarring: Kevin Conroy, Mark Hamill, Dana Delany, Hart Bochner, Abe Vigoda", "GenericSynopsis":"Nur hier entdeckt man völlig neue Enthüllungen über Batmans Vergangenheit, seinen Erzrivalen den Joker und den härtesten Kampf seines Lebens – die Wahl zwischen seiner Liebe zu einer schönen Frau und seinem Schwur, der Verteidiger von Recht und Ordnung zu sein.", "EpisodeName":null, "DisplayTitle":"Batman und das Phantom", "Genre":["Adventure", "Action"], "Copyright":"© 1993 Warner Bros. Entertainment Inc. All Rights Reserved.", "CriticQuote":"\"The film is stylishly dark in the manner of the Tim Burton \"Batman\" films and the graphic novels of the late '80s\" - Richard Harrington, Washington Post", "AppleVendorIDs":[{"VID":"883316759325", "IsActive":"Yes"}], "IsVoid":"No"}], "IsVoid":null}]}, {"CommonSpecUpdateTimestamp":"2018-08-26T12:03:00.476-07:00", "Uri":"entities/1kAIi9Q", "UpdatedTime":"2018-11-29T04:35:42.382-08:00", "MPMNumber":"2072263", "VideoVersionNumber":"6000103639", "EditEIDR":"10.5240/32BA-DFC6-C5AE-3DD0-171B-F", "ProductionCompany":"Warner Bros.", "ParentTitleID":"391293", "Type":"Episode", "LibraryTitle":"Lucifer:S1E06-Favorite Son", "WorldwideTitle":"Lucifer: Season 1 Episode 6 Favorite Son", "EpisodicFlag":"Yes", "VersionCategoryCode":"6", "IsVoid":"No", "LOB":"Home Entertainment", "ALID":"0985322790749", "AbstractEIDR":"10.5240/253B-7A27-BFDB-EE95-1B96-B", "MPMFamilyNumber":"1027367", "SeriesName":"WB - UNEXPLODED VIDEO VERSION NON - IP", "SeasonParentTitleID":"389247", "Runtime":null, "Brand":[null], "SAPSeasonID":"6000101536", "Country":[{"Uri":"relations/2mqXFy6", "UpdatedTime":"2018-11-29T04:35:43.701-08:00", "Name":"CH", "CountryDescription":"Switzerland", "Franchise":["TV"], "EpisodeNumber":"6", "AiringInfo":[{"Network":null, "AirDate":"2016-02-29", "AiringStartDate":"2016-01-25", "AiringEndDate":"2016-04-25"}], "Ratings":[{"ID":"12, FSK", "Advisory":"NA", "RatingLanguage":"de", "DisplayValue":null}, {"ID":"12, FSK", "Advisory":"NA", "RatingLanguage":"fr", "DisplayValue":null}, {"ID":"12, FSK", "Advisory":"NA", "RatingLanguage":"it", "DisplayValue":null}, {"ID":"12, ch-movies", "Advisory":"NA", "RatingLanguage":"de", "DisplayValue":null, "IsVoid":"Yes"}, {"ID":"16, ch-movies", "Advisory":"NA", "RatingLanguage":"de", "DisplayValue":null, "IsVoid":"Yes"}, {"ID":"12, ch-movies", "Advisory":"NA", "RatingLanguage":"fr", "DisplayValue":null, "IsVoid":"Yes"}, {"ID":"16, ch-movies", "Advisory":"NA", "RatingLanguage":"fr", "DisplayValue":null, "IsVoid":"Yes"}], "TheatricalReleaseDate":null, "SeasonNumber":"1", "InitialBroadcastDate":null, "Language":[{"CountryLanguage":"fr", "LanguageDescription":"French", "ShortSynopsis":"Bien qu’il ait abandonné Chloe dans son enquête sur un groupe de motards, Lucifer lui demande de réintégrer l’affaire après avoir découvert qu’on lui a dérobé un bien très personnel.", "LongSynopsis":null, "GenericSynopsis":"Lucifer abandonne Chloe lorsque son enquête sur un meurtre impliquant un groupe de motards criminels ne l’intéresse plus. Cependant, quand il découvre qu’une chose ayant un grand intérêt personnel pour lui a été dérobée, il demande à Chloe de reprendre l’affaire.", "EpisodeName":"Le Fils préféré", "DisplayTitle":"Lucifer: Saison 1 Episode 6 Le Fils préféré", "Genre":["Detective"], "Copyright":"LUCIFER and all related characters and elements are trademarks of and © DC Comics. © 2016 Warner Bros. Entertainment Inc.", "CriticQuote":null, "AppleVendorIDs":[null], "IsVoid":"No"}, {"CountryLanguage":"de", "LanguageDescription":"German", "ShortSynopsis":"Nachdem Lucifer Chloe bei der Untersuchung einer skrupellosen Bikerbande im Stich gelassen hat, will er wieder am Fall arbeiten, als er feststellt, dass ihm etwas gestohlen wurde.", "LongSynopsis":null, "GenericSynopsis":"Lucifer verlässt Chloe, als ihm ihre Untersuchung einer skrupellosen Bikerbande langweilig wird. Als er jedoch feststellt, dass ihm bei dem Verbrechen ein sehr persönlicher Artikel gestohlen wurde, verlangt er von Chloe, wieder am Fall mitarbeiten zu dürfen.", "EpisodeName":"Der gefallene Engel", "DisplayTitle":"Lucifer: Staffel 1 Episode 6 Der gefallene Engel", "Genre":["Drama", "Fantasy Adventure"], "Copyright":"LUCIFER and all related characters and elements are trademarks of and © DC Comics. © 2016 Warner Bros. Entertainment Inc.", "CriticQuote":null, "AppleVendorIDs":[null], "IsVoid":"No"}, {"CountryLanguage":"it", "LanguageDescription":"Italian", "ShortSynopsis":"After abandoning Chloe during a murder investigation into a ruthless biker gang, Lucifer demands to rejoin the case after he discovers something very personal was stolen from him.", "LongSynopsis":null, "GenericSynopsis":"Lucifer abandons Chloe when he becomes bored with her investigation into a ruthless biker gang murder. However, when he discovers something was stolen during the crime that was very personal to him, he demands that Chloe let him rejoin the case.", "EpisodeName":"Il figlio prediletto", "DisplayTitle":"Lucifer: Stagione 1 Episodio 6 Il figlio prediletto", "Genre":["Drama", "Detective", "Fantasy Adventure"], "Copyright":"LUCIFER and all related characters and elements are trademarks of and © DC Comics. © 2016 Warner Bros. Entertainment Inc.", "CriticQuote":null, "AppleVendorIDs":[null], "IsVoid":"No"}], "IsVoid":"No"}]}, {"CommonSpecUpdateTimestamp":"2018-06-19T21:56:12.089-07:00", "Uri":"entities/B8cN5ma", "UpdatedTime":"2018-11-29T04:37:18.932-08:00", "MPMNumber":"2044719", "VideoVersionNumber":"6000115602", "EditEIDR":"10.5240/8A50-8BFA-3748-DA9D-8085-K", "ProductionCompany":"Warner Home Video", "ParentTitleID":"399346", "Type":"Feature", "LibraryTitle":"DC Super Hero Girls: Legends of Atl", "WorldwideTitle":"DC Super Hero Girls: Legends of Atlantis", "EpisodicFlag":null, "VersionCategoryCode":"1", "IsVoid":"No", "LOB":"Home Entertainment", "ISAN":null, "ALID":"0985422618461", "AbstractEIDR":"10.5240/3B78-944B-7551-453E-CD7A-Q", "MPMFamilyNumber":null, "SeriesName":null, "SeasonParentTitleID":null, "Runtime":null, "Brand":[null], "SAPSeasonID":null, "Country":[{"Uri":"relations/DeMbNYf", "UpdatedTime":"2018-11-29T04:37:18.695-08:00", "Name":"NA", "CountryDescription":"Namibia", "Franchise":[null], "EpisodeNumber":null, "AiringInfo":[null], "Ratings":[{"ID":"UR, na-movies", "Advisory":null, "RatingLanguage":"en", "DisplayValue":null}], "TheatricalReleaseDate":null, "SeasonNumber":null, "InitialBroadcastDate":null, "Language":[{"CountryLanguage":"en", "LanguageDescription":"English", "ShortSynopsis":"It’s up to Wonder Woman, Batgirl and Supergirl to help Aquaman in defending Atlantis and stop the sinister Siren! Get ready for a thrilling adventure!", "LongSynopsis":null, "GenericSynopsis":"Dive deep into adventure with the DC Super Hero Girls in this all-new underwater epic. Sisters of the sea, Siren and Mera catch the students of Super Hero High off guard in a surprise attack to steal a very powerful relic – the Book of Legends. With the book in her possession and harnessing more power than ever, Siren aims to raise an army from the depths of the ocean’s trenches. It’s up to Wonder Woman, Batgirl and Supergirl to help Aquaman in defending Atlantis and stop the sinister Siren! Get ready for a thrilling adventure featuring the DC Super Hero Girls!", "EpisodeName":null, "DisplayTitle":"DC Super Hero Girls: Legends of Atlantis", "Genre":["Childrens", "Family"], "Copyright":"DC SUPER HERO GIRLS and all related characters and elements are trademarks of and © DC Comics. © 2018 Warner Bros. Entertainment Inc.", "CriticQuote":null, "AppleVendorIDs":[{"VID":"888574689261", "IsActive":"Yes"}], "IsVoid":null}], "IsVoid":null}, {"Uri":"relations/DeMbAlt", "UpdatedTime":"2018-11-29T04:34:07.447-08:00", "Name":"ZA", "CountryDescription":"South Africa", "Franchise":[null], "EpisodeNumber":null, "AiringInfo":[null], "Ratings":[{"ID":"UR, za-movies", "Advisory":null, "RatingLanguage":"en", "DisplayValue":null}], "TheatricalReleaseDate":null, "SeasonNumber":null, "InitialBroadcastDate":null, "Language":[{"CountryLanguage":"en", "LanguageDescription":"English", "ShortSynopsis":"It’s up to Wonder Woman, Batgirl and Supergirl to help Aquaman in defending Atlantis and stop the sinister Siren! Get ready for a thrilling adventure!", "LongSynopsis":null, "GenericSynopsis":"Dive deep into adventure with the DC Super Hero Girls in this all-new underwater epic. Sisters of the sea, Siren and Mera catch the students of Super Hero High off guard in a surprise attack to steal a very powerful relic – the Book of Legends. With the book in her possession and harnessing more power than ever, Siren aims to raise an army from the depths of the ocean’s trenches. It’s up to Wonder Woman, Batgirl and Supergirl to help Aquaman in defending Atlantis and stop the sinister Siren! Get ready for a thrilling adventure featuring the DC Super Hero Girls!", "EpisodeName":null, "DisplayTitle":"DC Super Hero Girls: Legends of Atlantis", "Genre":["Family", "Childrens"], "Copyright":"DC SUPER HERO GIRLS and all related characters and elements are trademarks of and © DC Comics. © 2018 Warner Bros. Entertainment Inc.", "CriticQuote":null, "AppleVendorIDs":[{"VID":"888574689261", "IsActive":"Yes"}], "IsVoid":null}], "IsVoid":null}]}]}}