Missing tables and procedures

All Missing tables and procedures extensions are similar. They take as input SQL queries embedded in client code and generate as output Missing Schemas, Missing SQL Tables and Missing SQL Procedures.

From a technical standpoint, SQL queries embedded in client code object types inherit from the metamodel category CAST_SQL_MetricableQuery, generally with icons that look like: .

You can also retrieve the full list of SQL queries embedded in client code from the analysis schema with the following SQL statement:

select o.KeyNam QueryName, od.InfVal SQLQuery
from ObjDsc od join Keys o on od.IdObj = o.IdKey
     join TypCat tc on tc.IdTyp = o.ObjTyp
where tc.IdCatParent = 139018 -- CAST_SQL_MetricableQuery
      and od.InfTyp = 150 -- sqlQuery property InfTyp = 150, InfSubTyp = 15
      and od.InfSubTyp = 15

For Oracle Forms and Reports analysis, we also add missing tables and procedures for the following object : Oracle Forms Trigger, Oracle Forms DataBlock, Oracle Forms DataBlock Item, Oracle Forms Procedure, Oracle Forms Function, Oracle Forms Menu, Oracle Forms Menu Item, Oracle Forms Windows.

System Objects

Refers to system databases, schemas and also system tables.

Context

System objects are specific to the database vendor. Sometimes they are stored in a specific database(s), otherwise in specific schema(s). SQL Analyzer exclude them from metric calculations, and consider them as external, please find more details:here.

Missing table and procedure extensions are doing the same. In the same application you can have multiple vendors so the list of the system objects are common to all vendors. There is a common list of the built-in objects. We do not create missing table and procedure for built-in objects. We create missing table and procedure for system objects and add a specific property who says the object is system.

System databases

We create a missing table / procedure for an object prefixed with:

master
model
msdb
resource
tempdb
sybsystemprocs
sybsystemdb
sybsecurity
pub2
pubs3
dbccdb
sybmgmtdb
system

System schemas

We create a missing table / procedure for an object prefixed with:

information_schema
syscat
systat
sysfun
sysibmadm
sysproc
syspublic
sysadm
sysuif
systools
qsys
qsys2
sysstat
sysibminternal
sysibmts
sys
sysibm
system
sysams
performance_schema
sysmysql
anonymous
appqossys
ctxsys
dbc
dbsnmp
dip
exfsys
ix
mddata
mdsys
mgmt_view
oe
olapsys
oracle_ocm
orddata
ordplugins
ordsys
outln
owbsys
owbsys_audit
si_informtn_schema
spatial_csw_admin_usr
spatial_wfs_admin_usr
sqlj
sys_calendar
sysman
wmsys
xdb
xs$null
crdb_internal
pg_catalog
pg_extension
calendar
databasespace
dbase
jars
jar_jar_usage
tvm
routine_jar_usage
uif_v
account_usage
alert
billing
core
data_privacy
data_sharing_usage
external_access
local
ml
monitoring
network_security
notification
organization_usage
reader_account_usage
spcs
telemetry
trust_center

System tables

We create a missing table for a table with any of the following names:

dummy
sysdummy
sysdummy1
sysdummye
sysdummya
sysdummyu
dual
pg_aggregate
pg_am
pg_amop
pg_amproc
pg_attrdef
pg_attribute
pg_authid
pg_auth_members
pg_available_extensions
pg_available_extension_versions
pg_cast
pg_class
pg_collation
pg_config
pg_constraint
pg_conversion
pg_cursors
pg_database
pg_db_role_setting
pg_default_acl
pg_depend
pg_description
pg_enum
pg_event_trigger
pg_extension
pg_file_settings
pg_foreign_data_wrapper
pg_foreign_server
pg_foreign_table
pg_group
pg_hba_file_rules
pg_index
pg_indexes
pg_inherits
pg_init_privs
pg_language
pg_largeobject
pg_largeobject_metadata
pg_locks
pg_matviews
pg_namespace
pg_opclass
pg_operator
pg_opfamily
pg_partitioned_table
pg_pltemplate
pg_policies
pg_policy
pg_prepared_statements
pg_prepared_xacts
pg_proc
pg_publication
pg_publication_rel
pg_publication_tables
pg_range
pg_replication_origin
pg_replication_origin_status
pg_replication_slots
pg_rewrite
pg_roles
pg_rules
pg_seclabels
pg_sequence
pg_sequences
pg_settings
pg_shadow
pg_shdepend
pg_shdescription
pg_shseclabel
pg_stats
pg_stat_all_tables
pg_statistic
pg_statistic_ext
pg_subscription
pg_subscription_rel
pg_tables
pg_tablespace
pg_timezone_abbrevs
pg_timezone_names
pg_transform
pg_trigger
pg_ts_config
pg_ts_config_map
pg_ts_dict
pg_ts_parser
pg_ts_template
pg_type
pg_user
pg_user_mappings
pg_views
session_privs
plan_table
product_privs
product_profile
product_user_profile
starts with v$, gv$, aq$_, all_, dba_, user_, quest_, def$_, mview$_, sqlplus_, sys

Built-in objects

Refers to built-in functions and Oracle packages.

Built-in functions

We do not create a missing procedure for a called object with any of the following names:

