How to Change Session Time Zone
TIME_ZONE In the previous post, we have checked the time zone in the current session. Now the question is, how to change it? if it… Read More »How to Change Session Time Zone
Globalization
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
How to Check Database Time Zone
DBTIMEZONE There're 2 ways to check the time zone of a database. Database Property Since DBTIMEZONE is actually a property of database, we may query… Read More »How to Check Database Time Zone
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
NLS_DATE_FORMAT, How and Why
NLS_DATE_FORMAT defines the display format of a datetime string, which can be set at various levels to meet business requirements. That is to say, NLS_DATE_FORMAT… Read More »NLS_DATE_FORMAT, How and Why
Garbled Text in PL/SQL Developer
Garbled Text We saw unreadable result in PL/SQL Developer after we INSERT INTO 3 rows and SELECT the table. We checked the language of this… Read More »Garbled Text in PL/SQL Developer
How to Resolve DataPatch Error at line 0: Could not open logfile
apply: WITH ERRORS When we are close to the end of datapatch, we saw an OS error: Error at line 0: Could not open logfile.… Read More »How to Resolve DataPatch Error at line 0: Could not open logfile
Oracle Time Zones All Available List
Here we list all available time zone in Oracle database 19c by the following two orders. You may press Ctrl + d to bookmark this… Read More »Oracle Time Zones All Available List