1 Reply Latest reply on Mar 5, 2014 8:25 PM by alwu-Oracle

    ID in Triple Insert Statement

    HansC

      The example in the developer manual shows the insert statement needs to give ID, such as 1 as below, my questions is how do we maintain that ID unique? For first time insert, maybe I can control all the inserts using ID in order and unique, but with data adding and removing, it is hard to find an ID unique in the insert statement if it happens later on. Should that unique ID number be maintained internally in oracle instead of given every time externally?

       

      INSERT INTO articles_rdf_data VALUES (1,

      SDO_RDF_TRIPLE_S ('articles','http://nature.example.com/Article1',

      'http://purl.org/dc/elements/1.1/title','All about XYZ'));

       

      Thanks.