oracle常用sql命令(持续补充中)

1、统计当前用户所有表的行数

ANALYZE TABLE 表名 COMPUTE STATISTICS;

select table_name,num_rows from user_tables;

 

2、修改用户密码

登录sys/system用户

ALTER USER user_name IDENTIFIED BY "XXXX";

 

3、Oracle使用rownum进行分页

SELECT *
FROM (SELECT a.*, ROWNUM rn
FROM (SELECT * FROM table_name) a
WHERE ROWNUM <= pageIndex * pageSize)
WHERE rn > (pageIndex - 1) * pageSize