Oracle获得数据库对象DDL语句

select DBMS_METADATA.GET_DDL(object_type,object_name,owner) from dba_objects where owner='CCANA_ADMIN' and object_type not in ('DATABASE LINK');