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.
CREATE OR REPLACE NONEDITIONABLE TYPE "SYS"."ODCIVARCHAR2LIST"
AS VARRAY(32767) OF VARCHAR2(4000);
Owned by SYS with EXECUTE granted to PUBLIC
Type Usage Demo
col program_id format a11
SELECT DISTINCT program_id
FROM TABLE(sys.OdciVarchar2List('717', '727', '737', '747'));