1 Ответить Последний ответ: 30.07.2012 16:31, автор: alwu-Oracle

    Getting data using triple.GET_OBJECT().

    923096
      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-Oracle
          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
          1 пользователь считает эту информацию полезной