Introduction In Oracle APEX Interactive Reports (IR), aggregate values such as SUM or AVG are always displayed at the bottom of the report. For reports with many rows, users must…
Read MoreA Practical Guide for Oracle DBAs Indexes play a critical role in Oracle database performance. While well-designed indexes can dramatically improve query response time, unused or missing indexes can just…
Read MoreA Practical Guide for DBAs Auditing helps Oracle DBAs track who did what, when, and from where. Whether for security reviews, compliance, or incident investigations, having ready-to-use audit queries saves…
Read MoreSELECT WWOB.WORK_ORDER_NUMBER WO_NUMBER ,WWOT.WORK_ORDER_DESCRIPTION WO_DESCRIPTION ,WWST.WO_STATUS_NAME WO_STATUS ,HOU.NAME ORG_NAME ,CASE WHEN ROW_NUMBER() OVER (PARTITION BY HOU.NAME ORDER BY HOU.NAME) = 1 THEN HOU.NAME ELSE NULL END AS ORG_PARAMETER, CASE WHEN…
Read MoreSELECT Qry_rslt.”Supplier Name” ,Qry_rslt.”Supplier Number” ,Qry_rslt.”Supplier Site Name” ,Qry_rslt.”Supplier Status” ,Qry_rslt.”Inactive Date” ,Qry_rslt.”Procurement Business Unit” ,Qry_rslt.”Currency” ,Qry_rslt.”Total Amount” ,Qry_rslt.”No Data…
Read MoreError While starting an Oracle RAC database using srvctl, the startup failed with: PRCR-1079: Failed to start resource ora.RACDB.db CRS-5076: Startup of database resource ‘ora.RACDB.db’ is failing because DB_UNIQUE_NAME ‘RAC_DB’ is not expected Description …
Read MoreDescription: – Active Data Guard allows a physical standby database to be opened in READ ONLY mode while redo apply continues in the background. This enables the standby database to be used for reporting and…
Read MoreNew Development Report Using XML Data Template Introduction XML Publisher (BI Publisher) provides multiple ways to generate reports in Oracle E-Business Suite. One important and commonly used approach is creating…
Read MoreOverview This blog explains how to secure an Oracle 19c tablespace using RMAN password-based encryption and demonstrates a complete backup, restore, and recovery cycle. It covers verifying tablespaces and datafiles, taking an encrypted RMAN backup…
Read MoreShrinking a table in an Oracle database is used to reclaim unused space and optimize storage. As data is inserted, updated, and deleted over time, tables can become fragmented and retain empty blocks, leading to wasted…
Read More