查询数据库对象的DDL信息

表的DDL

select dbms_metadata.get_ddl('HBBL','TABLE','AGREEMENT_MIRROR') from dual；

set lines 300
set pages 300
set newpage
set long 2000000000

select owner,view_name,text from all_views where view_name ='AGREEMENT_MIRROR';