This discussion is archived
1 Reply Latest reply: Jul 30, 2012 9:31 AM by alwu RSS

Getting data using triple.GET_OBJECT().

923096 Newbie
Currently Being Moderated
Hi,

I've created table and have done insert

INSERT INTO articles_rdf_data VALUES (3,
SDO_RDF_TRIPLE_S ('articles',
'http://nature.example.com/Article1',
'http://purl.org/dc/terms/references',
'http://nature.example.com/Article2'));

Now I want to get data using query something like that

SELECT a.* FROM articles_rdf_data a WHERE a.GET_OBJECT()='http://nature.example.com/Article2' (of course it doesn't work :)).

How to correct this query?
  • 1. Re: Getting data using triple.GET_OBJECT().
    alwu Pro
    Currently Being Moderated
    Hi,

    Can you please try this?

    SQL> list
    1 SELECT a.* FROM articles_rdf_data a WHERE a.triple.GET_OBJ_value()='<http://nature.example.com/Article2>'
    2*
    SQL> /

    3
    SDO_RDF_TRIPLE_S(7074365724528867041, 75, 7299961478807817799, 65221892748531436
    2, 7074365724528867041)

    Thanks,

    Zhe Wu

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points