Oracle export trigger ddl

Oracle export view ddl

-- Views (use USER_VIEWS or DBA_VIEWS if needed):
SELECT TEXT FROM ALL_VIEWS WHERE upper(VIEW_NAME) LIKE upper('%VIEW_NAME%');
-- Or:
SELECT dbms_metadata.get_ddl('VIEW', 'VIEW_NAME', 'OWNER_NAME') FROM DUAL;

-- Materialized views (use USER_VIEWS or DBA_VIEWS if needed):
SELECT QUERY FROM ALL_MVIEWS WHERE upper(MVIEW_NAME) LIKE upper('%VIEW_NAME%');
-- Or:
SELECT dbms_metadata.get_ddl('MATERIALIZED_VIEW', 'VIEW_NAME', 'OWNER_NAME') 
FROM DUAL;

Source: oracle-base.com

Oracle export 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';

Similar codes

2 votes213 views1 answer
How to make insert script from table in SQL server
SQL
1 vote235 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2002] Connection refused (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote220 views1 answer
Ms sql filter all sympbol
SQL
0 vote207 views1 answer
Oracle archivemode
SQL
0 vote227 views1 answer
Mysql terminal run sql file
SQL
1 vote203 views1 answer
Set statiscis on in sql server
SQL
9 votes246 views3 answers
Date format in sql
SQL
0 vote216 views1 answer
Mysql utc timestamp
SQL
0 vote200 views2 answers
Change database postgres
SQL
3 votes226 views1 answer
Oracle sql commit example
SQL