set serveroutput on declare v_count number; v_detected_usages number; v_currently_used varchar2(5); begin select count(*) into v_count from dba_feature_usage_statistics where lower(name) = 'oracle pluggable databases'; if v_count = 0 then dbms_output.put_line ('Multitenant............: NOT APPLICABLE'); else select detected_usages, currently_used into v_detected_usages, v_currently_used from dba_feature_usage_statistics where lower(name) = 'oracle pluggable databases'; if v_detected_usages = 0 then dbms_output.put_line ('Multitenant............: ' || v_currently_used); else dbms_output.put_line ('Multitenant............: ' || v_currently_used || ' - ' || v_detected_usages || ' times used so far'); end if; end if; exception when others then dbms_output.put_line ('Fehler: ' || SQLCODE); end; /