摘要: 201705251537trcsess.awk 工具,使用类似如下:awk -f trcsess.awk xxx.trc > xxx.more 1615tvdztat -i ....trc -o xxx.html201705261604select t1.pname,t1.pval1,t1.pval 阅读全文
posted @ 2017-06-02 21:06 Oracle-fans 阅读(202) 评论(0) 推荐(0) 编辑
摘要: --先排序然后删除第n条数据delete from scott.emp where empno in (select empno from (select * from scott.emp where comm is null and rownum < 2 order by hiredate des 阅读全文
posted @ 2017-06-02 21:03 Oracle-fans 阅读(2307) 评论(0) 推荐(0) 编辑