My Oracle Support Banner

How To DELETE Cascade When Working With RDF Data (Doc ID 1085728.1)

Last updated on DECEMBER 26, 2019

Applies to:

Oracle Spatial and Graph - Version to [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!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.