DYNAMIC SAMPLING
Introduction Oracle Database introduced Dynamic Sampling to allow the optimizer to gather additional information at parse time. If database statistics were missing, stale or insufficient to produce a good execution…
Read MoreGenerate Barcode using Python
Step 1: Download and Install Python Step 2: Open CMD prompt and run the following command to install flask and barcode module >> pip install flask >> pip install python-barcode…
Read MoreGenerate QRcode using Python
Generate QRcode using Python Step 1: Download and Install Python Step 2: Open CMD prompt and run the following command to install flask and pyqrcode module >> pip install flask >>…
Read MoreHistograms
A histogram is a special type of column statistic that provides more detailed information about the data distribution in a table column. A histogram sorts values into “buckets,” as you might sort…
Read MorePython Flask
What is Flask? Flask is a popular Python web framework, a third-party Python library used for developing web applications. What is the purpose of Web Framework in Python? When a…
Read MoreHash Joins
HASH JOINS Hash joins are used when two larger data sets are joined. Optimizer will look for the smaller one of two datasets and build the hash table based on…
Read MoreCode Review Tools
Code Review plays a essential role in the Software development Life cycle This Result in Higher quality code and avoid the cost and time which we suppose to spend after…
Read MoreCustomer Contact Creation Email Creation and assignment API
CREATE OR REPLACE PACKAGE XX_CUST_CONT_PKG IS –================= — Global Variables –================= gn_request_id NUMBER := apps.fnd_global.conc_request_id; gn_prog_appl_id NUMBER := apps.fnd_global.prog_appl_id;…
Read MoreFunction to Get Customer's Contact Primary and Secondary Email Addresses
CREATE OR REPLACE FUNCTION CUST_EMAIL_FUNC (p_bill_to_contact_id IN NUMBER, p_flag VARCHAR2) RETURN VARCHAR2 IS V_email VARCHAR2(1000): = NULL; BEGIN IF p_flag = ‘PRI’ THEN select cont_point.email_address into V_email …
Read More