How to Check Session Time Zone
SESSIONTIMEZONE While DBTIMEZONE is to check the database time zone, the built-in function SESSIONTIMEZONE is to check the exact time zone in the current session.… Read More »How to Check Session Time Zone
NLS_TIMESTAMP_TZ_FORMAT
NLS_SESSION_PARAMETERS, How and Why
What is NLS_SESSION_PARAMETERS ? NLS_SESSION_PARAMETERS is a dictionary view which shows all current NLS parameters of an user's session. Let's see their values. SQL> set… Read More »NLS_SESSION_PARAMETERS, How and Why
NLS_INSTANCE_PARAMETERS, How and Why
What is NLS_INSTANCE_PARAMETERS ? NLS_INSTANCE_PARAMETERS is a dictionary view which shows default NLS parameters of an instance. Let's see their values. SQL> set pagesize 1000;… Read More »NLS_INSTANCE_PARAMETERS, How and Why
NLS_DATABASE_PARAMETERS, How and Why
What is NLS_DATABASE_PARAMETERS ? NLS_DATABASE_PARAMETERS is a dictionary view which shows default NLS parameters of a database. Let's see their values. SQL> set pagesize 1000;… Read More »NLS_DATABASE_PARAMETERS, How and Why