abs
absval
accepted_values
access_into_null
acos
acosh
add_days
add_months
adddate
addtime
admin_task_list
admin_task_output
admin_task_status
aes_decrypt
aes_encrypt
agent_run
agg
ai_agg
ai_analogy
ai_classify
ai_complete
ai_complete_multimodal
ai_count_tokens
ai_embed
ai_extract
ai_filter
ai_generate_chunks
ai_generate_embeddings
ai_multi_embed
ai_parse_document
ai_redact
ai_semantic_cluster
ai_sentiment
ai_similarity
ai_summarize_agg
ai_transcribe
ai_translate
alert_history
all
all_rows
all_user_names
and
anomaly_detection
any_value
anydata
anydataset
anytype
app_name
append
append_values
application_callback_history
application_configuration_value_history
application_json
application_specification_status_history
applock_mode
applock_test
approx_count
approx_count_distinct
approx_count_distinct_agg
approx_count_distinct_detail
approx_median
approx_percentile
approx_percentile_agg
approx_percentile_detail
approx_rank
approx_sum
approximate_jaccard_index
approximate_similarity
approx_top_k
approx_top_k_accumulate
approx_top_k_combine
approx_top_k_estimate
approx_percentile
approx_percentile_accumulate
approx_percentile_combine
approx_percentile_estimate
array_agg
array_append
array_cat
array_compact
array_construct
array_construct_compact
array_contains
array_delete
array_dims
array_distinct
array_except
array_flatten
array_fill
array_first
array_generate_range
array_insert
array_intersection
array_last
array_length
array_lower
array_max
array_min
array_ndims
array_next
array_position
array_prepend
array_prior
array_remove
array_remove_at
array_replace
array_shuffle
array_size
array_slice
array_sort
array_to_json
array_to_string
array_trim
array_upper
array_union_agg
array_unique_agg
arrays_overlap
arrays_to_object
arrays_zip
ascii
ascii_str
asciistr
asin
asinh
assemblyproperty
asymkey_id
asymkeyproperty
as_array
as_binary
as_boolean
as_char
as_date
as_decimal
as_double
as_integer
as_number
as_object
as_real
as_time
as_timestamp_ltz
as_timestamp_ntz
as_timestamp_tz
as_varchar
atan
atan2
atanh
atn2
auto_refresh_registration_history
automatic_clustering_history
available_listing_refresh_history
available_listings
avg
base64decode
base64_decode_binary
base64_decode_string
base64_encode
benchmark
between
bfilename
bigint
bin
bin_to_num
bin_to_uuid
binary
binary_double_infinity
binary_double_max_normal
binary_double_max_subnormal
binary_double_min_normal
binary_double_min_subnormal
binary_double_nan
binary_float
binary_float_infinity
binary_float_max_normal
binary_float_max_subnormal
binary_float_min_normal
binary_float_min_subnormal
binary_float_nan
binary_integer
bind_values
bit
bit_and
bit_and_agg
bit_count
bit_length
bit_or
bit_or_agg
bit_xor
bit_xor_agg
bitand
bitand_agg
bitandnot
bitmap_absolute_position
bitmap_and
bitmap_and_agg
bitmap_bit_position
bitmap_bucket_number
bitmap_construct_agg
bitmap_count
bitmap_or
bitmap_or_agg
bitmap_to_array
bitnot
bitor
bitor_agg
bitxor
bitxor_agg
bitshiftleft
bitshiftright
blob
blocking_threads
booland
booland_agg
boolnot
boolor
boolor_agg
boolxor
boolxor_agg
boolean_and_agg
boolean_or_agg
btrim
build_scoped_file_url
build_stage_file_url
cache
can_access_column
can_access_database
can_access_table
can_access_user
can_access_view
cardinality
case
case_not_found
case_format_violation_count
case_format_violation_percent
cast
cbrt
ccsid_encoding
ceil
ceiling
certencoded
certprivatekey
certproperty
change_dupkey_error_index
change_tracking_current_version
change_tracking_is_column_in_mask
change_tracking_min_valid_version
changetable
char
char9
char_length
character_length
charindex
charset
chartorowid
checksum
checksum_agg
choose
chr
check_json
check_xml
classification
classify_text
client_file_null
clob
cluster
cluster_details
cluster_distance
cluster_id
cluster_probability
cluster_set
clustering
coalesce
coercibility
col_length
col_name
collate
collation
collation_key
collationproperty
collect
collection_is_null
column_value
columnproperty
columns
compare_decfloat
complete
complete_task_graphs
compose
compress
compress_immediate
con_dbid_to_id
con_guid_to_id
con_id_to_con_name
con_id_to_dbid
con_id_to_guid
con_id_to_uid
con_name_to_id
con_uid_to_id
concat
concat_ws
conditional_change_event
conditional_true_event
connect_by_isleaf
connect_by_root
connection_id
containers
contains
containstable
contribution_explorer
conv
convert
convert_from
convert_to
convert_tz
convert_timezone
count_if
count_tokens
corr
corr_k
corr_s
correlation
cortex_search_data_scan
cortex_search_refresh_hist
cos
cosh
cosine_distance
cot
count
count_big
covar
covar_pop
covar_samp
covariance
covariance_samp
crc32
createnonschemabasedxml
createschemabasedxml
createxml
crypt_gen_random
cube_table
cume_dist
cumulative_privacy_losses
curdate
current_account
current_account_name
current_available_roles
current_client
current_database
current_date
current_ip_address
current_organization_name
current_organization_user
current_region
current_role
current_role_type
current_schema
current_schemas
current_secondary_roles
current_session
current_sessions
current_statement
current_task_graphs
current_transaction
current_time
current_timestamp
current_user
current_version
current_warehouse
currentpermspace
currval
cursor_already_open
cursor_sharing_exact
cursor_status
curtime
cv
data
data_agent_run
data_metric_function_expectations
data_metric_function_references
data_quality_monitoring_expectation_status
data_quality_monitoring_results
data_metric_scheduled_time
database
database_principal_id
database_refresh_history
database_refresh_progress
database_refresh_progress_by_job
database_replication_usage_history
database_storage_usage_history
databasenamei
databasepropertyex
databasespace
datalength
dataobj_to_mat_partition
dataobj_to_partition
datasketches_hll
datasketches_hll_accumulate
datasketches_hll_combine
datasketches_hll_estimate
data_transfer_history
date
date_add
date_bucket
date_format
date_from_parts
date_part
date_sub
date_trunc
dateadd
datediff
datediff_big
datefromparts
datename
datepart
datetime
datetime2
datetime2fromparts
datetimefromparts
datetimeoffset
datetimeoffsetfromparts
datetrunc
day
dayname
dayofmonth
dayofweek
dayofweekiso
dayofweek_iso
dayofyear
days
days_between
db_id
db_name
dbase
dbclob
dbt_project_execution_history
dbtimezone
dburitype
dec
decfloat
decfloat_format
decfloat_sortkey
decimal
decode
decode_oracle
decompose
decompress_binary
decompress_string
decrypt
decrypt_binary
decrypt_bit
decrypt_char
decrypt_datakey_bigint
decrypt_datakey_bit
decrypt_datakey_clob
decrypt_datakey_dbclob
decrypt_datakey_decimal
decrypt_datakey_integer
decrypt_datakey_varchar
decrypt_datakey_vargraphic
decrypt_db
decrypt_raw
decryptbyasymkey
decryptbycert
decryptbykey
decryptbykeyautoasymkey
decryptbykeyautocert
decryptbypassphrase
default
degrees
delete
deleted
dense_rank
depth
deref
difference
digits
disable_parallel_dml
div
div0
div0null
domain_check
domain_check_type
domain_display
domain_name
domain_order
double
double_precision
dp_interval_high
dp_interval_low
driving_site
dsn_xmlvalidate
dump
dup_val_on_index
duplicate_count
dynamic_sampling
dynamic_table_graph_history
dynamic_table_refresh_history
dynamic_tables
ebcdic_chr
ebcdic_str
edge_id_from_parts
edit_distanc
edit_distance_similarity
editdistance
element_number
elt
email_integration_config
embed_text_1024
embed_text_768
empty_blob
empty_clob
enable_parallel_dml
encode
encrypt
encrypt_datakey
encrypt_raw
encrypt_tdes
encryptbyasymkey
encryptbycert
encryptbykey
encryptbypassphrase
endswith
entity_sentiment
eomonth
equal_null
error_line
error_message
error_number
error_procedure
error_severity
error_state
estimate_remaining_dp_aggregates
every
execute_ai_evaluation
exist
exists
existsnode
exp
explain_grantable_privileges
explain_json
explain_privileges
export_set
extend
external_functions_history
external_table_file_registration_history
external_table_files
extract
extract_answer
extract_semantic_categories
extractvalue
fact
factorial
false
feature_compare
feature_details
feature_id
feature_set
feature_value
field
file_id
file_idex
file_is_directory
file_name
filegroup_id
filegroup_name
filegroupproperty
fileproperty
filetablerootpath
filter
find_in_set
finetune
first
first_rows
first_value
fl_get_content_type
fl_get_etag
fl_get_file_type
fl_get_last_modified
fl_get_relative_path
fl_get_scoped_file_url
fl_get_size
fl_get_stage
fl_get_stage_file_url
fl_is_audio
fl_is_compressed
fl_is_document
fl_is_image
fl_is_video
flatten
float
floor
fn_available_backups
fn_backup_db_config
fn_backup_instance_config
fn_builtin_permissions
fn_cdc_decrement_lsn
fn_cdc_get_column_ordinal
fn_cdc_get_max_lsn
fn_cdc_get_min_lsn
fn_cdc_has_column_changed
fn_cdc_increment_lsn
fn_cdc_is_bit_set
fn_cdc_map_lsn_to_time
fn_cdc_map_time_to_lsn
fn_check_object_signatures
fn_db_backup_file_snapshots
fn_get_audit_file
fn_get_current_xevent_settings
fn_get_health_status
fn_get_parameter
fn_get_sql
fn_hadr_backup_is_preferred_replica
fn_hadr_distributed_ag_database_replica
fn_hadr_distributed_ag_replica
fn_hadr_is_primary_replica
fn_helpcollations
fn_is_master_switch_on
fn_listextendedproperty
fn_msxe_read_event_stream
fn_my_permissions
fn_pagerescracker
fn_servershareddrives
fn_stmt_sql_handle_from_sql_stmt
fn_syscollector_get_execution_details
fn_syscollector_get_execution_stats
fn_trace_getdata
fn_trace_geteventinfo
fn_trace_getfilterinfo
fn_trace_getinfo
fn_trace_gettable
fn_translate_permissions
fn_validate_plan_guide
fn_virtualfileservermodes
fn_virtualfilestats
fn_xe_file_target_read_file
following
for
forecast
format
format_bytes
format_pico_time
found_rows
freetexttable
fresh_mv
freshness
from_base64
from_days
from_tz
from_unixtime
from_vector
full
fulltextcatalogproperty
fulltextserviceproperty
future_timestamp_count
future_timestamp_percent
fuzzy_match
gather_optimizer_statistics
gen_ai_evaluation_data
generate_column_description
generate_postgres_access_token_for_user
generate_series
generate_subscripts
generate_unique
generate_unique_binary
generator
geomcollection
geometrycollection
get
get_absolute_path
get_ai_observability_events
get_ai_observability_logs
get_ai_record_trace
get_anaconda_packages_repodata
get_bit
get_blob_from_file
get_byte
get_clob_from_file
get_condition_query_uuid
get_configuration_value
get_contacts
get_dbclob_from_file
get_dd_column_privileges
get_dd_create_options
get_dd_index_sub_part_length
get_ddl
get_format
get_lock
get_xml_file
getbit
getblobval
getclobval
getdate
getfilenamespacepath
gethint
get_ignore_case
get_job_history
get_lineage
get_object_references
get_path
get_presigned_url
get_python_profiler_output
get_query_operator_stats
get_relative_path
get_stage_location
getnamespace
getnumberval
getpathlocator
getrootelement
getschemaurl
getstringval
getutcdate
getvariable
graph_id_from_edge_id
graph_id_from_node_id
graph_table
graphic
graphql
greatest
greatest_ignore_nulls
group_concat
group_id
grouping
grouping_id
gtid_subset
gtid_subtract
has_perms_by_name
hash
hash_agg
hash_crc32
hash_md5
hash_sha1
hash_sha256
hashbytes
haversine
hex
hex_decode_binary
hex_decode_string
hex_encode
hextoraw
hll
hll_accumulate
hll_combine
hll_estimate
hll_export
hll_import
hour
http_delete
http_delete_blob
http_get
http_get_blobhttp_patch
http_patch_blobhttp_post
http_post_blobhttp_put
http_put_blob
httpblob
httpblobverbose
httpclob
httpclobverbose
httpdeleteblob
httpdeleteblobverbose
httpdeleteclob
httpdeleteclobverbose
httpgetblob
httpgetblobverbose
httpgetclob
httpgetclobverbose
httphead
httpheadverbose
httppostblob
httppostblobverbose
httppostclob
httppostclobverbose
httpputblob
httpputblobverbose
httpputclob
httpputclobverbose
httpuritype
h3_cell_to_boundary
h3_cell_to_children
h3_cell_to_children_string
h3_cell_to_parent
h3_cell_to_point
h3_compact_cells
h3_compact_cells_strings
h3_coverage
h3_coverage_strings
h3_get_resolution
h3_grid_disk
h3_grid_distance
h3_grid_path
h3_int_to_string
h3_is_pentagon
h3_is_valid_cell
h3_latlng_to_cell
h3_latlng_to_cell_string
h3_point_to_cell
h3_point_to_cell_string
h3_polygon_to_cells
h3_polygon_to_cells_strings
h3_string_to_int
h3_try_coverage
h3_try_coverage_strings
h3_try_grid_distance
h3_try_grid_path
h3_try_polygon_to_cells
h3_uncompact_cells
h3_uncompact_cells_strings
iceberg_table_files
iceberg_table_snapshot_refresh_history
icu_version
identity_val_local
if
iff
ifnull
ignore_row_on_dupkey_index
iif
ilike
in
infer_schema
index
index_asc
index_col
index_combine
index_desc
index_ffs
index_join
index_ss
index_ss_asc
index_ss_desc
indexkey_property
indexoptimize
indexproperty
inet6_aton
inet6_ntoa
inet_aton
inet_ntoa
initcap
inmemory
inmemory_pruning
inner_product
insert
inserted
instr
instrb
instrc
instr2
instr4
int
integer
integration
internal_auto_increment
internal_avg_row_length
internal_check_time
internal_checksum
internal_data_free
internal_data_length
internal_dd_char_length
internal_get_comment_or_error
internal_get_enabled_role_json
internal_get_hostname
internal_get_username
internal_get_view_warning_or_error
internal_index_column_cardinality
internal_index_length
internal_is_enabled_role
internal_is_mandatory_role
internal_keys_disabled
internal_max_data_length
internal_table_rows
internal_update_time
interpolate_bfill
interpolate_ffill
interpolate_linear
interval
invalid_client_file_dir
invalid_cursor
invalid_number
invalid_json_count,
invalid_json_percent
invalid_numeric_type_cast_count
invalid_numeric_type_cast_percent
invoker_role
invoker_share
is
is_application_role_in_session
is_application_role_activated
is_array
is_binary
is_boolean
is_char
is_configuration_set
is_database_role_activated
is_database_role_in_session
is_date
is_date_value
is_decimal
is_double
is_free_lock
is_granted_to_invoker_role
is_group_activated
is_group_imported
is_instance_role_in_session
is_integer
is_null_value
is_object
is_ipv4
is_ipv4_compat
is_ipv4_mapped
is_ipv6
is_member
is_real
is_rolemember
is_role_in_session
is_role_activated
is_organization_user
is_organization_user_group
is_organization_user_group_in_session
is_srvrolemember
is_time
is_timestamp_ltz
is_timestamp_ntz
is_timestamp_tz
is_used_lock
is_user_imported
is_uuid
is_varchar
isdate
isfragment
isjson
isnull
isnumeric
isschemabased
isschemavalid
isschemavalidated
iteration_number
ivf_iteration
jaro_winkler_distance
jaro_winkler_similarity
jarowinkler_similarity
json_agg
json_array
json_array_append
json_array_elements
json_array_elements_text
json_array_insert
json_array_length
json_arrayagg
json_build_array
json_build_object
json_contains
json_contains_path
json_dataguide
json_depth
json_each
json_each_text
json_extract
json_extract_path
json_extract_path_text
json_id
json_insert
json_keys
json_length
json_merge
json_merge_patch
json_merge_preserve
json_modify
json_object
json_object_agg
json_object_keys
json_objectagg
json_overlaps
json_path_exists
json_populate_record
json_populate_recordset
json_pretty
json_query
json_quote
json_remove
json_replace
json_scalar
json_schema_valid
json_schema_validation_report
json_search
json_serializev
json_set
json_storage_free
json_storage_size
json_strip_nulls
json_table
json_to_bson
json_to_record
json_to_recordset
json_transform
json_type
json_typeof
json_unquote
json_update
json_valid
json_value
jsonb_agg
jsonb_array_elements
jsonb_array_elements_text
jsonb_array_length
jsonb_build_array
jsonb_build_object
jsonb_each
jsonb_each_text
jsonb_extract_path
jsonb_extract_path_text
jsonb_object
jsonb_object_agg
jsonb_object_keys
jsonb_populate_record
jsonb_populate_recordset
jsonb_pretty
jsonb_set
jsonb_strip_nulls
jsonb_to_record
jsonb_to_recordset
jsonb_typeof
julian_day
keep
key_guid
key_id
key_name
kurtosis
kurtosis_pop
kurtosis_samp
l1_distance
l2_distance
lag
last
last_day
last_insert_id
last_query_id
last_transaction
last_successful_scheduled_time
last_value
lastval
lcase
lead
lead1
leading
least
least_ignore_nulls
left
left_shift
len
length
lengthb
lengthc
length2
length4
level
like
limit
linestring
listagg
listing_refresh_history
ln
lnnvl
load_file
localtime
localtimestamp
locate
locate_in_string
log
log10
log2
login_denied
login_history
login_history_by_user
loginproperty
long
lower
lpad
ltrim
make_ref
make_set
makedate
maketime
map_cat
map_contains_key
map_delete
map_entries
map_insert
map_keys
map_pick
map_size
master_pos_wait
match
matchnum
materialized_view_refresh_history
max
max_by
max_cardinality
mbrcontains
mbrcoveredby
mbrcovers
mbrdisjoint
mbrequals
mbrintersects
mbroverlaps
mbrtouches
mbrwithin
md5
md5_binary
md5_hex
md5_number
md5_number_lower64
md5_number_upper64
median
merge
microsecond
mid
midnight_seconds
min
minhash
minhash_combine
min_by
minute
mod
mode
model_min_analysis
model_monitor_drift_metric
model_monitor_performance_metric
model_monitor_stat_metric
monitor
month
monthname
months_between
mqread
mqreadall
mqreadallclob
mqreadclob
mqreceive
mqreceiveall
mqreceiveallclob
mqreceiveclob
mqsend
multilinestring
multiply_alt
multipoint
multipolygon
name_const
namespace
nanvl
native_full_outer_join
nchar
nchr
negative_count
negative_percent
new_time
newid
next
next_day
next_month
nextval
network_rule_references
nls_charset_decl_len
nls_charset_id
nls_charset_name
nls_collation_id
nls_collation_name
nls_initcap
nls_lower
nls_upper
nlssort
no_clustering
no_data_found
no_expand
no_fact
no_gather_optimizer_statistics
no_index
no_index_ffs
no_index_ss
no_inmemory
no_inmemory_pruning
no_merge
no_monitor
no_native_full_outer_join
no_parallel
no_parallel_index
no_pq_concurrent_union
no_pq_skew
no_push_pred
no_push_subq
no_px_join_filter
no_query_transformation
no_result_cache
no_rewrite
no_star_transformation
no_statement_queuing
no_unnest
no_use_band
no_use_cube
no_use_hash
no_use_merge
no_use_nl
no_xml_query_rewrite
no_xmlindex_rewrite
no_zonemap
noappend
nocache
node_id_from_parts
nodes
noparallel
noparallel_index
norewrite
normal
normalize_decfloat
normalize_string
not
not_logged_on
notification_history
now
nth_value
ntile
null
null_count
null_percent
nullif
nullifzero
numtodsinterval
numtoyminterval
nvarchar
nvarchar2
nvl
nvl2
object_agg
object_construct
object_construct_keep_null
object_definition
object_delete
object_id
object_id_from_edge_id
object_id_from_node_id
object_insert
object_keys
object_name
object_pick
object_schema_name
object_value
objectproperty
objectpropertyex
oct
octet_length
online_feature_table_refresh_history
openjson
openrowset
openxml
opt_param
optimizer_features_enable
option
or
ora_dm_partition_name
ora_dst_affected
ora_dst_convert
ora_dst_error
ora_hash
ora_invoking_user
ora_invoking_userid
ora_rowscn
ora_shardspace_name
ord
ordered
original_db_name
original_login
others
output
over
overlay
pack
parallel
parallel_index
parse
parse_document
parse_ip
parse_json
parse_url
parse_xml
parsename
path
path_name
pathname
patindex
peakpermspace
percent_rank
percentile_cont
percentile_disc
period_add
period_diff
permissions
pg_advisory_lock
pg_advisory_unlock
pg_client_encoding
pg_is_other_temp_schema
pg_schema_size
pg_size_pretty
pg_total_relation_size
pg_try_advisory_lock
phonic_encode
pi
pipe_usage_history
pivot
pls_integer
point
policy_context
policy_references
polygon
position
posstr
pow
power
powermultiset
powermultiset_by_cardinality
pq_concurrent_union
pq_distribute
pq_filter
pq_skew
preceding
prediction
prediction_bounds
prediction_cost
prediction_details
prediction_probability
prediction_set
presentnnv
presentv
previous
previous_day
print
prior
program_error
prompt
property_exists
ps_current_thread_id
ps_thread_id
push_pred
push_subq
pwdcompare
pwdencrypt
px_join_filter
qb_name
quantize
quarter
query
query_acceleration_history
query_history
query_history_by_session
query_history_by_user
query_history_by_warehouse
quote
quote_ident
quote_literal
quote_nullable
quotename
radians
raise
raise_application_error
raise_error
raiserror
rand
randstr
random
random_bytes
rank
ratio_to_report
raw_to_uuid
rawtohex
rawtonhex
readtext
real
reduce
ref
reference
reftohex
regexp
regexp_extract_all
regexp_count
regexp_instr
regexp_like
regexp_matches
regexp_replace
regexp_split_to_array
regexp_split_to_table
regexp_substr
regexp_substr_all
regr_avgx
regr_avgy
regr_count
regr_icpt
regr_intercept
regr_r2
regr_slope
regr_sxx
regr_sxy
regr_syy
regr_valx
regr_valy
relation
release_all_locks
release_lock
remainder
repeat
replace
replicate
replication_group_dangling_references
replication_group_refresh_history
replication_group_refresh_history_all
replication_group_refresh_progress
replication_group_refresh_progress_all
replication_group_refresh_progress_by_job
replication_group_usage_history
replication_usage_history
rest_event_history
result_cache
result_scan
retry_on_row_change
reverse
revert
rewrite
rid
right
right_shift
rlike
roles_graphml
round
round_ties_to_even
round_timestamp
row_count
row_number
row_to_json
rowcount
rowid
rowidtochar
rowidtonchar
rownum
rowtype_mismatch
rpad
rtrim
rtrimmed_length
sanitize_webhook_content
scheduled_time
schema
schema_id
schema_name
schemavalidate
scn_to_timestamp
scope_identity
score
sdo_geometry
sdo_georaster
sdo_topo_geometry
search
search_ip
search_optimization_history
search_preview
sec_to_time
second
self
self_is_nul
semantickeyphrasetable
semanticsimilaritydetailstable
semanticsimilaritytable
send_email_integration
sentiment
seq1
seq2
seq4
seq8
serverless_alert_history
serverless_task_history
serverproperty
session_user
sessiontimezone
set
set_bit
set_byte
set_sys_context
setschemavalidated
setseed
setval
sha
sha1
sha1_binary
sha1_hex
sha2
sha2_binary
sha2_hex
shard_chunk_id
show_python_packages_dependencies
sign
sin
sinh
skew
skewness_pop
skewness_samp
sleep
smalldatetime
smalldatetimefromparts
smallint
soaphttpc
soaphttpnc
soaphttpnv
soaphttpv
soundex
soundex_p123
source_pos_wait
sp_mshasdbaccess
sp_add_data_file_recover_suspect_db
sp_add_log_file_recover_suspect_db
sp_add_trusted_assembly
sp_addapprole
sp_addextendedproc
sp_addextendedproperty
sp_addlinkedserver
sp_addlinkedsrvlogin
sp_addlogin
sp_addmessage
sp_addremotelogin
sp_addrole
sp_addrolemember
sp_addserver
sp_addsrvrolemember
sp_addtype
sp_addumpdevice
sp_adduser
sp_altermessage
sp_approlepassword
sp_assemblies_rowset
sp_assemblies_rowset2
sp_assemblies_rowset_rmt
sp_assembly_dependencies_rowset
sp_assembly_dependencies_rowset2
sp_assembly_dependencies_rowset_rmt
sp_attach_db
sp_attach_single_file_db
sp_audit_write
sp_autostats
sp_bcp_dbcmptlevel
sp_bindefault
sp_bindrule
sp_bindsession
sp_catalogs
sp_catalogs_rowset
sp_catalogs_rowset2
sp_catalogs_rowset_rmt
sp_cdc_add_job
sp_cdc_change_job
sp_cdc_cleanup_change_table
sp_cdc_disable_db
sp_cdc_disable_table
sp_cdc_drop_job
sp_cdc_enable_db
sp_cdc_enable_table
sp_cdc_generate_wrapper_function
sp_cdc_get_captured_columns
sp_cdc_get_ddl_history
sp_cdc_help_change_data_capture
sp_cdc_help_jobs
sp_cdc_scan
sp_cdc_start_job
sp_cdc_stop_job
sp_certify_removable
sp_change_users_login
sp_changedbowner
sp_changeobjectowner
sp_check_constbytable_rowset
sp_check_constbytable_rowset2
sp_check_constraints_rowset
sp_check_constraints_rowset2
sp_clean_db_file_free_space
sp_clean_db_free_space
sp_column_privileges
sp_column_privileges_ex
sp_column_privileges_rowset
sp_column_privileges_rowset2
sp_column_privileges_rowset_rmt
sp_columns
sp_columns_90
sp_columns_90_rowset
sp_columns_90_rowset2
sp_columns_90_rowset_rmt
sp_columns_ex
sp_columns_ex_90
sp_columns_rowset
sp_columns_rowset2
sp_columns_rowset_rmt
sp_configure
sp_constr_col_usage_rowset
sp_control_dbmasterkey_password
sp_control_plan_guide
sp_copy_data_in_batches
sp_create_plan_guide
sp_create_plan_guide_from_handle
sp_create_removable
sp_createstats
sp_cursor
sp_cursor_list
sp_cursorclose
sp_cursorexecute
sp_cursorfetch
sp_cursoropen
sp_cursoroption
sp_cursorprepare
sp_cursorprepexec
sp_cursorunprepare
sp_cycle_errorlog
sp_databases
sp_datatype_info
sp_datatype_info_90
sp_db_increased_partitions
sp_db_selective_xml_index
sp_dbcmptlevel
sp_dbfixedrolepermission
sp_dbmmonitoraddmonitoring
sp_dbmmonitorchangealert
sp_dbmmonitorchangemonitoring
sp_dbmmonitordropalert
sp_dbmmonitordropmonitoring
sp_dbmmonitorhelpalert
sp_dbmmonitorhelpmonitoring
sp_dbmmonitorresults
sp_ddopen
sp_defaultdb
sp_defaultlanguage
sp_delete_backuphistory
sp_denylogin
sp_depends
sp_describe_cursor
sp_describe_cursor_columns
sp_describe_cursor_tables
sp_describe_first_result_set
sp_describe_parameter_encryption
sp_describe_undeclared_parameters
sp_detach_db
sp_drop_trusted_assembly
sp_dropalias
sp_dropapprole
sp_dropdevice
sp_dropextendedproc
sp_dropextendedproperty
sp_droplinkedsrvlogin
sp_droplogin
sp_dropmessage
sp_dropremotelogin
sp_droprole
sp_droprolemember
sp_dropserver
sp_dropsrvrolemember
sp_droptype
sp_dropuser
sp_execute
sp_executesql
sp_external_policy_refresh
sp_fkeys
sp_flush_log
sp_foreign_keys_rowset
sp_foreign_keys_rowset2
sp_foreign_keys_rowset3
sp_foreign_keys_rowset_rmt
sp_foreignkeys
sp_fulltext_database
sp_generate_database_ledger_digest
sp_get_endpoint_certificate
sp_get_query_template
sp_getapplock
sp_getbindtoken
sp_grantdbaccess
sp_grantlogin
sp_help
sp_help_spatial_geography_histogram
sp_help_spatial_geography_index
sp_help_spatial_geography_index_xml
sp_help_spatial_geometry_histogram
sp_help_spatial_geometry_index
sp_helpconstraint
sp_helpdb
sp_helpdbfixedrole
sp_helpdevice
sp_helpextendedproc
sp_helpfile
sp_helpfilegroup
sp_helpindex
sp_helplanguage
sp_helplinkedsrvlogin
sp_helplogins
sp_helpntgroup
sp_helpremotelogin
sp_helprole
sp_helprolemember
sp_helprotect
sp_helpserver
sp_helpsort
sp_helpsrvrole
sp_helpsrvrolemember
sp_helpstats
sp_helptext
sp_helptrigger
sp_helpuser
sp_indexes
sp_indexes_90_rowset
sp_indexes_90_rowset2
sp_indexes_90_rowset_rmt
sp_indexes_rowset
sp_indexes_rowset2
sp_indexes_rowset_rmt
sp_indexoption
sp_invalidate_textptr
sp_invoke_external_rest_endpoint
sp_linkedservers_rowset
sp_linkedservers_rowset2
sp_lock
sp_makewebtask
sp_merge_xtp_checkpoint_files
sp_migrate_user_to_contained
sp_monitor
sp_oledb_database
sp_oledb_defdb
sp_oledb_deflang
sp_oledb_language
sp_oledb_ro_usrname
sp_password
sp_pkeys
sp_prepare
sp_prepexec
sp_prepexecrpc
sp_primary_keys_rowset
sp_primary_keys_rowset2
sp_primary_keys_rowset_rmt
sp_primarykeys
sp_procedure_params_90_rowset
sp_procedure_params_90_rowset2
sp_procedure_params_rowset
sp_procedure_params_rowset2
sp_procedures_rowset
sp_procedures_rowset2
sp_procoption
sp_provider_types_90_rowset
sp_provider_types_rowset
sp_readerrorlog
sp_recompile
sp_refresh_parameter_encryption
sp_refreshview
sp_releaseapplock
sp_remoteoption
sp_rename
sp_renamedb
sp_resetstatus
sp_revokedbaccess
sp_revokelogin
sp_schemata_rowset
sp_send_dbmail
sp_sequence_get_range
sp_server_info
sp_serveroption
sp_set_session_context
sp_setapprole
sp_setnetname
sp_settriggerorder
sp_spaceused
sp_special_columns
sp_special_columns_90
sp_sproc_columns
sp_sproc_columns_90
sp_srvrolepermission
sp_statistics
sp_statistics_rowset
sp_statistics_rowset2
sp_stored_procedures
sp_syscollector_create_collection_item
sp_syscollector_create_collection_set
sp_syscollector_create_collector_type
sp_syscollector_delete_collection_item
sp_syscollector_delete_collection_set
sp_syscollector_delete_collector_type
sp_syscollector_delete_execution_log_tree
sp_syscollector_disable_collector
sp_syscollector_enable_collector
sp_syscollector_run_collection_set
sp_syscollector_set_cache_directory
sp_syscollector_set_cache_window
sp_syscollector_set_warehouse_database_name
sp_syscollector_set_warehouse_instance_name
sp_syscollector_start_collection_set
sp_syscollector_stop_collection_set
sp_syscollector_update_collection_item
sp_syscollector_update_collection_set
sp_syscollector_update_collector_type
sp_syscollector_upload_collection_set
sp_table_constraints_rowset
sp_table_constraints_rowset2
sp_table_privileges
sp_table_privileges_ex
sp_table_privileges_rowset
sp_table_privileges_rowset2
sp_table_privileges_rowset_rmt
sp_table_statistics2_rowset
sp_table_statistics_rowset
sp_tablecollations
sp_tablecollations_90
sp_tableoption
sp_tables
sp_tables_ex
sp_tables_info_90_rowset
sp_tables_info_90_rowset2
sp_tables_info_90_rowset2_64
sp_tables_info_90_rowset_64
sp_tables_info_rowset
sp_tables_info_rowset2
sp_tables_info_rowset2_64
sp_tables_info_rowset_64
sp_tables_rowset
sp_tables_rowset2
sp_tables_rowset_rmt
sp_testlinkedserver
sp_unbindefault
sp_unbindrule
sp_unprepare
sp_unsetapprole
sp_updateextendedproperty
sp_updatestats
sp_usertypes_rowset
sp_usertypes_rowset2
sp_usertypes_rowset_rmt
sp_validatelogins
sp_validname
sp_verify_database_ledger
sp_verify_database_ledger_from_digest_storage
sp_views_rowset
sp_views_rowset2
sp_wait_for_database_copy_sync
sp_who
sp_xml_preparedocument
sp_xml_removedocument
sp_xml_schema_rowset
sp_xml_schema_rowset2
sp_xp_cmdshell_proxy_account
sp_xtp_bind_db_resource_pool
sp_xtp_checkpoint_force_garbage_collection
sp_xtp_control_proc_exec_stats
sp_xtp_control_query_exec_stats
sp_xtp_force_gc
sp_xtp_unbind_db_resource_pool
space
special_character_count
special_character_percent
split
split_part
split_text_markdown_header
split_text_recursive_character
split_to_table
sql
sqlcode
sqlerrm
sqrt
square
st_area
st_asbinary
st_asewkb
st_asewkt
st_asgeojson
st_astext
st_aswkb
st_aswkt
st_azimuth
st_buffer
st_buffer_strategy
st_centroid
st_collect
st_contains
st_convexhull
st_coveredby
st_covers
st_crosses
st_difference
st_dimension
st_disjoint
st_distance
st_distance_sphere
st_dwithin
st_endpoint
st_envelope
st_equals
st_exteriorring
st_frechetdistance
st_geogfromgeohash
st_geogpointfromgeohash
st_geographyfromwkb
st_geographyfromwkt
st_geohash
st_geomcollfromtext
st_geomcollfromwkb
st_geometrycollectionfromtext
st_geometrycollectionfromwkb
st_geometryfromwkb
st_geometryfromwkt
st_geometryn
st_geometrytype
st_geomfromgeojson
st_geomfromgeohash
st_geompoint
st_geompointfromgeohash
st_geomfromtext
st_geomfromwkb
st_hausdorffdistance
st_interiorringn
st_interpolate
st_intersection
st_intersection_agg
st_intersects
st_isclosed
st_isempty
st_issimple
st_isvalid
st_latfromgeohash
st_latitude
st_length
st_linefromtext
st_linefromwkb
st_lineinterpolatepoint
st_lineinterpolatepoints
st_linestringfromtext
st_linestringfromwkb
st_longfromgeohash
st_longitude
st_makeenvelope
st_makegeompoint
st_makeline
st_makepoint
st_makepolygon
st_makepolygonoriented
st_mlinefromtext
st_mlinefromwkb
st_mpointfromtext
st_mpointfromwkb
st_mpolyfromtext
st_mpolyfromwkb
st_multilinestringfromtext
st_multilinestringfromwkb
st_multipointfromtext
st_multipointfromwkb
st_multipolygonfromtext
st_multipolygonfromwkb
st_npoints
st_numgeometries
st_numinteriorring
st_numinteriorrings
st_numpoints
st_overlaps
st_perimeter
st_point
st_pointatdistance
st_pointfromgeohash
st_pointfromtext
st_pointfromwkb
st_pointn
st_polyfromtext
st_polyfromwkb
st_polygon
st_polygonfromtext
st_polygonfromwkb
st_setsrid
st_simplify
st_srid
st_startpoint
st_swapxy
st_symdifference
st_touches
st_transform
st_union
st_union_agg
st_validate
st_within
st_x
st_xmax
st_xmin
st_y
st_ymax
st_ymin
stage_directory_file_registration_history
stage_storage_usage_history
standard_hash
star_transformation
starts_with
startswith
statement_digest
statement_digest_text
statement_queuing
stats_binomial_test
stats_crosstab
stats_date
stats_f_test
stats_ks_test
stats_mode
stats_mw_test
stats_one_way_anova
stats_t_test_indep
stats_t_test_indepu
stats_t_test_one
stats_t_test_paired
stats_wsr_test
std
stddev
stddev_pop
stddev_samp
stdev
stdevp
step
storage_error
storage_lifecycle_policy_history
str
str_to_date
strcmp
string
string_agg
string_escape
string_split
string_to_array
strip
strip_null_value
strleft
strpos
strright
strtok
strtok_split_to_table
strtok_to_array
stuff
subdate
subscript_beyond_count
subscript_outside_limit
substr
substrb
substrc
substr2
substr4
substring
substring_index
subtime
sum
summarize
suser_id
suser_name
suser_sid
suser_sname
switchoffset
symkeyproperty
sys_connect_by_path
sys_context
sys_dburigen
sys_extract_utc
sys_guid
sys_invalid_rowid
sys_op_zone_id
sys_refcursor
sys_row_etag
sys_typeid
sys_xmlagg
sys_xmlgen
sysdate
sysdatetime
sysdatetimeoffset
sysexecsql
sysmail_add_account_sp
sysmail_add_principalprofile_sp
sysmail_add_profile_sp
sysmail_add_profileaccount_sp
sysmail_configure_sp
sysmail_delete_account_sp
sysmail_delete_log_sp
sysmail_delete_mailitems_sp
sysmail_delete_principalprofile_sp
sysmail_delete_profile_sp
sysmail_delete_profileaccount_sp
sysmail_help_account_sp
sysmail_help_configure_sp
sysmail_help_principalprofile_sp
sysmail_help_profile_sp
sysmail_help_profileaccount_sp
sysmail_help_queue_sp
sysmail_help_status_sp
sysmail_start_sp
sysmail_stop_sp
sysmail_update_principalprofile_sp
sysmail_update_profile_sp
sysmail_update_profileaccount_sp
system_user
system$abort_session
system$abort_transaction
system$activate_cmk_info
system$activate_cmk_info_postgres
system$add_event
system$add_reference
system$allowlist
system$allowlist_privatelink
system$app_compatibility_check
system$application_get_log_level
system$application_get_metric_level
system$application_get_trace_level
system$authorize_privatelink
system$authorize_stage_privatelink_access
system$auto_refresh_status
system$begin_debug_application
system$behavior_change_bundle_status
system$block_internal_stages_public_access
system$block_internal_stages_public_access_with_exception
system$cancel_all_queries
system$cancel_query
system$catalog_link_status
system$cke_hash_function
system$cleanup_database_role_grants
system$client_version_info
system$client_vulnerability_info
system$clustering_depth
system$clustering_information
system$clustering_ratio
system$commit_move_organization_account
system$convert_pipes_sqs_to_sns
system$create_billing_event
system$current_user_task_name
system$data_metric_scan
system$database_refresh_history
system$database_refresh_progress
system$database_refresh_progress_by_job
system$deactivate_cmk_info
system$deprovision_privatelink_endpoint
system$deprovision_privatelink_endpoint_tss
system$deregister_cmk_info
system$deregister_cmk_info_postgres
system$desc_iceberg_access_identity
system$disable_behavior_change_bundle
system$disable_database_replication
system$disable_global_data_sharing_for_account
system$disable_preview_access
system$disable_privatelink_access_only
system$enable_behavior_change_bundle
system$enable_global_data_sharing_for_account
system$encode_cke_primary_key
system$end_debug_application
system$enforce_privatelink_access_only
system$estimate_query_acceleration
system$estimate_search_optimization_costs
system$evaluate_data_quality_expectations
system$evaluate_data_quality_expectations_persist_result
system$explain_json_to_text
system$explain_plan_json
system$export_tds_from_semantic_view
system$external_table_pipe_status
system$finish_oauth_flow
system$generate_saml_csr
system$generate_scim_access_token
system$get_all_references
system$get_aws_sns_iam_policy
system$get_catalog_linked_database_config
system$get_classification_result
system$get_cmk_akv_consent_url
system$get_cmk_config
system$get_cmk_config_postgres
system$get_cmk_info
system$get_cmk_info_postgres
system$get_cmk_kms_key_policy
system$get_compute_pool_pending_maintenance
system$get_dbt_log
system$get_debug_status
system$get_default_columns_override_for_show_command
system$get_default_columns_override_for_system_object
system$get_directory_table_status
system$get_gcp_kms_cmk_grant_access_cmd
system$get_iceberg_table_information
system$get_instance_family_placement_groups
system$get_login_failure_details
system$get_predecessor_return_value
system$get_preview_access_status
system$get_privatelink
system$get_privatelink_authorized_endpoints
system$get_privatelink_config
system$get_privatelink_endpoint_registrations
system$get_privatelink_endpoints_info
system$get_purchase_attributes
system$get_referenced_object_id_hash
system$get_resultset_status
system$get_service_dns_domain
system$get_service_logs
system$get_service_status
system$get_snowflake_egress_ip_ranges
system$get_snowflake_platform_info
system$get_stage_privatelink_authorized_endpoints
system$get_tag
system$get_tag_allowed_values
system$get_tag_on_current_column
system$get_tag_on_current_table
system$get_task_graph_config
system$global_account_set_parameter
system$internal_stages_public_access_status
system$is_application_all_mandatory_telemetry_event_definitions_enabled
system$is_application_authorized_for_telemetry_event_sharing
system$is_application_installed_from_same_account
system$is_application_sharing_events_with_provider
system$is_global_data_sharing_enabled_for_account
system$is_listing_purchased
system$is_listing_trial
system$last_change_commit_time
system$link_account_objects_by_name
system$link_organization_user_group
system$list_application_restricted_features
system$list_iceberg_tables_from_catalog
system$list_namespaces_from_catalog
system$locate_dbt_archive
system$locate_dbt_artifacts
system$log
system$log_debug
system$log_error
system$log_fatal
system$log_info
system$log_trace
system$log_warn
system$migrate_saml_idp_registration
system$opt_in_internal_stage_network_logs
system$opt_out_internal_stage_network_logs
system$opt_out_malicious_ip_protection_by_category
system$pipe_force_resume
system$pipe_rebinding_with_notification_channel
system$pipe_status
system$provision_privatelink_endpoint
system$provision_privatelink_endpoint_tss
system$query_reference
system$read_yaml_from_semantic_view
system$reference
system$register_cmk_info
system$register_cmk_info_postgres
system$register_privatelink_endpoint
system$registry_list_images
system$remove_all_references
system$remove_reference
system$report_health_status
system$resolve_python_packages
system$restore_privatelink_endpoint
system$restore_privatelink_endpoint_tss
system$revoke_privatelink
system$revoke_stage_privatelink_access
system$schedule_async_replication_group_refresh
system$send_notifications_to_catalog
system$set_application_restricted_feature_access
system$set_catalog_integration
system$set_default_columns_override_for_show_command
system$set_default_columns_override_for_system_object
system$set_event_sharing_account_for_region
system$set_privatelink_endpoint_hostname
system$set_reference
system$set_return_value
system$set_row_timestamp_on_all_supported_tables
system$set_span_attributes
system$show_active_behavior_change_bundles
system$show_budgets_in_account
system$show_event_sharing_accounts
system$show_move_organization_account_status
system$show_oauth_client_secrets
system$show_sensitive_data_monitored_entities
system$snowpipe_streaming_update_channel_offset_token
system$start_oauth_flow
system$start_user_email_verification
system$stream_backlog
system$stream_get_table_timestamp
system$stream_has_data
system$supported_dbt_versions
system$task_dependents_enable
system$task_runtime_info
system$trigger_listing_refresh
system$typeof
system$unblock_internal_stages_public_access
system$unlink_organization_user
system$unlink_organization_user_group
system$unregister_privatelink_endpoint
system$unset_default_columns_override_for_show_command
system$unset_default_columns_override_for_system_object
system$unset_event_sharing_account_for_region
system$user_task_cancel_ongoing_executions
system$validate_storage_integration
system$verify_catalog_integration
system$verify_cmk_info
system$verify_cmk_info_postgres
system$verify_external_oauth_token
system$verify_external_volume
system$wait
system$wait_for_services
system$whitelist
ssystem$whitelist_privatelink
systimestamp
sysutcdatetime
table
tag_references
tag_references_all_columns
tag_references_with_lineage
tan
tanh
task_dependents
task_history
tertiary_weights
text_html
text_plain
textptr
textvalid
the
time
time_bucket
time_format
time_from_parts
time_slice
time_to_sec
timeadd
timediff
timefromparts
timeout_on_resource
timestamp
timestamp_from_parts
timestamp_format
timestamp_iso
timestamp_ltz_from_parts
timestamp_ntz_from_parts
timestamp_to_scn
timestamp_tz
timestamp_tz_from_parts
timestampadd
timestampdiff
to_approx_count_distinct
to_approx_percentile
to_array
to_ascii
to_base64
to_binary
to_binary_double
to_binary_float
to_blob
to_boolean
to_char
to_clob
to_date
to_days
to_decfloat
to_decimal
to_double
to_dsinterval
to_file
to_geography
to_geometry
to_hex
to_json
to_jsonb
to_lob
to_multi_byte
to_nchar
to_nclob
to_number
to_numeric
to_object
to_query
to_seconds
to_single_byte
to_time
to_timestamp
to_timestamp_ltz
to_timestamp_ntz
to_timestamp_tz
to_tsquery
to_tsvector
to_utc_timestamp_tz
to_uuid
to_varchar
to_variant
to_vector
to_xml
to_yminterval
todatetimeoffset
too_many_rows
toobject
top
top_insights
totalorder
transform
translate
treat
trim
trim_array
true
trunc
trunc_timestamp
truncate
try_base64_decode_binary
try_base64_decode_string
try_cast
try_complete
try_convert
try_decrypt
try_decrypt_raw
try_hex_decode_binary
try_hex_decode_string
try_parse
try_parse_json
try_to_binary
try_to_boolean
try_to_date
try_to_decfloat
try_to_decimal
try_to_double
try_to_file
try_to_geography
try_to_geometry
try_to_number
try_to_numeric
try_to_time
try_to_timestamp
try_to_timestamp_ltz
try_to_timestamp_ntz
try_to_timestamp_tz
try_to_uuid
ts_headline
ts_rank
ts_rank_cd
tsvector_update_trigger
tvm
tvmnamei
type
type_id
type_name
typeof
typeproperty
tz_offset
ucase
uid
unbounded
uncompress
uncompressed_length
unhex
unicode
unicode_str
uniform
unique_count
unistr
unix_timestamp
unnest
unpack
untrimmed_string_count
untrimmed_string_percent
update_account_sp
updatexml
upper
urldecode
urlencode
use_band
use_concat
use_cube
use_hash
use_merge
use_nl
use_nl_with_index
user
user_id
user_name
userenv
utc_date
utc_time
utc_timestamp
uuid
uuid_short
uuid_string
uuid_to_bin
uuid_to_raw
validate
validate_conversion
validate_password_strength
validate_pipe_load
value
value_error
values
var
var_pop
var_samp
varbinary
varchar
varchar2
varchar9
varchar_format
vargraphic
variable
variance
variance_pop
variance_samp
varp
vector
vector_avg
vector_chunks
vector_cosine_similarity
vector_dimension_count
vector_dimension_format
vector_dims
vector_distance
vector_embedding
vector_inner_product
vector_l1_distance
vector_l2_distance
vector_max
vector_min
vector_norm
vector_normalize
vector_serialize
vector_sum
vector_truncate
vectorproperty
verify_group_for_user
verify_role_for_user
verify_trusted_context_role_for_user
version
vertex
vsize
wait_for_executed_gtid_set
wait_until_sql_thread_after_gtids
warehouse_load_history
warehouse_metering_history
week
week_iso
weekday
weekiso
weekofyear
weight_string
width_bucket
withchange_tracking_context
wm_concat
writetext
xact_state
xdburitype
xml
xmlagg
xmlattributes
xmlcast
xmlcdata
xmlcolattval
xmlcomment
xmlconcat
xmldata
xmldiff
xmldocument
xmlelement
xmlexists
xmlforest
xmlget
xmlisvalid
xmlmodify
xmlnamespaces
xmlparse
xmlpatch
xmlpi
xmlquery
xmlrow
xmlsequence
xmlserialize
xmltable
xmltext
xmltransform
xmltype
xmlxsrobjectid
xor
xp_cmdshell
xp_enumgroups
xp_logininfo
xsltransform
year
yearofweek
yearofweekiso
yearweek
zero_count
zero_divide
zero_percent
zeroifnull
zipf

