Besides ANSI SQL reserved words, Oracle has its own reserved words which are conditionally used in the RDBMS. Here we query V$RESERVED_WORDS to list all… Read More »Oracle SQL Reserved Words
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
Recover Table by RMAN We have talked about how to restore a table from the recyclebin earlier. By using the feature of recyclebin, we can… Read More »How RMAN Restore Table
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