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 votes203 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
0 vote188 views1 answer
Mod in sql
SQL
12 votes228 views4 answers
How to drop all tables in postgresql
SQL
0 vote193 views1 answer
Oracle search columns in schema
SQL
18 votes172 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
SQL
0 vote194 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
2 votes211 views2 answers
Sql lag
SQL
0 vote197 views1 answer
Authentication in sql server
SQL
0 vote231 views2 answers
How to get max from each department in sql
SQL
0 vote192 views1 answer
Select from another database
SQL