Skip to content
Friday, June 02, 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
  • 2020
  • August
  • 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: 475

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

Setting an Oracle Environment variable – ORACLE_HOME

13 March 201520 August 2020 Administrator

ALTER SYSTEM SWITCH LOGFILE vs ALTER SYSTEM ARCHIVELOG CURRENT

19 August 202019 August 2020 Administrator

SHMALL , SHMMAX , SEMMNI, SEMMNS, SEMMNS

18 August 202018 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
  • 5
  • 55,464

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.