Sql

Search

oracle get nls settings

SELECT *
FROM (SELECT 'SESSION' SCOPE, nsp.* FROM NLS_SESSION_PARAMETERS nsp
      UNION ALL
      SELECT 'DATABASE' SCOPE, ndp.* FROM NLS_DATABASE_PARAMETERS ndp
      UNION ALL
      SELECT 'INSTANCE' SCOPE, nip.* FROM NLS_INSTANCE_PARAMETERS nip) a
PIVOT (listagg(VALUE) WITHIN GROUP (ORDER BY SCOPE) FOR SCOPE IN (
    'SESSION' AS "SESSION" ,'DATABASE' AS DATABASE ,'INSTANCE' AS INSTANCE));
-- ⇓ Test it ⇓ (Fiddle source link)

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql full outer join java
Sql :: apex ORA-20999
Sql :: install mysql in amazon linux 2
Sql :: mysql add comment to column
Sql :: update substring in mysql
Sql :: mysqldump csv
Sql :: mysql insert generate serie
Sql :: how to insert string variable into sqlite database
Sql :: oracle export view ddl
Sql :: postgresql transaction discard all
Sql :: update in sql
Sql :: inner join just one row
Sql :: oracle limit user tablespace
Sql :: select sql in descending order
Sql :: oracle add months to sysdate
Sql :: différence entre deux dates sql oracle
Sql :: copy one column data to another in sql
Sql :: find most frequent value in sql column
Sql :: get first 3 letter of department name in sql
Sql :: mysql select last row for each group
Sql :: mysql all columns
Sql :: ora-00054 resource busy and acquire with nowait
Sql :: sql last 3 rows
Sql :: select all field names for a table mysql
Sql :: this week mysql
Sql :: XOR in SQL Server
Sql :: how to change mysql root password in windows 10
Sql :: sql create table primary key autoincrement
Sql :: sqlite drop table
Sql :: sql query to search for a string in all columns

Search

SQL

oracle get nls settings

ADD CONTENT