在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;