韭菜园

http://www.cnblogs.com/cangos/archive/2011/12/08/2280910.html

----------------------------------------------------------------------创建一个存储过程、用来给oracle作业调用--------------------------------------------------------------------create or replace procedure PL...

//如果出现误删或者误操作表数据、这条语句有时候灵验。--delete mytable;insert into mytable select * from mytable as of timestamp to_timestamp('2011-11-16 14:00:00','YYYY-MM-DD HH24:MI:SS');...

[code="java"]//1，先对表中的num进行排升序//2，查询排序后各自的rownum值//3，查询num='3339999'排序后的rownum值select temprow from (select rownum as temprow,num from (select num from mob_num_info order by num)) where num='33...