In this section, we will talk about various Oracle EBS 12.2 start-stop scripts in the latest release of Oracle Apps by Oracle Corporation. Here are the main scripts and how they are used to stop /start the application Start Scripts in R12.2 Stop Scripts in R12.2 Consolidated Scripts for Stop/Start We already know the consolidated scripts …
Admin scripts in R12.2 Ebuisness Suite Read More »
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 …
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 …
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 »
