Blog / Category
PLSQL Function in SQL Query Fusion
5 articles in this category
Preventing Duplicate Form Submission in Oracle APEX
Introduction / Issue One of the common issues encountered while developing Oracle APEX applications is duplicate form submission. Users may unintentionally clic…
Item Where-Used Analysis Report (Excel – PL/SQL)
Introduction: This blog has the SQL query that can be used for Item where used Report in Oracle Apps R12. Cause of the issue: Business wants a PLSQL excel based…
Deterministic Functions in Oracle
Deterministic Functions in Oracle Overview A deterministic function in Oracle is a function that always returns the same result for the same input values and ha…
Pipelined Function for String Separation
We might face some scenarios for convert string data into rows. Here you can separate a string into rows by giving the string separator as input. Users can give…
Project Unbilled Balances Query – FUSION
WITHFUNCTION get_rev_todate_amt ( p_contract_id IN NUMBER,  …