Oracle built-in packages

We do not create a missing procedure for a called object prefixed with:

apex_custom_auth
apex_application
apex_item
apex_util
ctx_adm
ctx_cls
ctx_ddl
ctx_doc
ctx_output
ctx_query
ctx_report
ctx_thes
ctx_ulexer
dbms_addm
dbms_advanced_rewrite
dbms_advisor
dbms_alert
dbms_application_info
dbms_apply_adm
dbms_aq
dbms_aqadm
dbms_aqelm
dbms_aqin
dbms_assert
dbms_auto_index
dbms_auto_task_admin
dbms_aw_stats
dbms_capture_adm
dbms_comparison
dbms_compression
dbms_connection_pool
dbms_cq_notification
dbms_crypto
dbms_csx_admin
dbms_cube
dbms_cube_advise
dbms_data_mining
dbms_data_mining_transform
dbms_datapump
dbms_db
dbms_dbfs_content
dbms_dbfs_content_spi
dbms_dbfs_hs
dbms_dbfs_sfs
dbms_db_version
dbms_ddl
dbms_debug
dbms_defer
dbms_defer_query
dbms_defer_sys
dbms_describe
dbms_dg
dbms_dimension
dbms_distributed_trust_admin
dbms_epg
dbms_errlog
dbms_expfil
dbms_fga
dbms_file_group
dbms_file_transfer
dbms_flashback
dbms_flashback_archive
dbms_frequent_itemset
dbms_hm
dbms_hprof
dbms_hs_parallel
dbms_hs_passthrough
dbms_iot
dbms_java
dbms_job
dbms_ldap
dbms_ldap_utl
dbms_libcache
dbms_lob
dbms_lock
dbms_logmnr
dbms_logmnr_d
dbms_logstdby
dbms_metadata
dbms_metadata_diff
dbms_mgd_id_utl
dbms_mgwadm
dbms_mgwmsg
dbms_monitor
dbms_mview
dbms_network_acl_admin
dbms_network_utl
dbms_obfuscation_toolkit
dbms_odci
dbms_offline_og
dbms_olap
dbms_outln
dbms_output
dbms_parallel_execute
dbms_pclxutil
dbms_pipe
dbms_predictive_analytics
dbms_preprocessor
dbms_profiler
dbms_propagation_adm
dbms_random
dbms_rectifier_diff
dbms_redefinition
dbms_refresh
dbms_repair
dbms_repcat
dbms_repcat_admin
dbms_repcat_instantiate
dbms_repcat_rgt
dbms_reputil
dbms_resconfig
dbms_resource_manager
dbms_resource_manager_privs
dbms_result_cache
dbms_resumable
dbms_rlmgr
dbms_rls
dbms_rowid
dbms_rule
dbms_rule_adm
dbms_scheduler
dbms_server_alert
dbms_service
dbms_session
dbms_shared_pool
dbms_space
dbms_space_admin
dbms_spm
dbms_sql
dbms_sqldiag
dbms_sqlpa
dbms_sqltune
dbms_stat_funcs
dbms_stats
dbms_storage_map
dbms_streams
dbms_streams_admin
dbms_streams_advisor_adm
dbms_streams_auth
dbms_streams_handler_adm
dbms_streams_messaging
dbms_streams_tablespace_adm
dbms_tdb
dbms_trace
dbms_transaction
dbms_transform
dbms_tts
dbms_types
dbms_utility
dbms_warning
dbms_wm
dbms_workload_capture
dbms_workload_replay
dbms_workload_repository
dbms_xa
dbms_xdb
dbms_xdb_admin
dbms_xdbresource
dbms_xdb_version
dbms_xdbt
dbms_xdbz
dbms_xevent
dbms_xmldom
dbms_xmlgen
dbms_xmlindex
dbms_xmlparser
dbms_xmlquery
dbms_xmlsave
dbms_xmlschema
dbms_xmlstore
dbms_xmltranslations
dbms_xplan
dbms_xslprocessor
debug_extproc
htf
htp
ord_dicom
ord_dicom_admin
owa_cache
owa_cookie
owa_custom
owa_image
owa_opt_lock
owa_pattern
owa_sec
owa_text
owa_util
sdo_cs
sdo_csw_process
sdo_gcdr
sdo_geom
sdo_geor
sdo_geor_admin
sdo_geor_utl
sdo_lrs
sdo_migrate
sdo_net
sdo_net_mem
sdo_ols
sdo_pc_pkg
sdo_sam
sdo_tin_pkg
sdo_topo
sdo_topo_map
sdo_tune
sdo_util
sdo_wfs_lock
sdo_wfs_proc
sem_apis
sem_perf
sem_rdfctx
sem_rdfsa
text_io
utl_coll
utl_compress
utl_dbws
utl_encode
utl_file
utl_http
utl_i18n
utl_inaddr
utl_ident
utl_lms
utl_mail
utl_nla
utl_raw
utl_recomp
utl_ref
utl_smtp
utl_spadv
utl_tcp
utl_url
wpg_docload

