First, copy basic.sql into:

<VIRTUOSO_INSTALL>/bin/

Next, open Unix session or Windows Command Prompt and execute:

cd <OPENLINK_INSTALL>/bin

./isql     (Unix)
isql.exe   (Windows)

OpenLink Interactive SQL (Virtuoso), version 0.9849b.
Type HELP; for help and EXIT; to exit.
SQL>

Then, within isql execute:

SQL> load basic.sql;

Execution should finish with a simple SPARQL query that will return Linked Data for the test table created at the start of the script:

s                               p                                                  o
VARCHAR                         VARCHAR                                            VARCHAR
________________________________________________________________________________________________________________

http://example.com/product/1    http://example.com/product#id                      1
http://example.com/product/1    http://example.com/product#name                    Virtuoso
http://example.com/product/1    http://www.w3.org/1999/02/22-rdf-syntax-ns#type    http://example.com/ns#product
3 Rows. -- 0 msec.

We start by creating and populating the test table:

CREATE TABLE "R2RML"."TEST"."PRODUCT"
  (
    id   INTEGER PRIMARY KEY ,
    name VARCHAR(100)
  );

INSERT SOFT "R2RML"."TEST"."PRODUCT"
  VALUES
    (
      1, 'Virtuoso'
    );

Next we clear any graphs (temporary or permanent) that are to be used during this process:

SPARQL CLEAR GRAPH <http://temp/product> ;
SPARQL CLEAR GRAPH <http://example.com/> ;

Next we use the DB.DBA.TTLP() procedure to insert the R2RML into a temporary graph, <http://temp/product>:

DB.DBA.TTLP
  (
    ' @prefix       rr:  <http://www.w3.org/ns/r2rml#>    .
      @prefix      exa:  <http://example.com/ns#>         .
      @prefix  product:  <http://example.com/product#>    .

      <http://example.com/ns#TriplesMap1>
          a                              rr:TriplesMap  ;

          rr:logicalTable
            [
              rr:tableSchema  "R2RML"    ;
              rr:tableOwner   "TEST"     ;
              rr:tableName    "PRODUCT"
            ];

          rr:subjectMap
            [
              rr:template  "http://example.com/product/{id}" ;
              rr:class     exa:product                       ;
              rr:graph     <http://example.com/>
            ];

          rr:predicateObjectMap
            [
              rr:predicate  product:id  ;
              rr:objectMap
                [
                  rr:column  "id"
                ];
            ];

          rr:predicateObjectMap
            [
              rr:predicate  product:name  ;
              rr:objectMap
                [
                  rr:column "name"
                ];
            ];
         .
    ',
    'http://temp/product',
    'http://temp/product'
  );

Next, there is a series of commented out lines that can be used for sanity checking:

--SELECT DB.DBA.R2RML_TEST ('http://temp/product');

--DB.DBA.OVL_VALIDATE ('http://temp/product', 'http://www.w3.org/ns/r2rml#OVL');

-- Running the validation in order to find error in name of R2RML description graph
--DB.DBA.OVL_VALIDATE ('http://temp/product-nosuch', 'http://www.w3.org/ns/r2rml#OVL');

-- Running the validation in order to find error in name of R2RML metadata graph
--DB.DBA.OVL_VALIDATE ('http://temp/product', 'http://www.w3.org/ns/r2rml#OVL-nosuch');

--SELECT DB.DBA.R2RML_EXECUTE ('http://temp/product');

Next, DB.DBA.R2RML_MAKE_QM_FROM_G() is used to perform the conversion from R2RML into Virtuoso's own Linked Data Views script. The output is then prepended with the keyword 'SPARQL' and a space, and executed using exec() :

EXEC ('SPARQL ' || DB.DBA.R2RML_MAKE_QM_FROM_G ('http://temp/product'));

Note : The final triples are placed in the graph defined in the R2RML script itself (<http://example.com/>)

Alternatively, the destination graph can be specified as an optional second parameter of DB.DBA.R2RML_MAKE_QM_FROM_G():

DB.DBA.R2RML_MAKE_QM_FROM_G
  (
    (
      IN g VARCHAR
   [, IN target_graph VARCHAR := NULL]
    )
  )

Finally, a simple SPARQL statement is executed to prove data is returned:

SPARQL
  SELECT *
  FROM <http://example.com/>
  WHERE {?s ?p ?o .};