Higer的博客

declare i integer; --定义变量 begin i := 1; loop /* 插入数据 */ insert into infoshar_1311960437 values (231+i,2+i,31+i,445,5+i,61+i,712+i,132+i,91+i,1013+i,112+i,12+i,133+i,14+i,i,161+i,1113+i,1

select * from (select * from TABLEb where b.reservation02 = ''order by b.fksj desc) where rownum = 1 select * from TABLE where fksj = (select max(b.fksj) from B_SQJW_XXFK b)