Get DDL for a view or table

Oracle 

Syntax:

select DBMS_METADATA.GET_DDL(‘TABLE’,’TEST_TABLE’) from dual;

Ex:

select dbms_metadata.get_ddl('VIEW','WeeklyRUN_REPORT_V','Schema') 

  from dual;