How To DELETE Cascade When Working With RDF Data
(Doc ID 1085728.1)
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Spatial - Version: 184.108.40.206 to 220.127.116.11 - Release: 11.1 to 11.2
Information in this document applies to any platform.
Lets say we have Patient relationshiop to many Treatment_Plans and then plans relate to many Patient_Geometries
So we will have the RDF table with triples
John Smith has Treatment_plan1
John Smith has Treatment_plan2
John Smith has Treatment_plan3
Treatment_plan1 has Patient_Geometry1
Treatment_plan1 has Patient_Geometry2
Treatment_plan1 has Patient_Geometry3
Treatment_plan2 has Patient_Geometry1
Treatment_plan2 has Patient_Geometry2
Treatment_plan2 has Patient_Geometry3
The front end application will delete 'John Smith'
Is there an example of a trigger (server database side) that will go and remove all the related data, in this case the triples with subjects Treatment_plan1, Treatment_plan2 and Treatment_plan3? and also any triples that have Patient_Geometry1, Patient_Geometry2 and Patient_Geometry3 and so on?
Note: The children records do not have other relationship. In other words:
Treatment_plan1, Treatment_plan2 and Treatment_plan3 are related just to John Smith and no other Patient. Same as cascading children Patient_Geometry1 is related to just Treatment_plan1.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!