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 ()