Oracle TO_CHAR Example
TO_CHAR is an overloading function which converts or extracts various types of input values into desired or readable output. TO_CHAR for Datetime TO_CHAR for Number… Read More »Oracle TO_CHAR Example
Japanese
How to Resolve ORA-01846 Error Message
ORA-01846: not a valid day of the week ORA-01846 means that SQL engine cannot recognize the day value of week of your input string under… Read More »How to Resolve ORA-01846 Error Message
How to Resolve ORA-01843 Error Message
ORA-01843: not a valid month ORA-01843 means that SQL engine cannot recognize the month value of your input string under current NLS_DATE_LANGUAGE. In this post,… Read More »How to Resolve ORA-01843 Error Message
Oracle 11g Patching Steps
Keeping your database running with the newest release of Oracle software might be a critical job for DBA to implement, especially for production environments. Although… Read More »Oracle 11g Patching Steps