ORA-20000
ORA-20000 Programs that rely on PL/SQL can often be hit with run-time errors that occur due to faults in design, problems with coding, and a number of other issues. However,…
Read MoreSending Email Using Oracle Apex and PL/SQL With Examples
Objective: Using Oracle Apex Package Apex mail, How we can frame mails and send with the help of oracle PL/SQL Program. Definition: We have 3 Procedures inside Apex_mail,…
Read MoreCreate a New PL/SQL Library
The steps in this section will show you how to create a new PL/SQL library, then create a function that will live in this library. To create the library: Launch…
Read MoreHow to fix INVALID status for RAC component in dba_registry
Before upgrade or after upgrade, database may show INVALID status for component Real Application Clusters in dba_registry as below . SQL> select comp_name,version,status from dba_registry; … Oracle Real Application…
Read MoreGenerate DDL By comparing 2 Schema.
Table of Contents Overview Technologies and Tools Used Use Case Architecture Screen Shot 1. Overview This document will be helpful to compares Prod and Dev schema and generates scripts for missing…
Read MoreSplit A String separated by Comma using oracle pl/sql Pipelined Fuction
Objective: To split the given string separated by special character as an individual column value using oracle pipelined Function. Step 1: Create table type of varchar: create or replace…
Read MoreTable Alter Script by comparing 2 schema
Table of Contents Overview Technologies and Tools Used Use Case Architecture Screen Shot 1. Overview This document will be helpful to compares Prod and Dev schema and generates alter scripts…
Read MoreRETURNING CLAUSE with EXECUTE IMMEDIATE
RETURNING Clause With EXECUTE IMMEDIATE 1. Overview The RETURNING clause allows you to retrieve values of columns (and expressions based on columns) that were modified by an insert, delete…
Read MoreRETURNING CLAUSE with BULK COLLECT
RETURNING Clause Using Bulk Collect 1. Overview The RETURNING clause can return multiple rows of data, in which case you will use the RETURNING BULK COLLECT INTO form.…
Read MoreReturning Clause in Oracle Plsql
Use RETURNING Clause to Avoid Unnecessary SQL Statements 1. Overview The RETURNING clause allows you to retrieve values of columns (and expressions based on columns) that were modified by an…
Read More