Ddl view

-- 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

Similar codes

0 vote340 views1 answer
Go install mysql
SQL
0 vote350 views1 answer
Connect postgresql using a connection string
SQL
0 vote352 views2 answers
Oracle create chain rule
SQL
2 votes385 views1 answer
Oracle list duplicates
SQL
0 vote446 views1 answer
SCRAM authentication requires libpq version 10 or above (SQL: select * from information_schema.tables where table_schema = public and table_name = migrations and table_type = 'BASE TABLE')
SQL
7 votes376 views1 answer
Mysql iif
SQL
4 votes339 views2 answers
Sql vs mysql
SQL
0 vote410 views1 answer
How to get button for every record from mysql
SQL
0 vote345 views1 answer
Restore backup "text" postgresql command line
SQL
38 votes408 views6 answers
Alter table mysql
SQL