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

0 vote171 views2 answers
How to see table associated with a schema in sql
SQL
1 vote158 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
48 votes246 views3 answers
Psql create database
SQL
0 vote150 views2 answers
Create row number in sql
SQL
0 vote145 views1 answer
C# datetime to sql server datetime
SQL
0 vote177 views1 answer
SQL SERVER xquery count child nodes
SQL
0 vote143 views1 answer
Order by monthly in sql
SQL
0 vote186 views1 answer
Oracle current date minus 1 day
SQL
14 votes172 views3 answers
Inner join sql oracle
SQL
0 vote150 views1 answer
Limit and offset in stored procedure mssql
SQL