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

1 vote276 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote264 views1 answer
Mysql count grouped rows
SQL
2 votes262 views1 answer
Sql server check for value in multiple columns
SQL
1 vote246 views1 answer
Mysql average of multiple columns
SQL
0 vote251 views1 answer
Select row from mysql where date more than 30 days
SQL
0 vote254 views1 answer
Opensuse stop MySQL
SQL
21 votes265 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
8 votes281 views1 answer
My sql version
SQL
0 vote280 views1 answer
Excel export from sql using python
SQL
3 votes260 views1 answer
Sql set null
SQL