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 vote252 views1 answer
Pl sql drop trigger
SQL
0 vote201 views1 answer
Drop table BigQuery table columns
SQL
1 vote181 views1 answer
Expression number 1 of select list is not in group by clause
SQL
1 vote224 views1 answer
Sql sort column by date
SQL
2 votes186 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
8 votes222 views2 answers
Sqlsrv default port
SQL
1 vote191 views1 answer
Sql into vs insert into
SQL
3 votes181 views2 answers
Mysql HAVING
SQL
0 vote236 views1 answer
Postgres foreign key multiple columns
SQL
0 vote183 views1 answer
Oracle current timestamp insert statement
SQL