Ed Chen Logic - Page 5 of 76 - To Make My Logic More Logical

How to Resolve ORA-01843: not a valid month

by Ed Chen
September 21, 2019September 21, 2019

ORA-01843 ORA-01843: not a valid month means that SQL engine cannot recognize the month value of your input string under current NLS_DATE_LANGUAGE. In this post,… Read More »

Valid Day Values of Week for Different NLS_DATE_LANGUAGE

by Ed Chen
September 21, 2019October 3, 2019

In this post, I listed valid day values of some NLS_DATE_LANGUAGE other than AMERICAN and ENGLISH for you as a reference in order to solve… Read More »

Valid Month Values for Different NLS_DATE_LANGUAGE

by Ed Chen
September 21, 2019September 21, 2019

In this post, I listed valid month values for some NLS_DATE_LANGUAGE other than AMERICAN and ENGLISH for you as a reference in order to solve… Read More »

Oracle TO_DATE Function Examples

by Ed Chen
September 21, 2019December 24, 2019

Oracle TO_DATE Oracle TO_DATE function can convert a date time string into a value acceptable for converting string into datetime type. There're 4 major components… Read More »

How NLS_LANG Affects NLS_DATE_FORMAT When NLS_LANG is Set Territory Only

NLS_TERRITORY to NLS_DATE_FORMAT Mapping Table

by Ed Chen
September 18, 2019October 2, 2019

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_LANGUAGE to NLS_TERRITORY Mapping Table

by Ed Chen
September 16, 2019October 2, 2019

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 »

How NLS_LANG Affects NLS_DATE_FORMAT When NLS_LANG is Set Language Only

NLS_LANGUAGE to NLS_DATE_FORMAT Mapping Table

by Ed Chen
September 14, 2019October 2, 2019

NLS_LANGUAGE to NLS_DATE_FORMAT Here in this post is the mapping table for showing NLS_LANGUAGE to their respective NLS_DATE_FORMAT. In some situations, you may need this… Read More »

How to Take Backup of Stored Procedure in Oracle

by Ed Chen
September 11, 2019November 8, 2019

Backup of Stored Procedure Usually, source codes of programming unit should be version-controlled by the developer team. But if they have never carried out their… Read More »

NLS_LANG, How and Why

by Ed Chen
September 7, 2019January 9, 2020

What is NLS_LANG? What is NLS_LANG? NLS_LANG is an environment variable in the client's environment, it's also a notation that can notify database what NLS… Read More »

How to Resolve Oracle SHUTDOWN IMMEDIATE Hangs

by Ed Chen
September 4, 2019November 6, 2019

SHUTDOWN IMMEDIATE Hangs Database shutdowns may not go smoothly as you thought, they could seem to be stuck in an infinite waiting. If you wait… Read More »

« Previous
1
…
3
4
5
6
7
…
76
Next »