Description: Oracle Database 18c is the same database software that is running on-premises as in the Oracle Cloud. It enables end-users to take their in-house developed Oracle applications and third-party applications and run them on Oracle Cloud without…
Read MoreDescription: ORA-30006 and ORA-00054 errors raised when update operation is performed against a record, that has been locked by the user or some session FOR UPDATE. To fix this, before performing the update, check whether…
Read MoreDescription Introduced in Oracle 10g and having evolved from the Statspack functionality of Oracle 8i/9i, the Automatic Workload Repository report or AWR report (as it is more commonly known as)…
Read MoreDescription: The System Global Area (SGA) is a group of shared memory structures, known as SGA components, that contain data and control information for one Oracle Database instance. The SGA…
Read MoreDescription: Script to get dependents for employee describes dependencies between procedures, packages, functions, package bodies, and triggers accessible to the current user, including dependencies on views created without any database…
Read MoreDescription: Aging reports help to identify how old the customer Invoice due for the payment. This helps to identify and to decide those Invoice is due last 30 or Last…
Read MoreDescription: The collection elements that you define can be added to collection plans to determine what quality results data to collect, track, and report. API used for EAM preventive collection…
Read MoreDescription: Oracle Projects provides default processes for each workflow. You can modify the default processes and create additional methods to accommodate the needs of your business, using the Oracle Workflow…
Read MoreDescription: This query fetches the detailed information related to those assets which are added newly for a particular period. Script to New Asset Addition SELECT FAL.segment1 SOL_ID ,FFV.description BRANCH_NAME ,FAA.tag_number …
Read MoreDescription: When you define a concurrent program, you can list those programs you want it to be incompatible with. You can also list the program as inconsistent with itself, which…
Read More