ORACLE user_objects 表

1. OBJECT_TYPE

Java代码  

1. select distinct(o.OBJECT_TYPE) from user_objects o  

select distinct(o.OBJECT_TYPE) from user_objects o

2.具体

Java代码  

1. select dbms_metadata.get_ddl('SEQUENCE',u.object_name) from user_objects u where object_type='SEQUENCE'  
2. select dbms_metadata.get_ddl('PROCEDURE',u.object_name) from user_objects u where object_type='PROCEDURE'  
3. select dbms_metadata.get_ddl('PACKAGE',u.object_name) from user_objects u where object_type='PACKAGE'  
4. select dbms_metadata.get_ddl('TRIGGER',u.object_name) from user_objects u where object_type='TRIGGER'  
5. select dbms_metadata.get_ddl('TABLE',u.object_name) from user_objects u where object_type='TABLE'  
6. 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'

• 
• 大小: 6.6 KB

• 
• 大小: 35.7 KB

• 查看图片附件