设置格式化输出显示
set linesize 7000
set pages 7000
set long 7000
1.查看序列定义的SQL语句
select dbms_metadata.get_ddl('SEQUENCE','SEQ_ID') from dual;
2.查看表的定义
select dbms_metadata.get_ddl('TABLE','TABLENAME','USERNAME') from dual;
3.查看用户的约束定义
select dbms_metadata.get_ddl('CONSTRAINT','CONSTRAINTNAME','USERNAME') from dual;
4.查看外键定义
select dbms_metadata.get_ddl('REF_CONSTRAINT','REF_CONSTRAINTNAME','USERNAME') from dual;
5.查看视图sql语句的定义
select dbms_metadata.get_ddl('VIEW','VIEWNAME','USERNAME') from dual;
6.查看用户定义
select dbms_metadata.get_ddl('USER','USERNAME') from dual;
7.查看表空间定义
select dbms_metadata.get_ddl('TABLESPACE','TABLESPACENAME') from dual;
8.查看物化视图定义
select dbms_metadata.get_ddl('MATERIALIZED VIEW','MVNAME') from dual;
9.查看DB_LINK语句定义
select dbms_metadata.get_ddl('DB_LINK','DBLINKNAME','USERNAME') from dual;
10.查看用户触发器定义
select dbms_metadata.get_ddl('TRIGGER','TRIGGERNAME','USERNAME') from dual;
11.查看函数语句定义
select dbms_metadata.get_ddl('FUNCTION','FUNCTIONNAME','USERNAME') from dual;
12.查看包定义
select dbms_metadata.get_ddl('PACKAGE','PACKAGENAME','USERNAME') from dual
13.查看存储过程定义
select dbms_metadata.get_ddl('PROCEDURE','PROCEDURENAME','USERNAME') from dual
14.查看权限的定义
select dbms_metadata.get_ddl('ROLE_GRANT','rolename') from dual;
15.
查看系统权限的定义
select dbms_metadata.get_ddl('SYSTEM_GRANT','rolename') from dual;
16.
查看对像权限的定义
select dbms_metadata.get_ddl('OBJECT_GRANT','角色名') from dual;