Toad NLS_DATE_FORMAT
How do I Change NLS Date Format in Toad ? Just like we said previously, NLS_DATE_FORMAT can be set at session, database or OS level.… Read More »Toad NLS_DATE_FORMAT
ALTER SESSION SET NLS_DATE_FORMAT
SQL Developer NLS_DATE_FORMAT
How do I Change NLS Date Format in SQL Developer ? Just like we said previously, NLS_DATE_FORMAT can be set at session, database or OS… Read More »SQL Developer NLS_DATE_FORMAT
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
How RMAN Restore Table
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
How to Check User Creation Date in Oracle
User Creation Date To check the creation date for a specific user, we can query ALL_USERS. First of all, we format the date time of… Read More »How to Check User Creation Date in Oracle
How to Check Tablespace Creation Date
Tablespace Create Time There's no direct way to know the creation date of a tablespace, because either DBA_TABLESPACES or V$TABLESPACE doesn't have such information. But… Read More »How to Check Tablespace Creation Date
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
How RMAN Set NLS_DATE_FORMAT
NLS_DATE_FORMAT for RMAN After you set RMAN log location, the next problem that you want to solve is the format of timestamp in the log,… Read More »How RMAN Set NLS_DATE_FORMAT