EXCEL 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 MoreSending E-mail with Excel Attachment Using UTL_SMTP
The utl_smtp package is used to send e-mails from any database to a valid recipient/receipents with or without attachements.The generic code is given to send e-mail with excel attachment ,…
Read MoreLoad XML data into Oracle table
Steps to Load XML File to Oracle Tables Solution : Sample XML file has been used for illustration Step 1 : Create a directory using the below command. The below…
Read More