SELECT hou.name operating_unit, xep.name legal_entity, ala.lockbox_number “NUMBER”, absa.name batch_source, cebb.bank_name, –cebb.bank_number, –cebb.bank_branch_name, –cebb.bank_branch_number, –cebb.bank_branch_type, — Branch type indicates which list the bank routing number is on. Valid types are ABA,…
Read MoreSyntax: SQRT(number); Query: select SQRT(25) from dual; Output: 5
Read MoreSyntax: POWER(<base number>, <exponent number>) Query: select POWER(3,3) from dual; Output: This function return base number raised to the exponent’s power. 27
Read MoreSyntax: to_char(-123456,’99G99G99G999PR’) Query: select to_char(-123456,’99G99G99G999PR’) from dual; Output: <1,23,456>
Read MoreObjective: Using Oracle Apex Package Apex mail, How we can frame mails and send with the help of oracle PL/SQL Program. Definition: We have 3 Procedures inside Apex_mail,…
Read MoreThe steps in this section will show you how to create a new PL/SQL library, then create a function that will live in this library. To create the library: Launch…
Read MoreBefore upgrade or after upgrade, database may show INVALID status for component Real Application Clusters in dba_registry as below . SQL> select comp_name,version,status from dba_registry; … Oracle Real Application…
Read MoreTable of Contents Overview Technologies and Tools Used Use Case Architecture Screen Shot 1. Overview This document will be helpful to compares Prod and Dev schema and generates scripts for missing…
Read MoreObjective: To split the given string separated by special character as an individual column value using oracle pipelined Function. Step 1: Create table type of varchar: create or replace…
Read More