查看oracle 用户的表共找到437条结果

--Oracle 查看用户的表级权限 SELECT * FROM user_tab_privs u WHERE u.table_name LIKE '%CUX_OM_SHIPMENTS_HDR_IFACE%';   --Oracle 查看用户的表级同义词 SELECT * FROM u ...(2018-08-07 10:22:53)

select * from user_tab_privs u where u.TABLE_NAME = 'C_CONS'--查看当前用户下的同义词 select * from user_synonyms u where u.SYNONYM_NAME = 'C_METER';参考文章:http://b ...(2018-03-15 14:42:18)

查看占用空间 select segment_name,segment_type, bytes/1024/1024  from user_segments  ORDER BY    bytes  desc      ...(2018-08-08 13:34:46)

查看有哪些表select * from tab; 查看表结构describe 表名; ...(2016-09-09 13:36:28)

select owner, table_name, sum(size_m)  from (select s.owner,               s.segment_name as table_name,               s.bytes / 1024 / 1024 as size_m ...(2018-04-24 17:30:01)

(1)查询当前用户 SQL>show user USERis "SCOTT" (2)查询当前用户下的所有表,有三种方法 第一种: SQL>select table_name from tabs; TABLE_NAME ------------ ...(2016-09-19 11:21:49)

select * from user_tab_modifications; ...(2014-09-01 09:59:12)

select t.TABLE_NAME,t.NUM_ROWS  from user_tables t ...(2016-08-22 11:14:16)

select table_name from user_tables; //当前用户的表 select table_name from all_tables; //所有用户的表 select table_name from dba_tables; //包括系统表 ...(2013-04-09 20:53:13)

select s.username,s.account_status,s.lock_date,s.expiry_date,s.default_tablespace from dba_users s; ...(2015-12-09 09:14:19)