不落的太阳

procedure query(page number,sub_id number,cur out mycur) is  v_begin number; v_end   number; begin      v_begin:=rows_per_page*(page-1);      v_end:=rows_per_page*page;      open cur for       select

select * from login a where rowid!=(select min(rowid) from login b where a.username=b.username)  delete from login a  where rowid!=(select max(rowid) from login b where a.username=b.username) 

create or replace trigger trg_IU  before insert or update or delete on table_bill    for each rowdeclare  v_str varchar2(10);beginif inserting thenv_str:=insert;elsev_str:=update;end if;insert int

 select * from(select * from(select * from emp where sal is not null order by sal desc )where rownum(select * from(select * from emp where hiredate is not null order by hiredate desc )where rownumwher