Oracle Apps Technical Stuff
Showing posts with label
PL/SQL
.
Show all posts
Showing posts with label
PL/SQL
.
Show all posts
Sunday, February 27, 2022
Oracle Fusion SQL : SQL to Extract Transfer Order details
›
SELECT d.header_number , e.line_number , so.organization_code source_inv_org , do.organization_code dest_inv_org ...
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,...
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