NEW ASSETS ADDITION QUERY
This query fetches the detailed information related to those assets which are added newly for a particular period. SELECT FAL.segment1 SOL_ID ,FFV.description BRANCH_NAME …
Read MoreMap Member Functions For Multiset Operations
MAP member function are special functions used to compare objects.The MAP member functions are used for performing comparisons between a single attribute of an object instance to a single attribute…
Read MoreEXCEL UPLOAD IN APEX USING SELECT LIST TEMPLATE
Follow the below steps to achieve, the process of uploading a .XLSX file with multiple tabs with Select List in APEX using PL/SQL. ü Step 1 : Create an .XLSX…
Read More.XLSX UPLOAD IN APEX USING PL/SQL
Follow the steps below to achieve, the process of uploading a .XLSX file in APEX ( 4,5 AND 18C) using PL/SQL. ü Step 1 : We need to create a…
Read MoreEmail Validation using PL/SQL Function
Email Validation Function using plsql function CREATE FUNCTION f_email_validate (pi_email_id IN OUT VARCHAR2) RETURN BOOLEAN IS lv_n_check_len NUMBER; lv_b_check_in_at BOOLEAN; lv_b_check_in_dot BOOLEAN; lv_v_extn VARCHAR2 (10);…
Read MoreScript to replace junk characters
This script can be used to remove junk characters from a string CREATE OR REPLACE FUNCTION xx_Replace_Junk_Chars_func (p_string IN VARCHAR2) RETURN VARCHAR2 IS lv_string VARCHAR2 (1000); …
Read MoreGenerate xls, xlsx file in Oracle Directory Using Oracle PL/SQL
Objective: To generate xls, xlsx file in Oracle Directory using Oracle PL/SQL. Scenario: Customer asks us to generate excel report in oracle directory itself; from there customer will download the…
Read MoreGenerate csv file in Oracle Directory Using Oracle PL/SQL
Objective: To generate excel (csv) file in Oracle Directory using Oracle PL/SQL. Scenario: Customer asks us to generate excel report in oracle directory itself; from there customer will download the…
Read MoreGenerate DBF file in Oracle Directory Using Oracle PL/SQL
Objective: To generate Database File (DBF) in Oracle Directory using Oracle PL/SQL. Scenario: Customer asks us to generate database file format report in oracle directory itself; from there customer will…
Read MoreTrigger Enhancements in Oracle Database 11g Release 1
· Execution Order of Triggers · Compound Triggers · Enable and Disable Triggers Execution Order of Triggers Oracle allows more than one trigger to be created for the same timing…
Read More