We often need to change the date format while checking. Here are some ways which you can use to change the date format in Oracle database Oracle Default Date Format The default date format in oracle is controlled by the value of the NLS_DATE_FORMAT parameter. The following query can be used to find the current […]
How to change date format in oracle database Read More »
This post I am trying to explain many things about date in oracle like oracle sql date functions,oracle sql date format, oracle sql date comparison, oracle date difference in years,oracle date difference in days, oracle date difference in months Oracle has provided date and timestamp types for storing the date and time information in the
How to work with date Functions in Oracle sql Read More »
We have seen working of Oracle Decode processing in the previous post Oracle sql decode processing Now let us see Oracle Case statement processing Case statement in Oracle It is similar to the Decode statement. Databases before Oracle 8.1.6 had only the DECODE function. CASE was introduced in Oracle 8.1.6 as a standard, more meaningful,
Oracle Case Statement Explained with Tips and Examples Read More »
The DBNEWID(NID) Utility is a new utility introduced with Oracle database. The NID Utility in oracle allows you to change only the DBNAME, or only the DBID or both DBNAME and DBID in the same command.Lets discuss each of these option in detail and how to implement Change Only the DBID using NID Utility Here
How to change the DBNAME /DBID using DBNEWID(nid) utility for Oracle database Read More »
Many times DBA need to look at the session details for analysis. The details include sql_id, stats, locking, wait events. Here I am giving Query to get session details in oracle database, how to get the sql text from sid in oracle, how to check inactive sessions in oracle, how to check active sessions in
Query to get session details in oracle database Read More »
Introduction To Latch in Oracle Database Latches are low-level serialization mechanisms used to protect shared data structures in the Oracle SGA. The implementation of latches is operating system-dependent, particularly in regard to whether a process will wait for a latch and for how long. A latch is a type of lock that can be very
Latches and Mutex in Oracle database Read More »
