![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
lyx_yuki
这个作者很懒,什么都没留下…
展开
-
分页的存储过程
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原创 2006-12-30 18:57:00 · 1909 阅读 · 0 评论 -
sql语句删除重复记录
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)原创 2007-01-03 13:03:00 · 1941 阅读 · 0 评论 -
oracle触发器实现在归定的时间内不能添加数据
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原创 2007-01-02 09:04:00 · 2885 阅读 · 1 评论 -
oracle员工表精典查询
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原创 2007-01-11 21:10:00 · 2349 阅读 · 0 评论