Garbled Text in PL/SQL Developer
Garbled Text We saw unreadable result in PL/SQL Developer after we INSERT INTO 3 rows and SELECT the table. We checked the language of this… Read More »Garbled Text in PL/SQL Developer
NLS_LANG
How to Resolve DataPatch Error at line 0: Could not open logfile
apply: WITH ERRORS When we are close to the end of datapatch, we saw an OS error: Error at line 0: Could not open logfile.… Read More »How to Resolve DataPatch Error at line 0: Could not open logfile
How to Fix Garbled Filename and Text
There're several ways to display your garbled filename correctly. LANG Environment Variable PuTTY Character Set Rename Badly Encoded Filename A. LANG Environment Variable Tried to… Read More »How to Fix Garbled Filename and Text
NLS_TERRITORY to NLS_DATE_FORMAT Mapping Table
NLS_TERRITORY to NLS_DATE_FORMAT Here in this post is the mapping table for showing NLS_TERRITORY to their respective NLS_DATE_FORMAT. In some situations, you may need this… Read More »NLS_TERRITORY to NLS_DATE_FORMAT Mapping Table
NLS_LANGUAGE to NLS_TERRITORY Mapping Table
NLS_LANGUAGE to NLS_TERRITORY Here in this post is the mapping table for showing NLS_LANGUAGE to their respective NLS_TERRITORY. In some situations, you may need this… Read More »NLS_LANGUAGE to NLS_TERRITORY Mapping Table
NLS_LANG, How and Why
In this post, I'll talk about 3 major topics about NLS_LANG. What is NLS_LANG? How to Set NLS_LANG in Oracle? What are Available Values of… Read More »NLS_LANG, How and Why
How to Resolve ORA-12705 Error Message
ORA-12705: invalid or unknown NLS parameter value specified ORA-12705 tells you that your NLS settings are not correct, you have to fix them first before… Read More »How to Resolve ORA-12705 Error Message
ORA-12705: NLSデータファイルにアクセスできないか、無効な環境が指定されましたの解決方法
ORA-12705では、NLS設定が正しくないことを示しています。データベースに対して何かを実行する前に、まずそれらを修正する必要があります。 この投稿にはORA-12705の2つのエラーパターンがあります。 接続前のORA-12705 接続後のORA-12705 接続前のORA-12705 データベースに接続する前に故意に偽のNLS_LANGを設定しましょう。これは、Oracleが使用するために選択する環境変数です。NLS_LANGの形式については、NLS_LANG方法と理由を確認できます。 [oracle@test ~]$ export NLS_LANG=JAPAN_JAPAN.UTF8 [oracle@test ~]$ echo $NLS_LANG JAPAN_JAPAN.UTF8 データベースに接続しようとしました。 [oracle@test ~]$ sqlplus /nolog ... SQL> conn hr/hr ERROR:… Read More »ORA-12705: NLSデータファイルにアクセスできないか、無効な環境が指定されましたの解決方法
How to Resolve ORA-01861: literal does not match format string
ORA-01861 ORA-01861 means that the format strings of DATE and CHAR between two operands are not comparable in date format, we should make them match… Read More »How to Resolve ORA-01861: literal does not match format string
How to Import Character Set Conversion
Garbled Text Garbled data was found after importing a normal dump file. After doing some inspections, I found there's NLS_LANG environment variable for user oracle… Read More »How to Import Character Set Conversion