NLS_DATE_FORMAT, How and Why
NLS_DATE_FORMAT defines the display format of a datetime string, which can be set at various levels to meet business requirements. That is to say, NLS_DATE_FORMAT… Read More »NLS_DATE_FORMAT, How and Why
NLS_LANG
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
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 date format between two operands cannot be comparable. Usually, it happens when comparing DATE with CHAR. Therefore, we should make… Read More »How to Resolve ORA-01861: literal does not match format string