Chapter 24. Virtuoso Functions Guide & Reference
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
- cfg_item_count ()
- cfg_item_name ()
- cfg_item_value ()
- cfg_section_count ()
- cfg_section_name ()
- cfg_write ()
- checkpoint_interval ()
- DB.DBA.VACUUM ()
- disconnect_user ()
- fk_check_input_values ()
- log_enable ()
- log_text ()
- read_log ()
- __dbf_set ()
- stat_import ()
- stat_export ()
- prof_enable ()
- prof_sample ()
- status ()
- key_estimate ()
- system ()
- uptime ()
- sys_lockdown ()
- sys_stat ()
- trace_status ()
- USER_CHANGE_PASSWORD ()
- USER_CREATE ()
- USER_DROP ()
- USER_GET_OPTION ()
- USER_GRANT_ROLE ()
- USER_REVOKE_ROLE ()
- USER_ROLE_CREATE ()
- USER_ROLE_DROP ()
- USER_SET_QUALIFIER ()
- USER_SET_OPTION ()
- user_set_password ()
- USER_KEY_STORE ()
- virtuoso_ini_path ()
- server_root ()
- VAR ()
- VAR_SAMP ()
- VAR_POP ()
- STDDEV ()
- STDDEV_SAMP ()
- STDDEV_POP ()
- REGR_SYY ()
- REGR_SXX ()
- REGR_SXY ()
- REGR_AVGX ()
- REGR_AVGY ()
- REGR_R2 ()
- REGR_COUNT ()
- REGR_INTERCEPT ()
- REGR_SLOPE ()
- COVAR_SAMP ()
- COVAR_POP ()
- CORR ()
- DB.DBA.XQ_SEQUENCE_AGG ()
- DB.DBA.VECTOR_AGG ()
- DB.DBA.VECTOR_OF_NONNULLS_AGG ()
- DB.DBA.VECTOR_OR_NULL_AGG ()
- DB.DBA.VECTOR_OF_NONNULLS_OR_NULL_AGG ()
- DB.DBA.VECTOR_CONCAT_AGG ()
- DB.DBA.BAG_AGG ()
- DB.DBA.BAG_OF_NONNULLS_AGG ()
- DB.DBA.BAG_OR_NULL_AGG ()
- DB.DBA.BAG_OF_NONNULLS_OR_NULL_AGG ()
- DB.DBA.BAG_CONCAT_AGG ()
- DB.DBA.AMAZON_START_INSTANCE ()
- DB.DBA.AMAZON_RUN_INSTANCE ()
- DB.DBA.AMAZON_STOP_INSTANCE ()
- DB.DBA.AMAZON_TERMINATE_INSTANCE ()
- DB.DBA.AMAZON_CREATE_VOLUME ()
- DB.DBA.AMAZON_DEREGISTER_IMAGE ()
- DB.DBA.AMAZON_CREATE_IMAGE ()
- DB.DBA.AMAZON_CREATE_SNAPSHOT ()
- DB.DBA.AMAZON_DELETE_SNAPSHOT ()
- DB.DBA.AMAZON_DELETE_VOLUME ()
- DB.DBA.AMAZON_DESCRIBE_IMAGES ()
- DB.DBA.AMAZON_DESCRIBE_INSTANCES ()
- DB.DBA.AMAZON_IMPORT_KEY_PAIR ()
- aref ()
- aset ()
- concat ()
- concatenate ()
- dvector ()
- get_keyword ()
- get_keyword_ucase ()
- gvector_sort ()
- gvector_digit_sort ()
- isarray ()
- make_array ()
- position ()
- rowvector_digit_sort ()
- vector ()
- vector_concat ()
- backup ()
- backup_online ()
- backup_context_clear ()
- replay ()
- BPEL.BPEL.compile_script ()
- BPEL.BPEL.copy_script ()
- BPEL.BPEL.get_partner_links ()
- 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.wsdl_upload ()
- BPEL.BPEL.getVariableData ()
- BPEL.BPEL.setVariableData ()
- BPEL.BPEL.plink_get_option ()
- BPEL.BPEL.plink_set_option ()
- BPEL.BPEL.import_script ()
- bookmark ()
- curdate ()
- forget_timezone ()
- is_timezoneless ()
- adjust_timezone ()
- rdf_now_impl ()
- current_timestamp ()
- curdatetime ()
- curdatetimeoffset ()
- curutcdatetime ()
- sysutcdatetime ()
- dateadd ()
- datediff ()
- datestring , datestring_gmt , ()
- datestring_GMT ()
- dayname ()
- dt_set_tz ()
- get_timestamp ()
- getdate ()
- msec_time ()
- now ()
- stringdate ()
- stringtime ()
- cov_load ()
- cov_report ()
- cov_store ()
- dbg_obj_print ()
- dbg_printf ()
- explain ()
- log_message ()
- pldbg_stats ()
- pldbg_stats_load ()
- trace_off ()
- trace_on ()
- dict_dec_or_remove ()
- dict_duplicate ()
- dict_get ()
- dict_inc_or_put ()
- dict_iter_next ()
- dict_iter_rewind ()
- dict_list_keys ()
- dict_destructive_list_rnd_keys ()
- dict_new ()
- dict_put ()
- dict_remove ()
- dict_size ()
- dict_to_vector ()
- dict_zap ()
- encode_base64 ()
- split_and_decode ()
- uudecode ()
- uuencode ()
- file_delete ()
- file_open ()
- ft_set_file ()
- file_dirlist ()
- file_mkdir ()
- file_mkpath ()
- file_stat ()
- file_to_string ()
- file_to_string_output ()
- file_unlink ()
- gz_file_open ()
- get_csv_row ()
- csv_load_file ()
- attach_from_csv ()
- csv_load ()
- csv_parse ()
- csv_cols_def ()
- csv_table_def ()
- os_chmod ()
- os_chown ()
- 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 ()
- md5 ()
- md5_init ()
- md5_update ()
- md5_final ()
- sha1_digest ()
- tree_md5 ()
- dsig_template_ext ()
- x509_certificate_verify ()
- xenc_X509_certificate_serialize ()
- xenc_decrypt_soap ()
- xenc_delete_temp_keys ()
- xenc_encrypt ()
- encrypt ()
- decrypt ()
- TOTP_generate ()
- xenc_get_key_algo ()
- xenc_get_key_identifier ()
- xenc_key_3DES_read ()
- xenc_key_3DES_create ()
- xenc_key_3DES_rand_create ()
- xenc_key_DSA_read ()
- xenc_key_RSA_read ()
- xenc_key_AES_create ()
- xenc_key_AES_rand_create ()
- xenc_key_create_cert ()
- xenc_key_DSA_create ()
- xenc_key_exists ()
- xenc_key_inst_create ()
- xenc_key_remove ()
- xenc_key_serialize ()
- xenc_set_primary_key ()
- xenc_x509_ss_generate ()
- xenc_x509_generate ()
- xenc_pkcs12_export ()
- xenc_pem_export ()
- xenc_SPKI_read ()
- xenc_bn2dec ()
- xenc_key_RSA_create ()
- xenc_x509_csr_generate ()
- xenc_x509_from_csr ()
- java_call_method ()
- java_set_property ()
- java_get_property ()
- java_load_class ()
- java_new_object ()
- java_vm_attach ()
- java_vm_detach ()
- ldap_search ()
- ldap_delete ()
- ldap_add ()
- ldap_modify ()
- charset_define ()
- charset_recode ()
- charsets_list ()
- current_charset ()
- elh_get_handler ()
- elh_load_handler ()
- lh_get_handler ()
- lh_load_handler ()
- mime_body ()
- mime_part ()
- mime_tree ()
- nntp_auth_get ()
- nntp_auth_post ()
- nntp_get ()
- nntp_post ()
- pem_certificates_to_array ()
- pop3_get ()
- imap_get ()
- smime_sign ()
- smime_verify ()
- smime_encrypt ()
- smime_decrypt ()
- smtp_send ()
- uuvalidate ()
- abs ()
- atof ()
- atoi ()
- bit_and ()
- bit_or ()
- bit_not ()
- bit_shift ()
- bit_xor ()
- ceiling ()
- either ()
- equ ()
- exp ()
- floor ()
- isdouble ()
- __min ()
- __max ()
- __max_notnull ()
- __min_notnull ()
- log ()
- log10 ()
- lower ()
- mod ()
- power ()
- randomize ()
- rnd ()
- sqrt ()
- trigonometric ()
- DB.DBA.ANN_PHRASE_CLASS_ADD ()
- DB.DBA.ANN_PHRASE_CLASS_DEL ()
- AP_BUILD_MATCH_LIST ()
- AP_ADD_PHRASES ()
- repl_disconnect ()
- REPL_GRANT ()
- REPL_INIT_COPY ()
- repl_new_log ()
- REPL_PUBLISH ()
- REPL_PUB_ADD ()
- REPL_PUB_INIT_IMAGE ()
- REPL_PUB_REMOVE ()
- 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 ()
- repl_purge ()
- REPL_CREATE_SNAPSHOT_PUB ()
- REPL_CREATE_SNAPSHOT_SUB ()
- REPL_DROP_SNAPSHOT_SUB ()
- REPL_DROP_SNAPSHOT_PUB ()
- REPL_INIT_SNAPSHOT ()
- REPL_UPDATE_SNAPSHOT ()
- REPL_SNP_SERVER ()
- REPL_SERVER_NAME ()
- REPL_ADD_CR ()
- REPL_ADD_DAV_CR ()
- REPL_ADD_SNAPSHOT_CR ()
- RDF_REPL_START ()
- RDF_REPL_STOP ()
- RDF_REPL_SYNC ()
- RDF_REPL_GRAPH_INS ()
- RDF_REPL_GRAPH_DEL ()
- sub_schedule ()
- att_local_name ()
- quote_dotted ()
- rclose ()
- rexecute ()
- rstmtexec ()
- rmoreresults ()
- rnext ()
- sql_columns ()
- sql_data_sources ()
- sql_gettypeinfo ()
- sql_primary_keys ()
- sql_statistics ()
- sql_tables ()
- sql_special_columns ()
- sql_procedures ()
- sql_write_private_profile_string ()
- sql_get_private_profile_string ()
- sql_config_data_sources ()
- sql_get_installed_drivers ()
- sql_remove_dsn_from_ini ()
- sql_transact ()
- sql_write_file_dsn ()
- sql_driver_connect ()
- vd_remote_data_source ()
- vd_remote_proc_wrapper ()
- vd_remote_table ()
- vd_statistics ()
- vdd_disconnect_data_source ()
- vdd_measure_rpc_time ()
- sparql_to_sql_text ()
- DB.DBA.RDF_AUDIT_METADATA ()
- DB.DBA.RDF_GRAPH_SECURITY_AUDIT ()
- DB.DBA.RDF_DEFAULT_USER_PERMS_SET ()
- DB.DBA.RDF_DEFAULT_USER_PERMS_DEL ()
- DB.DBA.RDF_BACKUP_METADATA ()
- DB.DBA.RDF_VOID_STORE ()
- rdf_load_stop ()
- rdf_loader_run ()
- ld_dir_all ()
- DB.DBA.RDF_RESTORE_METADATA ()
- DB.DBA.RDF_LOAD_RDFXML_MT ()
- DB.DBA.RDF_LOAD_RDFXML ()
- DB.DBA.RDF_LOAD_RDFA ()
- ld_dir ()
- DB.DBA.TTLP ()
- DB.DBA.TTLP_MT ()
- DB.DBA.TTLP_MT_LOCAL_FILE ()
- DB.DBA.RDF_DATATYPE_OF_OBJ ()
- DB.DBA.RDF_TRIPLES_TO_RDF_XML_TEXT ()
- DB.DBA.RDF_TRIPLES_TO_TTL ()
- DB.DBA.RDF_64BIT_UPGRADE ()
- RDF_VIEW_SYNC_TO_PHYSICAL ()
- DB.DBA.RDF_CONVERT_RDFXML_TO_TTL ()
- DB.DBA.RDF_GRAPH_GROUP_CREATE ()
- DB.DBA.RDF_GRAPH_GROUP_INS ()
- DB.DBA.RDF_GRAPH_USER_PERMS_SET ()
- DB.DBA.RDF_GRAPH_USER_PERMS_GET ()
- DB.DBA.RDF_GRAPH_USER_PERMS_DEL ()
- DB.DBA.RDF_ALL_USER_PERMS_DEL ()
- rdfs_rule_set ()
- DB.DBA.RDF_GEO_FILL ()
- DB.DBA.RDF_GEO_ADD ()
- DB.DBA.RDF_GRAPH_COLLECT_FP_LIST ()
- DB.DBA.RDF_GRAPH_DIFF ()
- DB.DBA.RDF_SUO_APPLY_PATCH ()
- DB.DBA.RDF_SUO_DIFF_TTL ()
- DB.DBA.SPARQL_RDB2RDF_CODEGEN ()
- DB.DBA.SPARQL_RDB2RDF_LIST_TABLES ()
- DB.DBA.SPARQL_SELECT_KNOWN_GRAPHS ()
- IsRef ()
- DB.DBA.SAMPLE ()
- DB.DBA.GROUP_CONCAT ()
- DB.DBA.GROUP_CONCAT_DISTINCT ()
- DB.DBA.GROUP_DIGEST ()
- http_nt_triple ()
- http_ttl_triple ()
- iri_split ()
- __xml_get_ns_prefix ()
- __xml_get_ns_uri ()
- __xml_ns_uname ()
- __xml_ns_iristr ()
- __xml_nsexpand_iristr ()
- DB.DBA.SPARQL_EVAL ()
- DB.DBA.SPARQL_EVAL_TO_ARRAY ()
- DB.DBA.SPARQL_REXEC ()
- DB.DBA.SPARQL_REXEC_TO_ARRAY ()
- DB.DBA.SPARQL_REXEC_WITH_META ()
- DB.DBA.RDF_REGEX ()
- DB.DBA.RDF_LANGMATCHES ()
- DB.DBA.RDF_TTL2HASH ()
- DB.DBA.RDF_QUAD_URI ()
- DB.DBA.RDF_QUAD_URI_L ()
- DB.DBA.RDF_QUAD_URI_L_TYPED ()
- http_body_read ()
- soap_box_xml_entity ()
- soap_dt_define ()
- soap_call ()
- soap_client ()
- soap_make_error ()
- soap_print_box ()
- soap_sdl ()
- soap_server ()
- soap_wsdl ()
- soap_wsdl_import ()
- soap_box_structure ()
- soap_current_url ()
- wst_cli ()
- __any_grants ()
- collation_define ()
- complete_table_name ()
- delay ()
- cl_exec ()
- end_result ()
- exec ()
- close ()
- exec_next ()
- exec_result ()
- exec_result_names ()
- exec_metadata ()
- exec_score ()
- identity_value ()
- name_part ()
- registry_get ()
- registry_get_all ()
- registry_name_is_protected ()
- registry_set ()
- registry_remove ()
- result ()
- result_names ()
- row_count ()
- sequence_get_all ()
- sequence_next ()
- sequence_remove ()
- sequence_set ()
- set_row_count ()
- set_user_id ()
- set_identity_column ()
- signal ()
- sinv_create_key_mapping ()
- sinv_create_inverse ()
- sinv_drop_inverse ()
- sys_stat_analyze ()
- sys_stat_histogram ()
- table_set_policy ()
- table_drop_policy ()
- username ()
- ascii ()
- blob_to_string ()
- blob_to_string_output ()
- chr ()
- initcap ()
- isblob ()
- lcase ()
- left ()
- length ()
- locate ()
- ltrim ()
- make_string ()
- regexp_match ()
- regexp_parse ()
- regexp_substr ()
- regexp_replace ()
- regexp_instr ()
- regexp_like ()
- repeat ()
- replace ()
- right ()
- rtrim ()
- search_excerpt ()
- serialize ()
- space ()
- sprintf ()
- sprintf_inverse ()
- sprintf_iri ()
- sprintf_iri_or_null ()
- sprintf_or_null ()
- strcasestr ()
- strchr ()
- string_output ()
- string_output_flush ()
- string_output_string ()
- string_to_file ()
- strrchr ()
- strstr ()
- subseq ()
- substring ()
- strcontains ()
- starts_with ()
- ends_with ()
- tmp_file_name ()
- trim ()
- ucase ()
- upper ()
- mts_connect ()
- mts_get_timeout ()
- mts_set_timeout ()
- mts_status ()
- txn_error ()
- txn_killall ()
- import_jar ()
- internal_to_sql_type ()
- internal_type ()
- internal_type_name ()
- isbinary ()
- isentity ()
- isfloat ()
- isinteger ()
- isnull ()
- isnumeric ()
- isfinitenumeric ()
- isstring ()
- iszero ()
- jvm_ref_import ()
- sign ()
- udt_defines_field ()
- udt_get ()
- udt_implements_method ()
- udt_instance_of ()
- udt_set ()
- unimport_jar ()
- 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 ()
- import_clr ()
- unimport_clr ()
- 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 ()
- ftp_get ()
- ftp_ls ()
- ftp_put ()
- get_certificate_info ()
- http ()
- http_lock ()
- http_unlock ()
- http_acl_set ()
- http_acl_get ()
- http_acl_remove ()
- http_client ()
- http_client_ext ()
- http_client_ip ()
- dns_txt_get ()
- http_debug_log ()
- http_enable_gz ()
- http_file ()
- http_flush ()
- http_internal_redirect ()
- http_get ()
- http_header ()
- http_header_get ()
- http_kill ()
- http_listen_host ()
- http_map_table ()
- http_map_get ()
- http_param ()
- http_path ()
- http_pending_req ()
- http_physical_path ()
- http_proxy ()
- http_request_header ()
- http_request_header_full ()
- http_request_status ()
- http_request_get ()
- http_rewrite ()
- http_root ()
- http_value ()
- json_parse ()
- http_url ()
- http_xslt ()
- URLREWRITE_CREATE_REGEX_RULE ()
- LFS_EXP ()
- SERV_QUEUE_TOP ()
- ses_connect ()
- ses_disconnect ()
- ses_read_line ()
- ses_write ()
- tcpip_gethostbyname ()
- tcpip_gethostbyaddr ()
- VHOST_DEFINE ()
- VHOST_REMOVE ()
- vsp_calculate_digest ()
- wsdl_import_udt ()
- USER_KEY_LOAD ()
- createXML ()
- serialize_to_UTF8_xml ()
- tidy_html ()
- tidy_list_errors ()
- updateXML ()
- xte_head ()
- xte_node ()
- xte_node_from_nodebld ()
- xte_nodebld_acc ()
- xte_nodebld_final ()
- xte_nodebld_init ()
- XMLAGG ()
- XMLATTRIBUTES ()
- XMLAddAttribute ()
- XMLAppendChildren ()
- XMLCONCAT ()
- XMLELEMENT ()
- XMLFOREST ()
- XMLInsertAfter ()
- XMLInsertBefore ()
- XMLReplace ()
- xml_auto ()
- xml_auto_dtd ()
- xml_auto_schema ()
- xml_create_tables_from_mapping_schema_decl ()
- xml_cut ()
- xml_doc_output_option ()
- xml_load_schema_decl ()
- xml_load_mapping_schema_decl ()
- xml_namespace_scope ()
- xml_add_system_path ()
- xml_get_system_paths ()
- xml_persistent ()
- 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_set_ns_decl ()
- xml_view_schema ()
- xmlsql_update ()
- XMLUpdate ()
- 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 ()
- xtree_doc ()
- 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 ()
- HS_Resolve ()
- ST_Affine ()
- st_point ()
- st_x ()
- st_y ()
- st_distance ()
- ST_SRID ()
- ST_SetSRID ()
- st_astext ()
- st_geomfromtext ()
- st_intersects ()
- st_contains ()
- st_within ()
- isgeometry ()
- geo_insert ()
- geo_delete ()
- GeometryType ()
- http_st_dxf_entity ()
- http_st_ewkt ()
- st_ewkt_read ()
- postgis_proj_version ()
- dist_from_point_to_line_segment ()
- earth_radius ()
- ST_ExteriorRing ()
- ST_GeometryN ()
- st_get_bounding_box ()
- st_get_bounding_box_n ()
- haversine_deg_km ()
- ST_InteriorRingN ()
- st_linestring ()
- ST_M ()
- st_may_intersect ()
- ST_MMax ()
- ST_MMin ()
- ST_NumGeometries ()
- ST_NumInteriorRings ()
- ST_Transform ()
- st_transform_by_custom_projection ()
- ST_Translate ()
- ST_TransScale ()
- ST_XMax ()
- ST_XMin ()
- ST_YMax ()
- ST_YMin ()
- ST_Z ()
- ST_ZMax ()
- ST_Zmflag ()
- ST_ZMin ()
- 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 ()