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 votes288 views2 answers
How to rename column name in sql server using query
SQL
17 votes297 views6 answers
What is cursor in sql server with example
SQL
13 votes279 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
2 votes304 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote297 views1 answer
How to search query in python3 sqlite3
SQL
1 vote320 views1 answer
Nvl postgres
SQL
1 vote265 views1 answer
Mysql collation
SQL
0 vote284 views1 answer
Learn sqlite dart
SQL
0 vote283 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
62 votes381 views8 answers
Mysql add column
SQL