Oracle Forms Built-in subprograms

We do not create a missing procedure for a called object with any of the following names:

abort_query
access_into_null
activate_server
add_group_column
add_group_row
add_list_element
add_oleargs
add_parameter
add_tree_data
add_tree_node
application_parameter
bell
blank_count
blank_percent
block_menu
break
call_form
call_input
call_ole
call_ole_char
call_ole_num
call_ole_obj
call_ole_var
cancel_report_object
checkbox_checked
check_record_uniqueness
clear_block
clear_eol
clear_form
clear_item
clear_list
clear_message
clear_record
close_form
close_server
commit_form
convert_other_value
copy
copy_history
copy_region
copy_report_object_output
count_query
create_group
create_group_from_query
create_oleobj
create_parameter_list
create_queried_record
create_record
create_timer
create_var
cut_region
dbms_error_code
dbms_error_text
debug_mode
default_value
delete_group
delete_group_row
delete_list_element
delete_parameter
delete_record
delete_timer
delete_tree_node
destroy_parameter_list
destroy_variant
dispatch_event
display_error
display_item
down
do_key
dummy_reference
duplicate_item
duplicate_record
dup_val_on_index
edit_textitem
enforce_column_security
enter
enter_query
erase
error_code
error_text
error_type
exec_verb
execute_query
execute_trigger
exit
exit_form
fetch_records
find_alert
find_block
find_canvas
find_column
find_editor
find_form
find_group
find_item
find_lov
find_menu_item
find_ole_verb
find_relation
find_report_object
find_tab_page
find_timer
find_tree_node
find_va
find_view
find_window
first_record
form_failure
form_fatal
form_success
forms_ddl
generate_sequence_number
get_application_property
get_block_property
get_canvas_property
get_custom_property
get_file_name
get_form_property
get_group_char_cell
get_group_date_cell
get_group_number_cell
get_group_record_number
get_group_row_count
get_group_selection
get_group_selection_count
get_interface_pointer
get_item_instance_property
get_item_property
get_list_element_count
get_list_element_label
get_list_element_value
get_lov_property
get_menu_item_property
get_message
get_ole_char
get_ole_num
get_ole_obj
get_ole_var
get_olearg_char
get_olearg_num
get_olearg_obj
get_olearg_var
get_ole_memberid
get_parameter_attr
get_parameter_list
get_radio_button_property
get_record_property
get_relation_property
get_report_object_property
get_tab_page_property
get_tree_node_parent
get_tree_node_property
get_tree_property
get_tree_selection
get_va_property
get_var_bounds
get_var_dims
get_var_type
get_verb_count
get_verb_name
get_view_property
get_window_property
go_block
go_form
go_item
go_record
help
hide_menu
hide_view
hide_window
host
id_null
image_scroll
image_zoom
init_oleargs
initialize_container
insert_record
invalid_cursor
invalid_number
issue_rollback
issue_savepoint
item_enabled
item_name
item
last_ole_error
last_ole_exception
last_record
l1_distance
l2_distance
list_values
lock_record
logon
logon_screen
logout
menu_clear_field
menu_next_field
menu_parameter
menu_previous_field
menu_redisplay
menu_show_keys
message
message_code
message_text
message_type
move_window
my_global
my_param
name_in
new_form
next_block
next_form
next_item
next_key
next_menu_item
next_record
next_set
olevar_empty
open_form
paste_region
pause
play_sound
populate_group
populate_group_from_tree
populate_group_with_query
populate_list
populate_tree
post
previous_block
previous_form
previous_item
previous_menu
previous_menu_item
previous_record
print
ptr_to_var
query_parameter
read_image_file
read_sound_file
recalculate
redisplay
release_obj
replace_content_view
replace_menu
report_object_status
reset_group_selection
resize_window
retrieve_list
run_product
run_report_object
scroll_down
scroll_up
scroll_view
select_all
select_records
server_active
set_alert_button_property
set_alert_property
set_application_property
set_block_property
set_canvas_property
set_custom_item_property
set_custom_property
set_form_property
set_group_char_cell
set_group_date_cell
set_group_number_cell
set_group_selection
set_input_focus
set_item_instance_property
set_item_property
set_lov_column_property
set_lov_property
set_menu_item_property
set_ole
set_parameter_attr
set_radio_button_property
set_record_property
set_relation_property
set_report_object_property
set_tab_page_property
set_timer
set_tree_node_property
set_tree_property
set_tree_selection
set_va_property
set_var
set_view_property
set_window_property
show_alert
show_editor
show_keys
show_lov
show_menu
show_view
show_window
synchronize
terminate
to_variant
unset_group_selection
up
update_chart
update_record
user_exit
validate
varptr_to_var
var_to_table
var_to_char
var_to_number
var_to_obj
var_to_varptr
where_display
write_image_file
write_sound_file
height
width
display_position
viewport_x_pos
viewport_y_pos
view_size
viewport_x_pos_on_canvas
viewport_y_pos_on_canvas
form
record
item
no_data_found
true
false

Oracle Forms built-in packages

We do not create a missing procedure for a called object prefixed with:

dde
debug
exec_sql
list
ora_ffi
ora_java
ora_prof
tool_env
tool_err
tool_res
ora_de
plsql_table
stproc
jni
vbx
web
system

Missing tables and procedures

System Objects

Context

System databases

System schemas

System tables

Built-in objects

Built-in functions

Oracle built-in packages

Oracle Forms Built-in subprograms

Oracle Forms built-in packages

com.castsoftware.birt.missingtable

com.castsoftware.cpp.missingtable

com.castsoftware.dotnet.missingtable

com.castsoftware.formsreport.missingtable

com.castsoftware.jee.missingtable

com.castsoftware.mainframe.missingtable

com.castsoftware.nodejs.missingtable

com.castsoftware.python.missingtable

com.castsoftware.rpg.missingtable

com.castsoftware.shell.missingtable