oracle 批量查询DDL

来源:互联网 发布:怎么算包皮正常知乎 编辑:程序博客网 时间:2024/06/06 08:57
SELECT DBMS_METADATA.GET_DDL(U.OBJECT_TYPE, u.object_name)
FROM USER_OBJECTS u
where U.OBJECT_TYPE IN ('TABLE','INDEX','PROCEDURE','FUNCTION');