Oracle级联删除

    <!-- 根据关系删除附件信息表 -->
    <delete id="deleteAttachByRelation" parameterClass="com.nstc.aims.model.scope.AttachRelationScope">
        DELETE G_ATTACH A WHERE 1 = 1
		AND EXISTS (
		       SELECT 1 FROM G_ATTACH_RELATION T 
		       WHERE T.ATTACH_ID = A.ATTACH_ID 
               <include refid="queryAttachRelationScopeSQL" />
		)
    </delete>
    
    <!-- 删除附件关联关系表 -->
    <delete id="deleteAttachRelation" parameterClass="com.nstc.aims.model.scope.AttachRelationScope">
        DELETE G_ATTACH_RELATION T WHERE 1 = 1
        <include refid="queryAttachRelationScopeSQL" />
    </delete>   

其中Attach和Attach_relation是一个多对1 的关系。