打工人的博客

数据库版本11gSQL> select * from v$version;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionPL/SQL Release 11.2.0.4.0 - ProductionCORE

分页模板select *from (select *from (select a.*, rownum rnfrom (查询SQL) a)where rownum <= 10)where rn >= 1;创建测试表SYS@ora19c>create table t_page as select * from dba_objects;Table created.--注意所有列都是可...

历史库有张分区表有二十亿数据，有300w数据是重复的，开发写的删除脚本效率比较低。用开窗函数改写删除脚本，按分区来删除。select *from TABwhere rowid in (select ridfrom (select rowid as rid,RCVBL_AMT_ID,row_number() over...