摘要: 16:56:49 DZFPMX(24_112)@test> col object_type for a1016:57:00 DZFPMX(24_112)@test> col object_name for a2016:57:07 DZFPMX(24_112)@test> col subobject_ 阅读全文
posted @ 2017-05-24 20:04 Oracle-fans 阅读(203) 评论(0) 推荐(0) 编辑
摘要: select case when subobject_name is null then obj.object_id else null end object_id ,--主对象idcase when obj.object_type = 'TABLE' then obj.object_type el 阅读全文
posted @ 2017-05-24 20:02 Oracle-fans 阅读(266) 评论(0) 推荐(0) 编辑