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; 复制...
oracle 小樊 91 2024-08-10 08:28:44 栏目: 云计算 在Oracle中,可以使用以下语句设置dba_objects视图的过滤条件: SELECT * FROM dba_objects WHERE object_name = 'your_object_name'; 复制代码 这将显示名称为’your_object_name’的对象的信息。您还可以使用其他条件,例如owner、object_type等来进行过滤。
select owner, object_name, object_type, created, last_ddl_time, timestamp, status from dba_objects where owner=upper(‘scott’) 2. 查看系统所有表 select owner, table_name, tablespace_name from dba_tables 3. 查看所有用户的表 select owner, table_name, tablespace_name from all_tables 4. 查...
from dba_objects;
SELECT1000,'kerry','ttdfdf'FROMDUAL; COMMIT; SELECT*FROMDBA_LOBSWHEREOWNER='SYSTEM'ANDTABLE_NAME='TEST' SELECT*FROMDBA_OBJECTS WHEREOBJECT_TYPE ='LOB' ANDOWNER ='SYSTEM' ANDOBJECT_NAME='SYS_LOB0000585336C00003$$'; 如果你想知道这些LOB对象涉及那些对象,可以使用下面SQL查看详细信息: ...
SQL>select * from dba_sys_privs where grantee='GAME'; 11、 显示特权用户 select * from v$pwfile_users; 二、查询表 1、 查看用户下所有的表 SQL>select * from user_tables; 2、 查看名称包含log字符的表 SQL>select object_name,object_id from user_objects ...
SELECT * FROM DBA_OBJECTS 1. WHERE OBJECT_TYPE ='LOB' 1. AND OWNER ='SYSTEM' 1. AND OBJECT_NAME='SYS_LOB0000585336C00003$$'; 1. 如果你想知道这些LOB对象涉及那些对象,可以使用下面SQL查看详细信息: 1. SELECT O.OWNER,O.OBJECT_ID, O.OBJECT_NAME, O.OBJECT_TYPE, ...
from sys.dba_objects o, ( select s.osuser, s.username, l.type, l.lmode, s.sid, s.serial#, l.id1, l.id2 from v$session s, v$lock l where s.sid = l.sid ) ls where o.object_id = ls.id1 and o.owner <> ''SYS'' order by o.owner, o.object_name17。查看等待(wait)...
SELECT OWNER,OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_TYPE='DATABASE LINK'; SELECT * FROM DBA_DB_LINKS; -- 删除数据库连接 DROP DATABASE LINK dblink_name; -- 从外部ORACLE连接查询数据 SELECT * FROM USERNAME.TABLENAME@dblink_name; SELECT * FROM TABLENAME@dblink_name; 认准ORACLE官方授权...
SQL> SET LINES 333 PAGES 111 SQL> COL OBJECT_NAME FOR A40 SQL> COL OBJECT_TYPE FOR A30 SQL> SELECT OWNER, OBJECT_NAME,OBJECT_TYPE FROM DBA_OBJECTS 2 WHERE STATUS <> 'VALID' ORDER BY OWNER, OBJECT_NAME; OWNER OBJECT_NAME OBJECT_TYPE --- --- --- TEST DO_CURSORS PROCEDURE TESTC100...