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

1 vote263 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
0 vote478 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
4 votes276 views4 answers
Rollback in sql
SQL
16 votes293 views3 answers
Get count of duplicate records
SQL
1 vote257 views1 answer
Postgres count string length
SQL
1 vote266 views3 answers
Epoch to datetime
SQL
1 vote263 views1 answer
Apex select list ORA-20999
SQL
11 votes292 views2 answers
Having clause in sql
SQL
0 vote247 views1 answer
Update top 100 sql
SQL
0 vote262 views1 answer
Mysql set boolean default value
SQL