Oracle Apps Technical Stuff
Tuesday, August 9, 2016
Matrix/Crosstab SQL using PIVOT functionality
›
Sample SQL's Using Decode and aggregate functions. SELECT item , inventory , product_family FROM ( SELECT msi.segmen...
Monday, August 8, 2016
Template to Use SAVE EXCEPTIONS in COLLECTIONS (Oracle Pl/SQL table Types)
›
DECLARE -- Oracle9i and above! l_array <array_type_declaration>; bulk_errors EXCEPTION; PRAGMA EXCEPTION_INIT ( bulk_errors,...
Sample Script to APPLY_HOLD using OE_ORDER_PUB ( R12 ) at header level
›
CREATE OR REPLACE PROCEDURE apply_hold( p_request_rec IN oe_order_pub.request_rec_type) IS l_header_rec oe_order_pub.header...
Thursday, June 30, 2016
Oracle Object Oriented Programming
›
CREATE OR REPLACE TYPE xx_data_struc_obj AS OBJECT( num_col NUMBER , num_col2 NUMBER); / CREATE OR REPLACE TYPE xx_data_construct...
Oracle User-Defined Aggregate Functions Interface (Convert into a Single String)
›
This section describes the routines that need to be implemented to define a user-defined aggregate function. The routines are implemented ...
‹
›
Home
View web version