Sql

Search

how to check nls format in oracle

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 :: oracle get nls settings
Sql :: list all tables and columns in postgresql
Sql :: psql human readable
Sql :: hw to delete a procedure in pl sql
Sql :: delete all rows from table sql
Sql :: mysql month name extract
Sql :: my sql version
Sql :: sql server list user permissions
Sql :: mysql current user
Sql :: postgres get database encoding
Sql :: async await mysql nodejs
Sql :: search query in mysql
Sql :: how to see all table partition in oracle
Sql :: how to change owner in postgres
Sql :: oracle current date plus 1 month
Sql :: mysql search like order by best match
Sql :: drop primary key
Sql :: Oracle Column Names of a table
Sql :: datetime add 2 hours sql
Sql :: mysql number format
Sql :: mysql sysdate
Sql :: oracle ora-00054 find
Sql :: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
Sql :: t sql check active deadlock
Sql :: org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
Sql :: restore postgres database from sql file
Sql :: psql show columns of table
Sql :: sql server current date
Sql :: Select last row from SQL Table
Sql :: sql create index

Search

SQL

how to check nls format in oracle

ADD CONTENT