All Available List

DBMS_SCHEDULER Subprograms All Available List

by Ed Chen
March 16, 2022June 14, 2022

PACKAGE DBMS_SCHEDULER I found that some subprograms of DBMS_SCHEDULER package are no listed in the Oracle documentation. However, we get the complete list by describing… Read More »

Oracle Time Zones All Available List

by Ed Chen
November 2, 2020June 14, 2022

Here we list all available time zone in Oracle database 19c by the following two orders. Order by Time Zone Region Order by Time Zone… Read More »

Linux Time Zones All Available List

by Ed Chen
August 10, 2020June 14, 2022

Linux Time Zones To know all valid time zones in Linux, we use command timedatectl. [root@test ~]# timedatectl list-timezones Africa/Abidjan Africa/Accra Africa/Addis_Ababa Africa/Algiers Africa/Asmara Africa/Bamako… Read More »

Oracle NLS_CHARACTERSET All Available List

by Ed Chen
September 10, 2019June 14, 2022

To retrieve all available NLS_CHARACTERSET in Oracle, we execute the following query to get the list. SQL> select value "NLS_CHARACTERSET" from v$nls_valid_values where parameter =… Read More »

Oracle NLS_TERRITORY All Available List

by Ed Chen
September 9, 2019June 14, 2022

To retrieve all available NLS_TERRITORY in Oracle, we execute the following query to get the list. SQL> select value "NLS_TERRITORY" from v$nls_valid_values where parameter =… Read More »

Oracle NLS_LANGUAGE All Available List

by Ed Chen
September 8, 2019June 14, 2022

To retrieve all available NLS_LANGUAGE in Oracle, we execute the following query to get the list. SQL> select value "NLS_LANGUAGE" from v$nls_valid_values where parameter =… Read More »