Find the Invalid Email Address using Oracle SQL and PL/SQL
Objective: To find the validity of the email address using Oracle Pl/sql and to find the invalid email address from a object like table using Oracle Sql. Using Pl/Sql: DECLARE…
Read MoreRecover a dropped table
Recover a dropped table in Oracle 11g Steps to recover a dropped table in Oracle 11g when flashback mode is off After dropping table and before restoring it from the…
Read MoreAlter Pluggable Database Open – (ORA-00604/ORA-01405) After Apex Installation
While trying to open one pluggable database, I got the following errors: Background: While installing Apex 20.1 in one PDB, and while being very close to the installation completion, the…
Read MoreHow to Modify an Oracle Database Windows Service?
How we can change some parameters for one database winodws service. Background: I have a database called PROD with version 19.3, running on Windows. Its service looks like: This…
Read MoreOPatch error : “Unable to lock Central Inventory”
While applying Patch 31210848 “Microsoft Windows 32-Bit & x86-64 Bundle Patch 12.2.0.1.200714” on database 12.2.0.1on Windows platform I got the following error: Unable to lock Central Inventory. OPatch will…
Read MoreEBS 12.2 Upgrade Readiness Checker Tool – Database Tier (EURC-DT)
Oracle is designing many brand new tools to help customers and to increase the productivity of Oracle E-Business Suite (EBS) DBAs. One such tool is EBS 12.2 Upgrade Readiness Checker…
Read MoreRefresh the Parent Page on Closing the Modal Dialog in Oracle APEX
Introduction: Refresh the Parent Page on Closing the Modal Dialog in Oracle APEX.. Cause of the issue: The User has a requirement to refresh the Parent Page Interactive region on…
Read MoreValidating the Duplicate values using JavaScript in Oracle APEX
Introduction: To avoid duplicate values in Interactive Grid in Oracle APEX. Cause of the issue: In newly created APEX Page, there is user requirement to validate the duplicate values on…
Read MoreAR Customer Ledger with Unpaid Invoices
AR Customer Ledger with Unpaid Invoices SELECT arps.org_id, hou.NAME company, rctl.customer_trx_id, TO_CHAR (arps.trx_date, ‘MON-RRRR’) fiscal_year_month, arps.trx_number invoice_number, arps.trx_date invoice_date, arps.customer_id, NVL (arps.amount_due_original, 0) total_invoice_amount, NVL (arps.tax_original, 0) total_tax_amount, NVL (quantity_invoiced,…
Read MoreORA – bootstrap Error
ORA-00704 bootstrap process failure After Upgrading ORACLE_HOME (from 11.1.0.7.0 to 12.1.0.2.0), I was started my database by using startup command, then got below error. Connected to an idle instance. SQL>…
Read More