Answers for "oracle show session parameters"

SQL

4

oracle session parameters

GRANT SELECT_CATALOG_ROLE TO my_user;	-- to read V$PARAMETER 

SELECT NAME, VALUE, DESCRIPTION FROM V$PARAMETER 
--WHERE upper(NAME) = 'NLS_DATE_FORMAT' 
ORDER BY NAME;

ALTER SESSION SET 
	NLS_LANGUAGE='AMERICAN' 
    NLS_TERRITORY='AMERICA' 
    NLS_CALENDAR='GREGORIAN'
    NLS_DATE_FORMAT='DD/MM/YYYY HH24:MI:SS';

Posted by: Guest on July-18-2021

Source

Code answers related to "oracle show session parameters"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#