温馨提示×

Oracle中dba_objects视图的查询方法有哪些

oracle

小樊

155

2024-08-10 08:27:39

栏目: 云计算

开发者测试专用服务器限时活动，0元免费领，库存有限，领完即止！点击查看>>

在Oracle中，可以使用以下方法查询dba_objects视图：

SELECT * FROM dba_objects;

SELECT * FROM dba_objects WHERE owner = 'SYS';

SELECT * FROM dba_objects WHERE object_type = 'TABLE';

SELECT * FROM dba_objects ORDER BY object_name;

SELECT count(*) as total_objects FROM dba_objects;

SELECT o.object_name, o.object_type, u.username
FROM dba_objects o
JOIN dba_users u ON o.owner = u.username;

0 赞

0 踩

最新问答