Oracle查询数据库中所有表的记录数 | 您所在的位置:网站首页 › oracle显示所有数据库 › Oracle查询数据库中所有表的记录数 |
Oracle查询数据库中所有表的记录数 查询库中的表名和表中记录数: SELECT T.TABLE_NAME, T.NUM_ROWS FROM USER_TABLES T; 查询库中记录总数: SELECT SUM(A.NUM_ROWS) FROM (SELECT T.TABLE_NAME, T.NUM_ROWS FROM USER_TABLES T) A; 如图所示: Oracle一下简单使用1、用户操作 select * from dba_users;create user test identified by 123456;alter user test identified by 123456;grant connect,resource to test ;alter user test quota unlimited on users;drop user test cascade; 2、用户 select * from user_users; 查看当前用户的角色select * from user_role_privs; 查看当前用户的系统权限和表级权限select * from user_sys_privs;select * from user_tab_privs; 3、表 查看用户下所有的表select * from user_tables; 查看某表的创建时间select * from user_objects where object_name=upper('test'); 查看某表的大小select sum(bytes)/(1024*1024) as "size(M)" from user_segments where segment_name=upper('test'); 4、索引 查看索引个数和类别select index_name,index_type,table_name from user_indexes order by table_name; 查看索引被索引的字段select * from user_ind_columns where index_name=upper('&index_name'); 查看索引的大小select sum(bytes)/(1024*1024) as "size(M)" from user_segments where segment_name=upper('&index_name'); 5、序列号 查看序列号,last_number是当前值select * from user_sequences; 6、视图 select * from user_views; 7、存储函数和过程 查看函数和过程的状态select object_name,status from user_objects where object_type='FUNCTION'; select object_name,status from user_objects where object_type='PROCEDURE'; 查看函数和过程的源代码select text from all_source where owner=user and name=upper('&plsql_name'); 8、SQL时间计算 SELECT TO_CHAR(ADD_MONTHS(SYSDATE, -1), 'yyyyMMdd') SYY FROM DUAL; --计算上一个月 9、Oracle的connect by level的使用 获取连续数字示例代码: 1 -- 获取连续的数据(注意:level只用使用 |
CopyRight 2018-2019 实验室设备网 版权所有 |