Oracle Apps Technical Stuff
Friday, January 8, 2016
Efficient SQL Statements
›
Driving Tables (RBO Only) The structure of the FROM and WHERE clauses of DML statements can be tailored to improve the performance of t...
Thursday, January 7, 2016
Build IN Clause dynamically and use it in SELECT statement
›
CREATE OR REPLACE TYPE xx_string_tbl_typ AS TABLE OF VARCHAR2(4000); CREATE OR REPLACE FUNCTION xx_build_dynamic_in_clause( p_in_clause_...
Tuesday, December 15, 2015
API to get the On hand quantity details for Item in Inveontory
›
PROCEDURE get_onhand_quantities( p_item_name IN VARCHAR2 , p_organziation_id IN NUMBER , ...
Monday, December 14, 2015
Script to Remove the Duplicate Strings from a String and return Unique String (Comma Separated)
›
Below script can be used to remove the repeating (Duplicate String ) String from a string and return unique string Concatenated by comma (...
Monday, August 3, 2015
sys_refcursor to dynamic record/table type
›
DECLARE l_refcursor SYS_REFCURSOR; l_cols NUMBER; l_desc DB...
‹
›
Home
View web version