1. OBJECT_TYPE
2.具体
- select distinct(o.OBJECT_TYPE) from user_objects o
select distinct(o.OBJECT_TYPE) from user_objects o
2.具体
- select dbms_metadata.get_ddl('SEQUENCE',u.object_name) from user_objects u where object_type='SEQUENCE'
- select dbms_metadata.get_ddl('PROCEDURE',u.object_name) from user_objects u where object_type='PROCEDURE'
- select dbms_metadata.get_ddl('PACKAGE',u.object_name) from user_objects u where object_type='PACKAGE'
- select dbms_metadata.get_ddl('TRIGGER',u.object_name) from user_objects u where object_type='TRIGGER'
- select dbms_metadata.get_ddl('TABLE',u.object_name) from user_objects u where object_type='TABLE'
- select dbms_metadata.get_ddl('INDEX',u.object_name) from user_objects u where object_type='INDEX'
select dbms_metadata.get_ddl('SEQUENCE',u.object_name) from user_objects u where object_type='SEQUENCE'
select dbms_metadata.get_ddl('PROCEDURE',u.object_name) from user_objects u where object_type='PROCEDURE'
select dbms_metadata.get_ddl('PACKAGE',u.object_name) from user_objects u where object_type='PACKAGE'
select dbms_metadata.get_ddl('TRIGGER',u.object_name) from user_objects u where object_type='TRIGGER'
select dbms_metadata.get_ddl('TABLE',u.object_name) from user_objects u where object_type='TABLE'
select dbms_metadata.get_ddl('INDEX',u.object_name) from user_objects u where object_type='INDEX'