Data Engineering

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;