Virtuoso sql query tutorial

SQL> create function param_passing_demo ()
{
  declare stat, msg varchar;
  declare mdata, rset any;
  exec ('SPARQL SELECT ?s WHERE { graph ?g { ?s ?? ?? }}',
    stat, msg,
    vector ( /* Vector of two parameters */
      'http://www.w3.org/2001/sw/DataAccess/tests/data/Sorting/sort-0#int1',
      4 ),
    10, /* Max no of rows */
    mdata, /* Variable to get metadata */
    rset ); /* Variable to get result-set */
  if (length (rset) = 0)
    signal ('23000',
      'No data found, try demo database with installed Virtuoso tutorials');
  return rset[0][0];
}

SQL> SELECT param_passing_demo ();
callret
VARCHAR
_______________________________________________________________________________

http://www.w3.org/2001/sw/DataAccess/tests/data/Sorting/sort-0#four

1 Rows. -- 00000 msec.

Source: docs.openlinksw.com

Similar codes

2 votes120 views1 answer
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = whatsapp and table_name = migrations and table_type = 'BASE TABLE')
SQL
10 votes153 views4 answers
Sql server pagination
SQL
1 vote119 views1 answer
Show all event schedular on mysql
SQL
0 vote143 views1 answer
Mysql preg replace
SQL
0 vote118 views1 answer
Trigger value from maltiple table to single table mysql
SQL
1 vote139 views1 answer
Sql server if exists update else insert
SQL
3 votes122 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
0 vote117 views1 answer
Sql query wordpress export post
SQL
8 votes128 views3 answers
SQL column name
SQL
0 vote103 views1 answer
Faire une recherche par liste de mot clé sql
SQL