Oracle NLS / National Language Suppport

Bino Kochumol Varghese / October 23, 2022

The nls_database_parameters shows the values of the NLS parameters for the database. Oracle notes these differences between the parameters.

NLS_SESSION_PARAMETERS shows the NLS parameters and their values for the session that is querying the view. It does not show information about the character set.
NLS_INSTANCE_PARAMETERS shows the current NLS instance parameters that have been explicitly set and the values of the NLS instance parameters.
NLS_DATABASE_PARAMETERS shows the values of the NLS parameters for the database. The values are stored in the database.

SELECT * FROM nls_session_parameters ORDER BY 1;   
SELECT * FROM nls_instance_parameters ORDER BY 1;  
SELECT * FROM nls_database_parameters ORDER BY 1;

The NLS_LANGUAGE and NLS_TERRITORY values in nls_database_parameters cannot be changed once the database has been created

References

dba-oracle
Oracle Blog

pl-sql database

Read More

DIRECTORY Objects in plsql

Bino Kochumol Varghese / March 2, 2023

Catalog views are provided for DIRECTORY objects to enable users to view object names and corresponding paths and privileges.

Read more

Oracle Timestamp

Oracle Timestamp

Bino Kochumol Varghese / December 21, 2022

The TIMESTAMP datatype is an extension on the DATE datatype. In addition to the datetime elements of the DATE datatype, the TIMESTAMP datatype holds fractions of a second to a precision between zero and nine decimal places, the default being six. There are also two variants called TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE. As their names imply, these timestamps also store time zone offset information.

create table table_name (
    column_name number,
    column_name2 timestamp default systimestamp);

Reference

dba-oracle dba-oracle 2

Read more

Drop table in PL SQL

Bino Kochumol Varghese / October 25, 2022

PL SQL Query to list the currently running jobs.

Read more