Skip to content
Saturday, January 28, 2023
Database Learners
Menu
  • About Database
  • Oracle
    • ASM
    • Data Pump
    • Backup and Recovery
    • Patching and Upgradation
    • Performance Tuning
    • Data Guard
    • Real Application Cluster
    • Golden Gate
    • PL/SQL
  • MySQL
  • PostgreSQL
  • MongoDB
  • MS SQL Server
  • SQL
  • Linux
  • About Me
  • Contact Us
  • Home
  • 2015
  • February
  • How to check nls_characterset parameter of database

How to check nls_characterset parameter of database

Oracle
18 August 202018 August 2020 Administrator

SQL> SELECT value$ FROM sys.props$ WHERE name = ‘NLS_CHARACTERSET’;

VALUE$

WE8ISO8859P1

SQL> SELECT value$ FROM sys.props$ WHERE name = ‘NLS_NCHAR_CHARACTERSET’;

VALUE$

AL16UTF16

Share this post: on Twitter on Facebook on Google+

Post Views: 410

Post navigation

Find the sql and tables which are performing full table scan (FTS)
How to genrate awr report
Administrator

http://www.databaselearners.com

Related Posts

Flash Recovery Area(10g) / Fast Recovery Area(11gR2)

19 March 201520 August 2020 Administrator

Be careful what you count for and you might get it.

17 March 201520 August 2020 Administrator

TZ parameter & sysdate

12 March 201520 August 2020 Administrator

Recent Posts

  • How to Optimize MySQL Tables and Defragment to Recover Space
  • ORA-01031: Insufficient Privileges When Connect As Sysdba
  • Oracle RAC log files locations
  • Drop all tables in Oracle DB (Schema)
  • How to Determine If the Oracle Redo Log File Size Is a Problem

Categories

  • ASM (40)
  • Backup and Recovery (52)
  • Data Guard (36)
  • Data Pump (28)
  • DB Scripts (26)
  • General (1)
  • Golden Gate (7)
  • Interview Questions (24)
  • Linux (86)
  • MS SQL Server (8)
  • MySQL (120)
  • ORA-Errors (45)
  • Oracle (301)
  • Oracle 10g (19)
  • Oracle 11g (24)
  • Oracle 12c (9)
  • Oracle RAC (101)
  • Oracle XE (7)
  • Patching and Upgradation (19)
  • Performance Tuning (61)
  • PL/SQL (26)
  • RMAN (85)
  • SQL (32)

Visitors

  • 0
  • 7
  • 48,824

Reference Links:

  • https://docs.oracle.com/en/database/index.html
  • https://dev.mysql.com/doc/
  • https://docs.mongodb.com/manual/
  • https://docs.microsoft.com/en-us/sql/sql-server/?view=sqlallproducts-allversions
  • https://www.postgresql.org/docs/current/
@2021 databaselearners.com | Theme: BlogMagazine by Dinesh Ghimire.