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

System tables

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

dummy
sysdummy
sysdummy1
sysdummye
sysdummya
sysdummyu
dual
pg_available_extensions
pg_available_extension_versions
pg_class
pg_constraint
pg_cursors
pg_file_settings
pg_group
pg_indexes
pg_locks
pg_matviews
pg_namespace
pg_policies
pg_prepared_statements
pg_prepared_xacts
pg_replication_origin_status
pg_replication_slots
pg_roles
pg_rules
pg_seclabels
pg_settings
pg_shadow
pg_stats
pg_stat_all_tables
pg_tables
pg_timezone_abbrevs
pg_timezone_names
pg_user
pg_user_mappings
pg_views
session_privs
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
access_into_null
acos
add_days
add_months
adddate
addtime
admin_task_list
admin_task_output
admin_task_status
aes_decrypt
aes_encrypt
ai_analogy
ai_generate_chunks
ai_generate_embeddings
ai_semantic_cluster
ai_similarity
all_rows
and
any_value
anydata
anydataset
anytype
app_name
append
append_values
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
array_agg
array_append
array_cat
array_delete
array_dims
array_fill
array_first
array_last
array_length
array_lower
array_ndims
array_next
array_prepend
array_prior
array_remove
array_replace
array_shuffle
array_to_json
array_to_string
array_trim
array_upper
ascii
ascii_str
asciistr
asin
assemblyproperty
asymkey_id
asymkeyproperty
atan
atan2
atanh
atn2
avg
base64decode
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
bit
bit_and
bit_and_agg
bit_count
bit_length
bit_or
bit_or_agg
bit_xor
bit_xor_agg
bitand
bitandnot
bitmap_bit_position
bitmap_bucket_number
bitmap_construct_agg
bitmap_count
bitmap_or_agg
bitnot
bitor
bitxor
blob
blocking_threads
boolean_and_agg
boolean_or_agg
btrim
cache
can_access_column
can_access_database
can_access_table
can_access_user
can_access_view
cardinality
case
case_not_found
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
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
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
connect_by_isleaf
connect_by_root
connection_id
containers
contains
containstable
conv
convert
convert_from
convert_to
convert_tz
corr
corr_k
corr_s
correlation
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
curdate
current_date
current_role
current_schema
current_time
current_timestamp
current_user
currentpermspace
currval
cursor_already_open
cursor_sharing_exact
cursor_status
curtime
cv
data
database
database_principal_id
databasenamei
databasepropertyex
databasespace
datalength
dataobj_to_mat_partition
dataobj_to_partition
date
date_add
date_bucket
date_format
date_sub
date_trunc
dateadd
datediff
datediff_big
datefromparts
datename
datepart
datetime
datetime2
datetime2fromparts
datetimefromparts
datetimeoffset
datetimeoffsetfromparts
datetrunc
day
dayname
dayofmonth
dayofweek
dayofweek_iso
dayofyear
days
days_between
db_id
db_name
dbase
dbclob
dbtimezone
dburitype
dec
decfloat
decfloat_format
decfloat_sortkey
decimal
decode
decode_oracle
decompose
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
decryptbyasymkey
decryptbycert
decryptbykey
decryptbykeyautoasymkey
decryptbykeyautocert
decryptbypassphrase
default
degrees
delete
deleted
dense_rank
depth
deref
difference
digits
disable_parallel_dml
div
domain_check
domain_check_type
domain_display
domain_name
domain_order
double
double_precision
driving_site
dsn_xmlvalidate
dump
dup_val_on_index
dynamic_sampling
ebcdic_chr
ebcdic_str
edge_id_from_parts
edit_distance
edit_distance_similarity
element_number
elt
empty_blob
empty_clob
enable_parallel_dml
encode
encrypt
encrypt_datakey
encrypt_tdes
encryptbyasymkey
encryptbycert
encryptbykey
encryptbypassphrase
eomonth
error_line
error_message
error_number
error_procedure
error_severity
error_state
every
exist
exists
existsnode
exp
export_set
extend
extract
extractvalue
fact
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
find_in_set
first
first_rows
first_value
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
format
format_bytes
format_pico_time
found_rows
freetexttable
fresh_mv
from_base64
from_days
from_tz
from_unixtime
from_vector
full
fulltextcatalogproperty
fulltextserviceproperty
fuzzy_match
gather_optimizer_statistics
generate_series
generate_subscripts
generate_unique
generate_unique_binary
geomcollection
geometrycollection
get_bit
get_blob_from_file
get_byte
get_clob_from_file
get_dbclob_from_file
get_dd_column_privileges
get_dd_create_options
get_dd_index_sub_part_length
get_format
get_lock
get_xml_file
getblobval
getclobval
getdate
getfilenamespacepath
gethint
getnamespace
getnumberval
getpathlocator
getrootelement
getschemaurl
getstringval
getutcdate
getvariable
graph_id_from_edge_id
graph_id_from_node_id
graph_table
graphic
graphql
greatest
group_concat
group_id
grouping
grouping_id
gtid_subset
gtid_subtract
has_perms_by_name
hash
hash_crc32
hash_md5
hash_sha1
hash_sha256
hashbytes
hex
hextoraw
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
icu_version
identity_val_local
if
ifnull
ignore_row_on_dupkey_index
iif
in
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
int
integer
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
interval
invalid_client_file_dir
invalid_cursor
invalid_number
is
is_free_lock
is_ipv4
is_ipv4_compat
is_ipv4_mapped
is_ipv6
is_member
is_rolemember
is_srvrolemember
is_used_lock
is_uuid
isdate
isfragment
isjson
isnull
isnumeric
isschemabased
isschemavalid
isschemavalidated
iteration_number
ivf_iteration
jaro_winkler_distance
jaro_winkler_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_pop
kurtosis_samp
l1_distance
l2_distance
lag
last
last_day
last_insert_id
last_value
lastval
lcase
lead
lead1
leading
least
left
left_shift
len
length
level
like
limit
linestring
listagg
ln
lnnvl
load_file
localtime
localtimestamp
locate
locate_in_string
log
log10
log2
login_denied
loginproperty
long
lower
lpad
ltrim
make_ref
make_set
makedate
maketime
master_pos_wait
match
matchnum
max
max_cardinality
mbrcontains
mbrcoveredby
mbrcovers
mbrdisjoint
mbrequals
mbrintersects
mbroverlaps
mbrtouches
mbrwithin
md5
median
merge
microsecond
mid
midnight_seconds
min
minute
mod
model_min_analysis
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
nclob
new_time
newid
next
next_day
next_month
nextval
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
normalize_decfloat
normalize_string
not
not_logged_on
now
nth_value
ntile
null
nullif
numtodsinterval
numtoyminterval
nvarchar
nvarchar2
nvl
nvl2
object_definition
object_id
object_id_from_edge_id
object_id_from_node_id
object_name
object_schema_name
object_value
objectproperty
objectpropertyex
oct
octet_length
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
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
pivot
pls_integer
point
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
print
prior
program_error
property_exists
ps_current_thread_id
ps_thread_id
push_pred
push_subq
pwdcompare
pwdencrypt
px_join_filter
qb_name
quantize
quarter
query
quote
quote_ident
quote_literal
quote_nullable
quotename
radians
raise
raise_application_error
raise_error
raiserror
rand
random
random_bytes
rank
ratio_to_report
raw_to_uuid
rawtohex
rawtonhex
readtext
real
ref
reference
reftohex
regexp
regexp_count
regexp_instr
regexp_like
regexp_matches
regexp_replace
regexp_split_to_array
regexp_split_to_table
regexp_substr
regr_avgx
regr_avgy
regr_count
regr_icpt
regr_intercept
regr_r2
regr_slope
regr_sxx
regr_sxy
regr_syy1
relation
release_all_locks
release_lock
remainder
repeat
replace
replicate
result_cache
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
schema
schema_id
schema_name
schemavalidate
scn_to_timestamp
scope_identity
score
sdo_geometry
sdo_georaster
sdo_topo_geometry
sec_to_time
second
self
self_is_nul
semantickeyphrasetable
semanticsimilaritydetailstable
semanticsimilaritytable
serverproperty
session_user
sessiontimezone
set
set_bit
set_byte
setschemavalidated
setseed
setval
sha
sha1
sha2
shard_chunk_id
sign
sin
sinh
skewness_pop
skewness_samp
sleep
smalldatetime
smalldatetimefromparts
smallint
soaphttpc
soaphttpnc
soaphttpnv
soaphttpv
soundex
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
split_part
sql
sqlcode
sqlerrm
sqrt
square
st_area
st_asbinary
st_asgeojson
st_astext
st_aswkb
st_aswkt
st_buffer
st_buffer_strategy
st_centroid
st_collect
st_contains
st_convexhull
st_crosses
st_difference
st_dimension
st_disjoint
st_distance
st_distance_sphere
st_endpoint
st_envelope
st_equals
st_exteriorring
st_frechetdistance
st_geohash
st_geomcollfromtext
st_geomcollfromwkb
st_geometrycollectionfromtext
st_geometrycollectionfromwkb
st_geometryn
st_geometrytype
st_geomfromgeojson
st_geomfromtext
st_geomfromwkb
st_hausdorffdistance
st_interiorringn
st_intersection
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_mlinefromtext
st_mlinefromwkb
st_mpointfromtext
st_mpointfromwkb
st_mpolyfromtext
st_mpolyfromwkb
st_multilinestringfromtext
st_multilinestringfromwkb
st_multipointfromtext
st_multipointfromwkb
st_multipolygonfromtext
st_multipolygonfromwkb
st_numgeometries
st_numinteriorring
st_numinteriorrings
st_numpoints
st_overlaps
st_pointatdistance
st_pointfromgeohash
st_pointfromtext
st_pointfromwkb
st_pointn
st_polyfromtext
st_polyfromwkb
st_polygonfromtext
st_polygonfromwkb
st_simplify
st_srid
st_startpoint
st_swapxy
st_symdifference
st_touches
st_transform
st_union
st_validate
st_within
st_x
st_y
standard_hash
star_transformation
starts_with
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
str
str_to_date
strcmp
string
string_agg
string_escape
string_split
string_to_array
strip
strleft
strpos
strright
stuff
subdate
subscript_beyond_count
subscript_outside_limit
substr
substring
substring_index
subtime
sum
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
systimestamp
sysutcdatetime
table
tan
tanh
tertiary_weights
textptr
textvalid
the
time
time_bucket
time_format
time_to_sec
timediff
timefromparts
timeout_on_resource
timestamp
timestamp_format
timestamp_iso
timestamp_to_scn
timestamp_tz
timestampadd
timestampdiff
to_approx_count_distinct
to_approx_percentile
to_ascii
to_base64
to_binary_double
to_binary_float
to_blob
to_boolean
to_char
to_clob
to_date
to_days
to_dsinterval
to_hex
to_json
to_jsonb
to_lob
to_multi_byte
to_nchar
to_nclob
to_number
to_seconds
to_single_byte
to_timestamp
to_timestamp_tz
to_tsquery
to_tsvector
to_utc_timestamp_tz
to_vector
to_yminterval
todatetimeoffset
too_many_rows
toobject
top
totalorder
transform
translate
treat
trim
trim_array
true
trunc
trunc_timestamp
truncate
try_cast
try_convert
try_parse
ts_headline
ts_rank
ts_rank_cd
tsvector_update_trigger
tvm
tvmnamei
type
type_id
type_name
typeproperty
tz_offset
ucase
uid
unbounded
uncompress
uncompressed_length
unhex
unicode
unicode_str
unistr
unix_timestamp
unnest
unpack
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_to_bin
uuid_to_raw
validate_conversion
validate_password_strength
value
value_error
values
var
var_pop
var_samp
varbinary
varchar
varchar2
varchar9
varchar_format
vargraphic
variable
variance
variance_samp
varp
vector
vector_chunks
vector_dimension_count
vector_dimension_format
vector_dims
vector_distance
vector_embedding
vector_norm
vector_normalize
vector_serialize
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
week
week_iso
weekday
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
xmlisvalid
xmlmodify
xmlnamespaces
xmlparse
xmlpatch
xmlpi
xmlquery
xmlrow
xmlsequence
xmlserialize
xmltable
xmltext
xmltransform
xmltype
xmlxsrobjectid
xor
xp_cmdshell
xp_enumgroups
xp_logininfo
xsltransform
year
yearweek
zero_divide

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
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_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