Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle get trigger ddl

SELECT DBMS_METADATA.get_ddl('TRIGGER', TRIGGER_NAME, OWNER)
FROM ALL_TRIGGERS		-- or DBA_TRIGGERS, USER_TRIGGERS
WHERE OWNER = 'swhema_name'
  AND TRIGGER_NAME = 'trigger_name';
Comment

PREVIOUS NEXT
Code Example
Sql :: sql query to copy data from one column to another 
Sql :: oracle list data files 
Sql :: oracle source query 
Sql :: load mysql dumb 
Sql :: table information in sql server 
Sql :: Aqua Data studio postgresql ssl 
Sql :: laravel migration sql dump 
Sql :: edate dax 
Sql :: show all table name mysql 
Sql :: postgresql make each element in array distinct 
Sql :: mysql select for update ejemplo 
Sql :: mysql current user 
Sql :: get parameter value in mysql trigger 
Sql :: group by 15 minute interval sql server 
Sql :: insert into table from another table mysql 
Sql :: remove spaces sql server 
Sql :: NOT LIKE sql laravel 
Sql :: Sql creating roles 
Sql :: LoadError: cannot load such file -- mysql2/2.7/mysql2 
Sql :: sql fill na with 0 
Sql :: ilike for date postgres 
Sql :: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client 
Sql :: postgresql fill fake data 
Sql :: oracle user privileges 
Sql :: oracle add datafile to tablespace 
Sql :: mysql tables max count 
Sql :: data directory postgresql 
Sql :: oracle sysdate - 1 month 
Sql :: ajouter une clé etrangere mysql 
Sql :: MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES 
ADD CONTENT
Topic
Content
Source link
Name
7+3 =