www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Overview
Installation Guide
Quick Start & Tours
Sample ODBC & JDBC Applications
Conceptual Overview
Administration
Data Access Interfaces
Virtual Database Engine
SQL Reference
Virtuoso Cluster Programming
SQL Procedure Language Guide
Database Event Hooks
Data Replication, Synchronization and Transformation Services
Web Application Development
XML Support
RDF Data Access and Data Management
Web Services
Runtime Hosting
Internet Services
Free Text Search
TPC C Benchmark Kit
Using Virtuoso with Tuxedo
Appendix
Virtuoso Functions Guide
AMI APIs
Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Geo Spatial
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Phrases
RDF data
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
VAD
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web & Internet
XML
XPATH & XQUERY
Functions Index

Abstract

The Virtuoso SQL Functions Guide contains reference manual entries for built-in SQL functions and procedures.

The Virtuoso XPATH & XQUERY Functions Guide contains reference manual entries of the built-in functions of the Virtuoso XPATH Processor. These can be used in XPATH, XSLT, XQuery.

Table of Contents

AMI APIs
DB.DBA.AMAZON_CREATE_IMAGE
DB.DBA.AMAZON_CREATE_SNAPSHOT
DB.DBA.AMAZON_CREATE_VOLUME
DB.DBA.AMAZON_DELETE_SNAPSHOT
DB.DBA.AMAZON_DELETE_VOLUME
DB.DBA.AMAZON_DEREGISTER_IMAGE
DB.DBA.AMAZON_DESCRIBE_IMAGES
DB.DBA.AMAZON_DESCRIBE_INSTANCES
DB.DBA.AMAZON_IMPORT_KEY_PAIR
DB.DBA.AMAZON_RUN_INSTANCE
DB.DBA.AMAZON_START_INSTANCE
DB.DBA.AMAZON_STOP_INSTANCE
DB.DBA.AMAZON_TERMINATE_INSTANCE
Administration
USER_CHANGE_PASSWORD
USER_CREATE
USER_DROP
USER_GET_OPTION
USER_GRANT_ROLE
USER_REVOKE_ROLE
USER_ROLE_CREATE
USER_ROLE_DROP
USER_SET_OPTION
USER_SET_QUALIFIER
cfg_item_count
cfg_item_name
cfg_item_value
cfg_section_count
cfg_section_name
cfg_write
checkpoint_interval
__dbf_set
disconnect_user
fk_check_input_values
key_estimate
log_enable
log_text
prof_enable
prof_sample
server_root
status
sys_lockdown
sys_stat
system
trace_status
uptime
user_set_password
DB.DBA.VACUUM
virtuoso_ini_path
Aggregate Functions
DB.DBA.BAG_AGG
DB.DBA.BAG_CONCAT_AGG
DB.DBA.BAG_OF_NONNULLS_AGG
DB.DBA.BAG_OF_NONNULLS_OR_NULL_AGG
DB.DBA.BAG_OR_NULL_AGG
DB.DBA.VECTOR_AGG
DB.DBA.VECTOR_CONCAT_AGG
DB.DBA.VECTOR_OF_NONNULLS_AGG
DB.DBA.VECTOR_OF_NONNULLS_OR_NULL_AGG
DB.DBA.VECTOR_OR_NULL_AGG
DB.DBA.XQ_SEQUENCE_AGG
CORR
COVAR_POP
COVAR_SAMP
REGR_AVGX
REGR_AVGY
REGR_COUNT
REGR_INTERCEPT
REGR_R2
REGR_SLOPE
REGR_SXX
REGR_SXY
REGR_SYY
STDDEV
STDDEV_POP
STDDEV_SAMP
VAR
VAR_POP
VAR_SAMP
Array Manipulation
aref
aset
concat
concatenate
dvector
get_keyword
get_keyword_ucase
gvector_digit_sort
gvector_sort
isarray
make_array
position
rowvector_digit_sort
serialize
split_and_decode
tree_md5
vector
vector_concat
BPEL APIs
BPEL.BPEL.compile_script
BPEL.BPEL.copy_script
BPEL.BPEL.get_partner_links
BPEL.BPEL.getVariableData
BPEL.BPEL.import_script
BPEL.BPEL.instance_delete
BPEL.BPEL.purge_instance
BPEL.BPEL.script_delete
BPEL.BPEL.script_obsolete
BPEL.BPEL.script_source_update
BPEL.BPEL.script_upload
BPEL.BPEL.setVariableData
BPEL.BPEL.wsdl_upload
BPEL.BPEL.plink_get_option
BPEL.BPEL.plink_set_option
Backup
backup
backup_context_clear
backup_online
replay
Compression
gz_compress
gz_uncompress
string_output_gz_compress
Cursor
bookmark
Date & Time Manipulation
curdate
dateadd
datediff
datestring, datestring_gmt,
datestring_GMT
dayname
dayofmonth
dayofweek
dayofyear
dt_set_tz
get_timestamp
getdate
hour
minute
month
monthname
msec_time
now
quarter
second
stringdate
stringtime
timezone
week
Debug
cov_load
cov_report
cov_store
dbg_obj_print
dbg_printf
explain
pldbg_stats
pldbg_stats_load
trace_off
trace_on
Dictionary Manipulation
dict_dec_or_remove
dict_destructive_list_rnd_keys
dict_duplicate
dict_get
dict_inc_or_put
dict_iter_next
dict_iter_rewind
dict_list_keys
dict_new
dict_put
dict_remove
dict_size
dict_to_vector
dict_zap
Encoding & Decoding
encode_base64
split_and_decode
uudecode
uuencode
File Manipulation
csv_cols_def
csv_load
csv_load_file
csv_parse
csv_table_def
file_delete
file_dirlist
file_mkdir
file_mkpath
file_open
file_stat
file_to_string
file_to_string_output
file_unlink
ft_set_file
get_csv_row
gz_file_open
os_chmod
os_chown
Free Text
composite
composite_ref
contains
vt_batch
vt_batch_d_id
vt_batch_feed
vt_batch_feed_offband
VT_BATCH_UPDATE
vt_create_text_index
VT_DROP_FTT
vt_is_noise
Geo Spatial
geo_delete
geo_insert
isgeometry
st_astext
st_contains
st_distance
st_geomfromtext
st_intersects
st_point
st_setsrid
st_srid
st_within
st_x
st_y
Hashing / Cryptographic
TOTP_generate
decrypt
dsig_template_ext
encrypt
md5
md5_final
md5_init
md5_update
sha1_digest
tree_md5
x509_certificate_verify
x509_csr_generate
x509_from_csr
xenc_SPKI_read
xenc_X509_certificate_serialize
xenc_bn2dec
xenc_decrypt_soap
xenc_delete_temp_keys
xenc_encrypt
xenc_get_key_algo
xenc_get_key_identifier
xenc_key_3DES_create
xenc_key_3DES_rand_create
xenc_key_3DES_read
xenc_key_AES_create
xenc_key_AES_rand_create
xenc_key_DSA_create
xenc_key_DSA_read
xenc_key_RSA_create
xenc_key_RSA_read
xenc_key_create_cert
xenc_key_exists
xenc_key_inst_create
xenc_key_remove
xenc_key_serialize
xenc_pem_export
xenc_pkcs12_export
xenc_set_primary_key
xenc_x509_generate
xenc_x509_ss_generate
LDAP
ldap_add
ldap_delete
ldap_modify
ldap_search
Locale
charset_define
charset_recode
charsets_list
current_charset
elh_get_handler
elh_load_handler
lh_get_handler
lh_load_handler
Mail
imap_get
mime_body
mime_part
mime_tree
nntp_auth_get
nntp_auth_post
nntp_get
nntp_post
pem_certificates_to_array
pop3_get
smime_decrypt
smime_encrypt
smime_sign
smime_verify
smtp_send
uuvalidate
Miscellaneous
HS_Resolve
Number
abs
trigonometric
atof
atoi
bit_and
bit_not
bit_or
bit_shift
bit_xor
ceiling
either
equ
exp
floor
isdouble
isfinitenumeric
isfloat
isinteger
isnumeric
iszero
log
log10
lower
mod
__max
__max_notnull
__min
__min_notnull
power
randomize
rnd
sign
sqrt
Phrases
DB.DBA.ANN_PHRASE_CLASS_ADD
DB.DBA.ANN_PHRASE_CLASS_DEL
AP_ADD_PHRASES
AP_BUILD_MATCH_LIST
RDF data
DB.DBA.GROUP_CONCAT
DB.DBA.GROUP_CONCAT_DISTINCT
DB.DBA.GROUP_DIGEST
DB.DBA.SAMPLE
__xml_get_ns_prefix
__xml_get_ns_uri
__xml_ns_iristr
__xml_ns_uname
__xml_nsexpand_iristr
http_nt_triple
http_ttl_triple
iri_split
IsRef
ld_dir
DB.DBA.RDF_64BIT_UPGRADE
DB.DBA.RDF_ALL_USER_PERMS_DEL
DB.DBA.RDF_AUDIT_METADATA
DB.DBA.RDF_BACKUP_METADATA
DB.DBA.RDF_CONVERT_RDFXML_TO_TTL
DB.DBA.RDF_DATATYPE_OF_OBJ
DB.DBA.RDF_DEFAULT_USER_PERMS_DEL
DB.DBA.RDF_DEFAULT_USER_PERMS_SET
DB.DBA.RDF_GEO_ADD
DB.DBA.RDF_GEO_FILL
DB.DBA.RDF_GRAPH_COLLECT_FP_LIST
DB.DBA.RDF_GRAPH_DIFF
DB.DBA.RDF_GRAPH_GROUP_CREATE
DB.DBA.RDF_GRAPH_GROUP_INS
DB.DBA.RDF_GRAPH_SECURITY_AUDIT
DB.DBA.RDF_GRAPH_USER_PERMS_DEL
DB.DBA.RDF_GRAPH_USER_PERMS_SET
DB.DBA.RDF_LANGMATCHES
DB.DBA.RDF_LOAD_RDFA
DB.DBA.RDF_LOAD_RDFXML
DB.DBA.RDF_LOAD_RDFXML_MT
DB.DBA.RDF_QUAD_URI
DB.DBA.RDF_QUAD_URI_L
DB.DBA.RDF_QUAD_URI_L_TYPED
DB.DBA.RDF_REGEX
DB.DBA.RDF_RESTORE_METADATA
DB.DBA.RDF_SUO_APPLY_PATCH
DB.DBA.RDF_SUO_DIFF_TTL
DB.DBA.RDF_TRIPLES_TO_RDF_XML_TEXT
DB.DBA.RDF_TRIPLES_TO_TTL
DB.DBA.RDF_TTL2HASH
RDF_VIEW_SYNC_TO_PHYSICAL
DB.DBA.RDF_VOID_STORE
rdfs_rule_set
DB.DBA.SPARQL_EVAL
DB.DBA.SPARQL_EVAL_TO_ARRAY
DB.DBA.SPARQL_RDB2RDF_CODEGEN
DB.DBA.SPARQL_RDB2RDF_LIST_TABLES
DB.DBA.SPARQL_REXEC
DB.DBA.SPARQL_REXEC_TO_ARRAY
DB.DBA.SPARQL_REXEC_WITH_META
DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS
sparql_to_sql_text
DB.DBA.TTLP
DB.DBA.TTLP_MT
DB.DBA.TTLP_MT_LOCAL_FILE
Remote SQL Data Source
att_local_name
quote_dotted
rclose
rexecute
rmoreresults
rnext
rstmtexec
sql_columns
sql_config_data_sources
sql_data_sources
sql_driver_connect
sql_get_installed_drivers
sql_get_private_profile_string
sql_gettypeinfo
sql_primary_keys
sql_procedures
sql_remove_dsn_from_ini
sql_special_columns
sql_statistics
sql_tables
sql_transact
sql_write_file_dsn
sql_write_private_profile_string
vd_remote_data_source
vd_remote_proc_wrapper
vd_remote_table
vd_statistics
vdd_disconnect_data_source
vdd_measure_rpc_time
Replication
REPL_ADD_CR
REPL_ADD_DAV_CR
REPL_ADD_SNAPSHOT_CR
REPL_CREATE_SNAPSHOT_PUB
REPL_CREATE_SNAPSHOT_SUB
REPL_DROP_SNAPSHOT_PUB
REPL_DROP_SNAPSHOT_SUB
REPL_INIT_SNAPSHOT
REPL_SERVER_NAME
REPL_SNP_SERVER
REPL_UPDATE_SNAPSHOT
RDF_REPL_GRAPH_DEL
RDF_REPL_GRAPH_INS
RDF_REPL_START
repl_disconnect
REPL_GRANT
REPL_INIT_COPY
repl_new_log
REPL_PUB_ADD
REPL_PUB_INIT_IMAGE
REPL_PUB_REMOVE
REPL_PUBLISH
repl_purge
REPL_REVOKE
REPL_SCHED_INIT
REPL_SERVER
repl_server_rename
REPL_STAT
repl_status
REPL_SUBSCRIBE
repl_sync
repl_sync_all
repl_text
repl_this_server
REPL_UNPUBLISH
REPL_UNSUBSCRIBE
sub_schedule
SOAP
http_body_read
soap_box_structure
soap_box_xml_entity
soap_call
soap_client
soap_current_url
soap_dt_define
soap_make_error
soap_print_box
soap_sdl
soap_server
soap_wsdl
soap_wsdl_import
wst_cli
SQL
__any_grants
collation_define
complete_table_name
delay
end_result
exec
close
exec_metadata
exec_next
exec_result
exec_result_names
exec_score
identity_value
name_part
registry_get
registry_get_all
registry_name_is_protected
registry_remove
registry_set
result
result_names
row_count
sequence_get_all
sequence_next
sequence_remove
sequence_set
set_identity_column
set_row_count
set_user_id
signal
sinv_create_inverse
sinv_create_key_mapping
sinv_drop_inverse
sys_stat_analyze
sys_stat_histogram
table_drop_policy
table_set_policy
username
String
ascii
blob_to_string
blob_to_string_output
chr
ends_with
initcap
isblob
isstring
lcase
left
length
locate
ltrim
make_string
regexp_instr
regexp_like
regexp_match
regexp_parse
regexp_replace
regexp_substr
repeat
replace
right
rtrim
search_excerpt
serialize
space
split_and_decode
sprintf
sprintf_inverse
sprintf_iri
sprintf_iri_or_null
sprintf_or_null
starts_with
strcasestr
strchr
strcontains
string_output
string_output_flush
string_output_gz_compress
string_output_string
string_to_file
strrchr
strstr
subseq
substring
tmp_file_name
trim
ucase
upper
Transaction
mts_connect
mts_get_timeout
mts_set_timeout
mts_status
txn_error
txn_killall
Type Mapping
import_jar
internal_to_sql_type
internal_type
internal_type_name
isarray
isbinary
isblob
isdouble
isentity
isfinitenumeric
isfloat
isinteger
isnull
isnumeric
isstring
iszero
jvm_ref_import
make_string
sign
stringdate
stringtime
udt_defines_field
udt_get
udt_implements_method
udt_instance_of
udt_set
unimport_jar
UDDI
uddi_delete_binding
uddi_delete_business
uddi_delete_service
uddi_delete_tModel
uddi_discard_authToken
uddi_find_binding
uddi_find_business
uddi_find_service
uddi_find_tModel
uddi_get_authToken
uddi_get_bindingDetail
uddi_get_businessDetail
uddi_get_businessDetailExt
uddi_get_registeredInfo
uddi_get_serviceDetail
uddi_get_tModelDetail
uddi_save_binding
uddi_save_business
uddi_save_service
uddi_save_tModel
User Defined Types & The CLR
import_clr
unimport_clr
VAD
VAD_CHECK
VAD_CHECK_INSTALLABILITY
VAD_CHECK_UNINSTALLABILITY
VAD_FAIL_CHECK
VAD_INSTALL
VAD_LOAD_FILE
VAD_LOAD_SQL_FILE
VAD_PACK
VAD_SAFE_EXEC
VAD_UNINSTALL
Virtuoso Java PL API
java_call_method
java_get_property
java_load_class
java_new_object
java_set_property
java_vm_attach
java_vm_detach
Virtuoso Server Extension Interface (VSEI)
Virtuoso Server Extension Interface (VSEI) functions
Web & Internet
USER_KEY_LOAD
client_attr
connection_get
connection_id
connection_is_dirty
connection_set
connection_vars
connection_vars_set
DAV add & update functions
DAV manipulation functions
DAV lock manipulation functions
DAV search functions
WebDAV Users & Groups administration
DAV_EXP
dbname
dns_txt_get
ftp_get
ftp_ls
ftp_put
get_certificate_info
get_keyword
get_keyword_ucase
http
http_acl_get
http_acl_remove
http_acl_set
http_body_read
http_client
http_client_ext
http_client_ip
http_debug_log
http_enable_gz
http_file
http_flush
http_get
http_header
http_header_get
http_internal_redirect
http_kill
http_listen_host
http_lock
http_map_get
http_map_table
http_param
http_path
http_pending_req
http_physical_path
http_proxy
http_request_get
http_request_header
http_request_header_full
http_request_status
http_rewrite
http_root
http_unlock
http_url
http_value
http_xslt
json_parse
LFS_EXP
SERV_QUEUE_TOP
ses_connect
ses_disconnect
ses_read_line
ses_write
tcpip_gethostbyaddr
tcpip_gethostbyname
URLREWRITE_CREATE_REGEX_RULE
VHOST_DEFINE
VHOST_REMOVE
vsp_calculate_digest
wsdl_import_udt
XML
XMLAGG
XMLATTRIBUTES
XMLAddAttribute
XMLAppendChildren
XMLCONCAT
XMLELEMENT
XMLFOREST
XMLInsertAfter
XMLInsertBefore
XMLReplace
XMLType.XMLType
XMLType.createNonSchemaBasedXML
XMLType.createSchemaBasedXML
XMLType.createXML
XMLType.existsNode
XMLType.extract
XMLType.getClobVal
XMLType.getNamespace
XMLType.getNumVal
XMLType.getRootElement
XMLType.getSchemaURL
XMLType.getStringVal
XMLType.isFragment
XMLType.isSchemaBased
XMLType.isSchemaValid
XMLType.isSchemaValidated
XMLType.schemaValidate
XMLType.setSchemaValidated
XMLType.toObject
XMLType.transform
XMLUpdate
createXML
isentity
serialize_to_UTF8_xml
tidy_html
tidy_list_errors
updateXML
xml_add_system_path
xml_auto
xml_auto_dtd
xml_auto_schema
xml_create_tables_from_mapping_schema_decl
xml_cut
xml_doc_output_option
xml_get_system_paths
xml_load_mapping_schema_decl
xml_load_schema_decl
xml_namespace_scope
xml_persistent
xml_set_ns_decl
xml_template
xml_tree
xml_tree_doc
xml_tree_doc_media_type
xml_uri_get
xml_validate_dtd
xml_validate_schema
xml_view_dtd
xml_view_schema
xmlsql_update
xpath_eval
xper_cut
xper_doc
xper_locate_words
XPER navigation
xpf_extension
xpf_extension_remove
xquery_eval
xslt
xslt_format_number
xslt_sheet
xslt_stale
xte_head
xte_node
xte_node_from_nodebld
xte_nodebld_acc
xte_nodebld_final
xte_nodebld_init
xtree_doc
XPATH & XQUERY
and
append
assign
avg
boolean
ceiling
fn:collection
concat
contains
count
create-attribute
create-comment
create-element
create-pi
current
distinct
doc
document
document-literal
empty
ends-with
every
except
false
filter
floor
for
format-number
function-available
generate-id
id
if
intersect
is_after()
is_before()
key
lang
last
let
list()
local-name
max
min
name
namespace-uri
normalize-space
not
number
or
position
processXQuery
processXSLT
processXSQL
progn()
replace()
round
serialize
shallow
some
starts-with
string
string-length
substring
substring-after
substring-before
sum
system-property
text_contains()
translate
true
tuple()
union
unordered
unparsed-entity-uri
urlify
xmlview