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

57 votes557 views6 answers
Mysql alter table add column
SQL
0 vote312 views1 answer
Add sqlite3 in lumen
SQL
3 votes343 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote336 views1 answer
Alter rename command in mysql
SQL
4 votes331 views1 answer
Wildcard in sql
SQL
1 vote313 views10 answers
Stack overflow
SQL
0 vote321 views1 answer
Sql server current time without date
SQL
0 vote327 views1 answer
Postgres set default schema
SQL
0 vote354 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
1 vote323 views1 answer
How to make a select in sql
SQL