Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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 
ADD CONTENT
Topic
Content
Source link
Name
8+6 =