select t.* from user_objects t WHERE t.object_type IN('TABLE','SEQUENCE','VIEW','PACKAGE','PACKAGE BODY','FUNCTION')
ORDER BY case t.object_type
when 'TABLE' then 1
when 'SEQUENCE' then 2
when 'VIEW' then 3
when 'PACKAGE' then 4
when 'PACKAGE BODY' then 5
when 'FUNCTION'then 6 ELSE 0 END
ORDER BY case t.object_type
when 'TABLE' then 1
when 'SEQUENCE' then 2
when 'VIEW' then 3
when 'PACKAGE' then 4
when 'PACKAGE BODY' then 5
when 'FUNCTION'then 6 ELSE 0 END
扫一扫
1286
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
