Oracle Predefined Roles All Available List
Oracle Predefined Roles What is user role? An user role is a set of related privileges which are required to perform some aspect of tasks,… Read More »Oracle Predefined Roles All Available List
All Available List
DBMS_SCHEDULER Subprograms All Available List
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 »DBMS_SCHEDULER Subprograms All Available List
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
Linux Time Zones All Available List
Linux Time Zones To know all valid time zones in Linux, we use command timedatectl. You may press Ctrl + d to bookmark this page.… Read More »Linux Time Zones All Available List
Oracle NLS_CHARACTERSET All Available List
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_CHARACTERSET All Available List
Oracle NLS_TERRITORY All Available List
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_TERRITORY All Available List
Oracle NLS_LANGUAGE All Available List
To retrieve all available NLS_LANGUAGE or NLS_DATE_LANGUAGE in Oracle, we execute the following query to get the list. SQL> select value "NLS_LANGUAGE" from v$nls_valid_values where… Read More »Oracle NLS_LANGUAGE All Available List