-- -----------------------------------------------------------------------------------
-- File Name    : plugin_violations.sql
-- Author       : DBA Learning Hub
-- Description  : Displays information about recent PDB plugin violations.
-- Requirements : 
-- Call Syntax  : @plugin_violations
-- Last Modified: 15/07/2025
-- -----------------------------------------------------------------------------------

SET LINESIZE 200

COLUMN time FORMAT A30
COLUMN name FORMAT A30
COLUMN cause FORMAT A30
COLUMN message FORMAT A30

SELECT time, name, cause, message
FROM   pdb_plug_in_violations
WHERE  time > TRUNC(SYSTIMESTAMP)
ORDER BY time;