Event Type-
DDL_COMMAND_START
DDL_COMMAND_END
SQL_DROP
This is example for creating an Event Trigger and logging DDL_COMMAND_START events.
CREATE TABLE TAB_EVENT_LOGS(
DATE_TIME TIMESTAMP,
EVENT_NAME TEXT,
REMARKS TEXT
);
CREATE OR REPLACE FUNCTION FN_LOG_EVENT()
RETURNS EVE...