How To DELETE Cascade When Working With RDF Data
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Spatial - Version: 18.104.22.168 to 22.214.171.124 - 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms