Generate and format trigger DDL

How to format DBMS_METADATA.GET_DDL? To get a formatted definition of your DDLs, with all the semicolons and avoid lines break (Wrapped lines). Here is an example to retrieve the DDL of a triggers using the DBMS_METADATA package. For Oracle 18c / 12c / 11g / 10g: COLUMN Text FORMAT a2480 WORD_WRAPPED SET LONG 20000 LONGCHUNKSIZE […]

Dynamic Grants mgmt

— ############################################################ — # Creator: Yann Cousin — # Created: 2011/04/22 — # Name: dynamic Grants mgmt — ############################################################ — # — # Compatible: Oracle 9i 10g 11g — # — ############################################################ — # — # How to create a read only user and dynamicaly grant — # privileges to this new user: — # […]

Email Sys_context trigger

— ############################################################ — # Creator: Vincent Fenoll — # Created: 2011/04/19 — # Name: Email Sys_context trigger — ############################################################ — # — # Compatible: Oracle 10g 11g — # — ############################################################ — # — # Send an email in a trigger (here after the deletion of a — # row in a table)and display informations […]

Start stop service triggers

— ################################################ — # Creator: Cyrille MODIANO — # Created: 2010/08/20 — # Name: Start_stop_service_triggers.sql — ################################################ — # — # Compatible: Oracle 10g 11g — # — ################################################ — # — # This script creates a trigger used to — # run a scheduler job which call an external shell — # script or […]