Queries to analyze the Business
Introduction: These queries gives the modules used, data volumes, top products they have sold and other details about the Business. Queries: The below are the queries we have used to…
Read MoreSupplier Import process through FBDL (File based data loader) Template
supplier_.import_fbdldocx
Read MoreSTEPS TO INSTALL SQLSERVER IN WINDOWS 10
STEP – 1 1 First download .netframework 3.5 Completed. Now the .net framework 3.5 has been installed in the windows system STEP-2 -Download software for the sqlserver -User the…
Read MoreMETABASE INSTALLING IN ORACLE DATABASE
METABASE INSTALLING IN ORACLE DATABASE Requirements – Metabase requires a Java Runtime Environment (JRE), with a Java version of 11 or higher. – Check you have a java version…
Read MoreSplit Sales Order Line using script.
Shipment is happening from third party system and if partial shipment is happening then sales order line should be split based on balance quantity and with shipped quantity line should…
Read MoreFND_FILE.PUT_LINE CLOB file writing causes error.
Need to write output file using CLOB variable which contains more than 32767 bytes of data even it may contain up to 8 GB data. If it exceeds more than…
Read MoreOracle Data Dictionary Tables
USER_TABLES Lists each table that belongs to your Oracle user.USER_TAB_COMMENTS Shows comments on the tables and views.USER_TAB_COLUMNS Tells you the names, data types, default values, etc. of each column in…
Read MoreBulk Collect for Delete
CREATE OR REPLACE PROCEDURE BLK_CLCT_DELISL_LIMIT PLS_INTEGER := 20000; CURSOR C1ISSELECT row_idFROM s_invoice_itemWHERE person_id IN(SELECT b.row_idFROM disalloc A, S_CONTACT BWHERE A.PD_NEW_EYEE_ID = B.PERSON_UIDAND B.CON_CD = ‘Member’AND A.PD_DT_MODIFY BETWEEN ’01-JAN-2010′AND ’31-MAY-2010′); TYPE…
Read MoreRich text Editor using TinyMCE(Moxiecode Content Editor) in Oracle Apex 23.1
INTRODUCTION: TinyMCE is a web-based WYSIWYG (What You See Is What You Get) editor that allows users to create and edit HTML content in a browser. It is a popular…
Read More