Virtuoso Open-Source Edition

  • Topic
  • Discussion
  • SPARQL/SPARUL/SPARQL-BI Operations Guide for Executing Queries Combined in Single or Multiple Statements

    The following guide presents various operations lists depending on either is allowed multiple or single execution of the statements.

    Items that could be listed one after other with and without semicolon

    Example

    DELETE from <http://semantica.globo.com/tvg/> { 
    <http://semantica.globo.com/tvg/programa/11> ?p ?o . 
    } 
    WHERE { 
    <http://semantica.globo.com/tvg/programa/11> ?p ?o . 
    }  
    
    INSERT DATA INTO <http://semantica.globo.com/tvg/> { 
    <http://semantica.globo.com/tvg/programa/11>
    <http://semantica.globo.com/tvg/cor_hover_tvg> "#d39016" . 
    } 
    

    Items that could not be combined with others

    Single Quad Map Configuration Operator

    A single quad map configuration operator can consist of many parts separated by dots:

    Example

    CREATE IRI CLASS oplsioc:grantee_iri using
      function DB.DBA.GRANTEE_URI (in id integer)
        returns varchar,
      function DB.DBA.GRANTEE_URI_INVERSE (in id_iri varchar)
        returns integer .
    
    CREATE IRI CLASS oplsioc:user_iri "http://myhost/sys/user?id=%d"
      (in uid integer not null) .
      
    CREATE LITERAL CLASS example:isbn_ref "%s" (in isbn varchar not null)
      option ( bijection, returns "%u-%u-%u-%u" union "%u-%u-%u-X" )
      
    MAKE oplsioc:user_iri SUBCLASS OF oplsioc:grantee_iri .    
    
    ALTER QUAD STORAGE virtrdf:DefaultQuadStorage
      :
      FROM isports_rdf.prs10_isports_rdf.VRef_Call      as Ref_Call_tbl
      FROM isports_rdf.prs10_isports_rdf.VRef_Call      as Ref_Call_tbl_1
      :
    {
      :
      refcall:ref-call_iri (Ref_Call_tbl.Call_Num) a refcall:Ref-Call as
    virtrdf:ref-call_pk ;
      :
      refcall:has_parent  refcall:ref-call_iri (Ref_Call_tbl_1.Call_Num)
    where  ( ^{Ref_Call_tbl.}^.Parent    = ^{Ref_Call_tbl_1.}^.Call_Num )   as
    virtrdf:Ref-Call_has_parent .
    
    

    Related