Oracle SQL查询:dba_segments+ dba_objects
我希望修改此SQL以添加DBA_Objects中的Max(创建)和Max(Last_ddl_time)。 我该怎么做?谢谢。
select owner, segment_name, sum(bytes) sb
from dba_segments
where tablespace_name = 'USERS'
group by owner, segment_name order by sb desc
I wish to modify this sql to add the max(created) and max(last_ddl_time) from dba_objects.
How do I do that ? Thank you.
select owner, segment_name, sum(bytes) sb
from dba_segments
where tablespace_name = 'USERS'
group by owner, segment_name order by sb desc
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

这样:
如果这很有意义,这是另一回事:-)
Like this:
If this makes sense is another matter :-)