For how many years have you been working
with physical servers that are starving your database of the memory
necessary to deploy important new performance features such as the Result
Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and
Full Database Caching? Too long? Contact me to learn how to improve all
queries ... not just some queries.
Utitility procedures/functions for manipulating large amounts of text by the standard of 1995 when it was created.
TYPE vc_arr IS TABLE OF VARCHAR2(32767) INDEX BY BINARY_INTEGER;
TYPE int_arr IS TABLE OF INTEGER INDEX BY BINARY_INTEGER;
TYPE multi_line IS RECORD (rows vc_arr, num_rows INTEGER, partial_row BOOLEAN);
TYPE row_list IS RECORD (rows int_arr, num_rows INTEGER);