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 MoreScript 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 MoreThe 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 MoreObjective: 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 More— 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 MoreOverview 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 MoreThis 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 MoreObjective: The Excel Upload Page in Oracle Apex Involves Excel Upload template design. Usually the templates will be stored in Shared Components Workspace File and through button click JavaScript call,…
Read MoreCREATE OR REPLACE PROCEDURE PR_TOT_DAYS ( P_START_DATE IN DATE, P_END_DATE IN DATE, P_DAY IN VARCHAR2, P_TOT_DAYS OUT NUMBER ) IS LV_LOOP NUMBER; LV_DATE DATE; LV_TOT_DAYS NUMBER := 0; BEGIN LV_LOOP…
Read MoreOverview This document explains how to give a customized Error Message using minimal PL/SQL code in Oracle APEX. Technologies and Tools Used The following technologies has been used to achieve…
Read More