RETURNING 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 MoreJob DDL
Creates the DDL for the specified job:- SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON BEGIN DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'SQLTERMINATOR', true); DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'PRETTY',…
Read MoreDDL of Foreign key
Script to create foreign key DDL on all tables. SET LONG 20000 LONGCHUNKSIZE 20000 PAGESIZE 0 LINESIZE 1000 FEEDBACK OFF VERIFY OFF TRIMSPOOL ON BEGIN DBMS_METADATA.set_transform_param (DBMS_METADATA.session_transform, 'SQLTERMINATOR', true); DBMS_METADATA.set_transform_param…
Read MoreConverting rows to columns using Oracle Pivot clause
The Oracle introduced the PIVOT clause from oracle 11g. This makes converting rows to column easy. The value in the new columns must be the result of an aggregate function…
Read MoreFind 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 Moreoracle compound trigger to avoid mutating trigger
— Trigger to check if the sal greater than 100000, if yes, log the error message, else update sucessfully create or replace trigger trig_validate_sal before update of sal on emp_t…
Read MoreCaps Lock (On/Off) Indicator with JavaScript in Oracle APEX
Overview This document talks about how to indicate a message for whether the Caps Lock is on or off while inserting a password in login page by using JavaScript in…
Read MoreTo Find IP Address of the User who login into Apex Application
This query will help to sql, Plsql and Apex Developer to find the user IP Address. Normally we tracking only page id, username and time of the user for login…
Read More