Links between the ID's field, the options' fields and SDO_RDF_TRIPLE_S
544160Nov 6 2006 — edited Nov 9 2006Hi,
I'm going to try to create an Database.
For example :
With this table :
CREATE OR REPLACE TABLE testTable
(id NUMBER PRIMARY KEY,
triple SDO_RDF_TRIPLE_S,
id_visibility NUMBER NOT NULL,
constraint id_testTable_pk PRIMARY KEY (id),
constraint id_visibility_fk foreign key (id_visibility) references visibility (id)
)
Now, is it possible in the 10g release 2 ? is it the best solution ? to do that :
SELECT z, z$RDFVTYP, z$RDFLTYP
FROM visibility t1,
TABLE (SDO_RDF_MATCH('(?z ?y <http://www.example.org/family/Matt>)',
SDO_RDF_Models('familly'),
null,
'id_visibility = t1.ID ',
null
)) t2
WHERE t1.Description LIKE 'public'
And so that ?
DELETE FROM testTable s
WHERE s.triple.RDF_T_ID IN (
SELECT SDO_RDF.GET_TRIPLE_ID
( 'familly', z, y, 'http://www.example.org/family/Matt')
FROM visibility t1, TABLE
(SDO_RDF_MATCH('(?z ?y <http://www.example.org/family/Matt>)',
SDO_RDF_Models('familly'),
null,
'id_visibility = t1.ID ',
null
)) t2
WHERE t1.Description LIKE 'public'
)
Thanks
K