Oracle Apps Technical Stuff
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 ...
Tuesday, June 28, 2016
SQL to get DB Server Details
›
SELECT (SELECT UTL_INADDR.get_host_address FROM DUAL) local_host_address , (SELECT UTL_INADDR.get_host_name( (SELECT UTL_INADDR.get_ho...
Tuesday, June 14, 2016
Build Dynamic block for DML operations....
›
PROCEDURE execute_dml_dynamically( p_table_name IN VARCHAR2 , p_where_column IN VARCHAR2 , p_whe...
How to use Limits for Bulk Collect (PL/SQL Collections)
›
DECLARE CURSOR c_emp_cur IS SELECT * FROM emp; TYPE emp_cur_tbl_typ IS TABLE OF c_emp_cur%ROWTYPE INDEX BY PLS_I...
‹
›
Home
View web version