Skip to Main Content
Ted Struik - Oracle
Search For
Home
Home
Ted Struik - Oracle
Search
Site Map
Statistics
Page Errors
Apex
Apex
General
Autocomplete
Conditions
Errors
Items used in PL/SQL
Validations
Dynamic Actions
Logs
Version
App-wide Items
Error Handling
Apex Views
Apex Upgrade 4.2 to 5.1
Apex Upgrade 20.2 to 23.1
Database Dependencies
Show Source Code
URLs
Authorization
Modal Dialogs
Apex Office Print (AOP)
Apex-Sert
Warn on Unsaved Changes
Form Regions
Reports
Checkboxes
Download
Errors
Nowrap Columns
Substitution Strings
Use IR results in pl/sql
Clickable Row
Row Highlight
Translate Filters etc.
Bar Charts
Column Usage
Reset Pagination
Hide IR Actions menu items
Get Classic Report query
Interactive Grid
ORA-20987
ERR-1002
Copying Text
IG Info
Multiple Row Select
Read Only Options
Search
Sort and Search
Images & Fonts
Standard Icons & Fonts
WebDav
Font Awesome
Icons/image popup LOV
Lists
Hierarchy
LOVs
Definition Bug
Set 1-item LOV to Disabled
With Clause Errors
Modal LOV Plugin
HTML / CSS / JavaScript
Vertical Align
Legend CSS
Geolocation
Apex.confirm
Pie Charts
Codemirror
Theme Roller
Catching Key Strokes
Browser Cache
Locale
RequireJS
Collapsible Regions
Find JavaScript
Import / Export
Dynamic Translations
Translated Pages
APEXExport (java)
apex_export (pl/sql)
Component Settings
Charts
Translate Charts
[Reports] Bar Charts
Shuttles
Shuttle Sorting
Disable Shuttle Items
Menus
Accordion-Like
Scroll bug
Authorization
Session State
About Session State
Rollback & Commit
Performance of v()
Apex Clone Session
Request
Session State in Views
Collections
ORA-20101 & ORA-20104
ORA-00001
Max Row Count
(PL)SQL
(PL)SQL
External Tables
SQL Plus
Conditions
Long
ORDImage
Date & Timestamp
CGI environment
Sys_context
Rounding percentages
Apex_string.split in SQL
Dbms_metadata
Instr
Regular Expressions
Rollback to Savepoint
Use table aliases
(Pipelined) Bulk Collect
JSON
Source Code Search (PL/SQL)
Source Code Search (SQL)
Format Models
Pipelined Table Functions
Hint no_unnest
Listagg
DBA
DBA
Backup & Restore
Users
Export & Import
DBMS Jobs
Tablespaces
Table Size
Flush cache
Access Control List (ACL)
Locks
Java
Constraints
Object Dependencies
Package Dependencies 1
Package Dependencies 2
Grants
SQL History
Startup Errors
ORDS
Miscellaneous
Miscellaneous
Holidays
E-mail
NLExtract
Windows
VPN
VMware
Links
Google
Visualization Orgchart
Hide Search Results
Reverse Proxy
To-do List
Cytoscape
Graphics
Upscaling
Amazon Prices
Domoticz
DDoS
Hobbies
Hobbies
Motorcycles
'95 Kawasaki ZZR 600
'94 Kawasaki ZZR 1100
'91 Honda CBR 600 F2
'95 Kawasaki ZZR 1100
'99 Honda CBR 1100 XX
'00 Honda CBR 1100 XX
'02 Kawasaki ZX-12R (NL)
'05 Ducati 999 (NL)
'08 Honda Fireblade
'07 Suzuki Bandit 1250A
'18 Suzuki GSX-S 1000 F
MotoGP
Garfield
Lyrics
Skydive
Woodworking
Pantorouter
16 inch Bandsaw
Introduction
Frame
Wheels
Wheel mounts
Blade guides
Trunions and table
Enclosure
Alignment and more
Box Joint Jig
Foldable Sawhorses
Strip Sander XL
Photography
Sony RX10 IV
Yes Minister
WinAmp
Info
Report with sys_context/user_env context values.
Info on sys_context:
https://docs.oracle.com/en/database/oracle/oracle-database/23/sqlrf/SYS_CONTEXT.html
Sys_context
Name
Val
ACTION
Processes - point: BEFORE_BOX_BO
AUDITED_CURSORID
AUTHENTICATED_IDENTITY
ORDS_PUBLIC_USER
AUTHENTICATION_DATA
AUTHENTICATION_METHOD
PROXYUSER_AUTHENTICATED_PROXY
BG_JOB_ID
CDB_DOMAIN
CDB_NAME
FREE
CLIENT_IDENTIFIER
:
CLIENT_INFO
1680771009338522:
CLIENT_PROGRAM_NAME
Oracle REST Data Services
CLOUD_SERVICE
CON_ID
3
CON_NAME
FREEPDB1
CURRENT_BIND
CURRENT_EDITION_ID
139
CURRENT_EDITION_NAME
ORA$BASE
CURRENT_SCHEMA
TEDSTRUIK
CURRENT_SCHEMAID
145
CURRENT_SQL
CURRENT_SQLN
CURRENT_SQL_LENGTH
CURRENT_USER
TEDSTRUIK
CURRENT_USERID
145
DATABASE_ROLE
PRIMARY
DBLINK_INFO
DB_DOMAIN
DB_NAME
FREEPDB1
DB_SUPPLEMENTAL_LOG_LEVEL
DB_UNIQUE_NAME
FREE
DRAIN_STATUS
NONE
ENTERPRISE_IDENTITY
ENTRYID
FG_JOB_ID
0
GLOBAL_CONTEXT_MEMORY
0
GLOBAL_UID
HOST
dmz-db-12
IDENTIFICATION_TYPE
LOCAL
INSTANCE
1
INSTANCE_NAME
FREE
IP_ADDRESS
127.0.0.1
ISDBA
FALSE
IS_APPLY_SERVER
FALSE
IS_DG_ROLLING_UPGRADE
FALSE
LANG
US
LANGUAGE
AMERICAN_AMERICA.AL32UTF8
LDAP_SERVER_TYPE
MODULE
TEDSTRUIK/APEX:APP 25384:1051
NETWORK_PROTOCOL
tcp
NLS_CALENDAR
GREGORIAN
NLS_CURRENCY
$
NLS_DATE_FORMAT
YYYY-MM-DD
NLS_DATE_LANGUAGE
AMERICAN
NLS_SORT
BINARY
NLS_TERRITORY
AMERICA
ORACLE_HOME
/opt/oracle/product/23ai/dbhomeFree
OS_USER
tomcat
PID
80
PLATFORM_SLASH
/
POLICY_INVOKER
PROXY_ENTERPRISE_IDENTITY
PROXY_USER
ORDS_PUBLIC_USER
PROXY_USERID
141
SCHEDULER_JOB
N
SERVER_HOST
dmz-db-12
SERVICE_NAME
freepdb1
SESSIONID
19264039
SESSION_DEFAULT_COLLATION
SESSION_EDITION_ID
139
SESSION_EDITION_NAME
ORA$BASE
SESSION_USER
APEX_PUBLIC_USER
SESSION_USERID
135
SID
4
STANDBY_MAX_DATA_DELAY
STATEMENTID
TERMINAL
unknown
TLS_CIPHERSUITE
TLS_VERSION
UNIFIED_AUDIT_SESSIONID
59020469919140595
row(s) 1 - 79 of 79
Code
Page
Identification
Page ID
1051
Name
(PL)SQL - Sys_context
Region
Identification
Sequence
-979
Title
Sys_context
Type
Report
Source
Source Type
SQL_QUERY
Region Source
select res.* from (select * from (select sys_context('userenv', 'ACTION') as action ,sys_context('userenv', 'AUDITED_CURSORID') as audited_cursorid ,sys_context('userenv', 'AUTHENTICATED_IDENTITY') as authenticated_identity ,sys_context('userenv', 'AUTHENTICATION_DATA') as authentication_data ,sys_context('userenv', 'AUTHENTICATION_METHOD') as authentication_method ,sys_context('userenv', 'BG_JOB_ID') as bg_job_id ,sys_context('userenv', 'CDB_DOMAIN') as cdb_domain ,sys_context('userenv', 'CDB_NAME') as cdb_name ,sys_context('userenv', 'CLIENT_IDENTIFIER') as client_identifier ,sys_context('userenv', 'CLIENT_INFO') as client_info ,sys_context('userenv', 'CLIENT_PROGRAM_NAME') as client_program_name ,sys_context('userenv', 'CLOUD_SERVICE') as cloud_service ,sys_context('userenv', 'CON_ID') as con_id ,sys_context('userenv', 'CON_NAME') as con_name ,sys_context('userenv', 'CURRENT_BIND') as current_bind ,sys_context('userenv', 'CURRENT_EDITION_ID') as current_edition_id ,sys_context('userenv', 'CURRENT_EDITION_NAME') as current_edition_name ,sys_context('userenv', 'CURRENT_SCHEMA') as current_schema ,sys_context('userenv', 'CURRENT_SCHEMAID') as current_schemaid ,sys_context('userenv', 'CURRENT_SQL') as current_sql ,sys_context('userenv', 'CURRENT_SQL_LENGTH') as current_sql_length ,sys_context('userenv', 'CURRENT_SQLn') as current_sqln ,sys_context('userenv', 'CURRENT_USER') as current_user ,sys_context('userenv', 'CURRENT_USERID') as current_userid ,sys_context('userenv', 'DATABASE_ROLE') as database_role ,sys_context('userenv', 'DBLINK_INFO') as dblink_info ,sys_context('userenv', 'DB_DOMAIN') as db_domain ,sys_context('userenv', 'DB_NAME') as db_name ,sys_context('userenv', 'DB_SUPPLEMENTAL_LOG_LEVEL') as db_supplemental_log_level ,sys_context('userenv', 'DB_UNIQUE_NAME') as db_unique_name ,sys_context('userenv', 'DRAIN_STATUS') as drain_status ,sys_context('userenv', 'ENTERPRISE_IDENTITY') as enterprise_identity ,sys_context('userenv', 'ENTRYID') as entryid ,sys_context('userenv', 'FG_JOB_ID') as fg_job_id ,sys_context('userenv', 'GLOBAL_CONTEXT_MEMORY') as global_context_memory ,sys_context('userenv', 'GLOBAL_UID') as global_uid ,sys_context('userenv', 'HOST') as host ,sys_context('userenv', 'IDENTIFICATION_TYPE') as identification_type ,sys_context('userenv', 'INSTANCE') as instance ,sys_context('userenv', 'INSTANCE_NAME') as instance_name ,sys_context('userenv', 'IP_ADDRESS') as ip_address ,sys_context('userenv', 'ISDBA') as isdba ,sys_context('userenv', 'IS_APPLY_SERVER') as is_apply_server ,sys_context('userenv', 'IS_DG_ROLLING_UPGRADE') as is_dg_rolling_upgrade ,sys_context('userenv', 'LANG') as lang ,sys_context('userenv', 'LANGUAGE') as language ,sys_context('userenv', 'LDAP_SERVER_TYPE') as ldap_server_type ,sys_context('userenv', 'MODULE') as module ,sys_context('userenv', 'NETWORK_PROTOCOL') as network_protocol ,sys_context('userenv', 'NLS_CALENDAR') as nls_calendar ,sys_context('userenv', 'NLS_CURRENCY') as nls_currency ,sys_context('userenv', 'NLS_DATE_FORMAT') as nls_date_format ,sys_context('userenv', 'NLS_DATE_LANGUAGE') as nls_date_language ,sys_context('userenv', 'NLS_SORT') as nls_sort ,sys_context('userenv', 'NLS_TERRITORY') as nls_territory ,sys_context('userenv', 'ORACLE_HOME') as oracle_home ,sys_context('userenv', 'OS_USER') as os_user ,sys_context('userenv', 'PID') as pid ,sys_context('userenv', 'PLATFORM_SLASH') as platform_slash ,sys_context('userenv', 'POLICY_INVOKER') as policy_invoker ,sys_context('userenv', 'PROXY_ENTERPRISE_IDENTITY') as proxy_enterprise_identity ,sys_context('userenv', 'PROXY_USER') as proxy_user ,sys_context('userenv', 'PROXY_USERID') as proxy_userid ,sys_context('userenv', 'SCHEDULER_JOB') as scheduler_job ,sys_context('userenv', 'SERVER_HOST') as server_host ,sys_context('userenv', 'SERVICE_NAME') as service_name ,sys_context('userenv', 'SESSIONID') as sessionid ,sys_context('userenv', 'SESSION_DEFAULT_COLLATION') as session_default_collation ,sys_context('userenv', 'SESSION_EDITION_ID') as session_edition_id ,sys_context('userenv', 'SESSION_EDITION_NAME') as session_edition_name ,sys_context('userenv', 'SESSION_USER') as session_user ,sys_context('userenv', 'SESSION_USERID') as session_userid ,sys_context('userenv', 'SID') as sid ,sys_context('userenv', 'STANDBY_MAX_DATA_DELAY') as standby_max_data_delay ,sys_context('userenv', 'STATEMENTID') as statementid ,sys_context('userenv', 'TERMINAL') as terminal ,sys_context('userenv', 'TLS_CIPHERSUITE') as tls_ciphersuite ,sys_context('userenv', 'TLS_VERSION') as tls_version ,sys_context('userenv', 'UNIFIED_AUDIT_SESSIONID') as unified_audit_sessionid from dual ) unpivot include nulls(val for name in(action ,audited_cursorid ,authenticated_identity ,authentication_data ,authentication_method ,bg_job_id ,cdb_domain ,cdb_name ,client_identifier ,client_info ,client_program_name ,cloud_service ,con_id ,con_name ,current_bind ,current_edition_id ,current_edition_name ,current_schema ,current_schemaid ,current_sql ,current_sql_length ,current_sqln ,current_user ,current_userid ,database_role ,dblink_info ,db_domain ,db_name ,db_supplemental_log_level ,db_unique_name ,drain_status ,enterprise_identity ,entryid ,fg_job_id ,global_context_memory ,global_uid ,host ,identification_type ,instance ,instance_name ,ip_address ,isdba ,is_apply_server ,is_dg_rolling_upgrade ,lang ,language ,ldap_server_type ,module ,network_protocol ,nls_calendar ,nls_currency ,nls_date_format ,nls_date_language ,nls_sort ,nls_territory ,oracle_home ,os_user ,pid ,platform_slash ,policy_invoker ,proxy_enterprise_identity ,proxy_user ,proxy_userid ,scheduler_job ,server_host ,service_name ,sessionid ,session_default_collation ,session_edition_id ,session_edition_name ,session_user ,session_userid ,sid ,standby_max_data_delay ,statementid ,terminal ,tls_ciphersuite ,tls_version ,unified_audit_sessionid))) res