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 votes182 views1 answer
Sql update \
SQL
1 vote176 views1 answer
Copy postgres table from one schema into another
SQL
0 vote151 views2 answers
Avg() sql
SQL
0 vote153 views1 answer
Hallo
SQL
10 votes166 views2 answers
Linux command line import mysql database
SQL
1 vote166 views1 answer
Sql auto date
SQL
9 votes179 views4 answers
Oracle get table column names
SQL
15 votes166 views3 answers
Create table with primary key auto increment in sql
SQL
19 votes168 views2 answers
Mysql add column after another
SQL
3 votes176 views2 answers
Oracle apex charging debug
SQL