The Library is currently in the process of being upgraded from Oracle Database Version 126.96.36.199 to 188.8.131.52.
Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs,
and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Do you remember when mainframes were replaced by client-server? When
client-server was replaced by n-tier architecture? The "Cloud" is a
distraction ... DevOps is not. Prepare for the future.
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'));