PROCEDURE: SYS.DBMS_PDB_NUM

Source

1 PROCEDURE dbms_pdb_num
2      ( feature_boolean  OUT NUMBER,
3        aux_count        OUT NUMBER,
4        feature_info     OUT CLOB)
5 AS
6 begin
7   feature_boolean := 0;
8   aux_count := 0;
9   feature_info := NULL;
10 
11   select count(*) into feature_boolean from v$database where cdb = 'YES';
12   if (feature_boolean = 1) then
13     select count(*) into aux_count from v$pdbs where con_id > 2;
14   end if;
15 
16 end dbms_pdb_num;