SET_NLS_SESSION_PARAMETERS - Perceptive Content Database IN_DB_UTIL Package for Oracle Server - Foundation 24.1 - Foundation 24.1 - Ready - Perceptive Content - external

The SET_NLS_SESSION_PARAMETERS stored procedure is used to set the following standard Perceptive Content NLS and optimizer session parameters.

ALTER SESSION SET NLS_COMP = LINGUISTIC; 
ALTER SESSION SET NLS_SORT = BINARY_CI; 
ALTER SESSION SET NLS_TIMESTAMP_FORMAT = 'RRRR-MM-DD HH24:MI:SS.FF'; 
ALTER SESSION SET NLS_TIME_FORMAT = 'HH24:MI:SS.FF'; 
ALTER SESSION SET NLS_DATE_FORMAT = 'RRRR-MM-DD'; 
ALTER SESSION SET OPTIMIZER_MODE = 'ALL_ROWS'; 
ALTER SESSION SET QUERY_REWRITE_INTEGRITY = 'TRUSTED'; 
ALTER SESSION SET QUERY_REWRITE_ENABLED = 'TRUE'; 
ALTER SESSION SET CURSOR_SHARING = 'EXACT'; 
ALTER SESSION SET OPTIMIZER_INDEX_COST_ADJ = 100;

Exception

• OTHERS

Example

EXEC IN_DB_UTIL.SET_NLS_SESSION_PARAMETERS;