Sql

Search

how to check nls timestamp 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 :: DUPLICATE column values
Sql :: postgresql division count return 0
Sql :: oracle activate job
Sql :: sql delete stored procedure
Sql :: oracle sql truncate table
Sql :: sql server pagination
Sql :: mysql user permission database
Sql :: sql server roles and users
Sql :: oracle view source
Sql :: sql server for loop
Sql :: change table to innodb mysql
Sql :: sql order by timestamp
Sql :: ALL_TAB_PARTITIONS
Sql :: oracle alter table add not null constraint
Sql :: apex add months to date
Sql :: How Not To Sort By Average Rating
Sql :: select statement to print longest name
Sql :: How to View column names of a table in SQL
Sql :: get first 3 letters in sql
Sql :: mariadb number format
Sql :: mysql sysdate - 1 day
Sql :: oracle ora-00054 resource busy
Sql :: mysql public key retrieval is not allowed
Sql :: ORACLE SHOW AVAILABLE DB LINK
Sql :: org.h2.jdbc.JdbcSQLSyntaxErrorException
Sql :: create table with select
Sql :: mysql config user password
Sql :: mssql how to insert more than 1000 rows
Sql :: mysql order by desc null last
Sql :: blob datatype in mysql

Search

SQL

how to check nls timestamp format in oracle

ADD CONTENT