
Oracle数据库
jacy_711
这个作者很懒,什么都没留下…
展开
-
数据库删除重复数据
delete from student s1 where s1.rowid in ( select s1.rowid from student s2 where s2.sid=s1.sid and s2.sname=s1.sname and s2.sex原创 2013-10-02 21:51:24 · 592 阅读 · 0 评论 -
游标使用,Oracle数据库按属性编辑成绩
create or replace function bb return nvarchar2 as -----------自定义游标类型 type class_student is record( sname varchar2(200), Oracle varchar2(200), Java varchar2(200), Android varch原创 2013-10-02 21:25:16 · 781 阅读 · 0 评论 -
PL/SQL分页查询
create or replace procedure fenye(tabelname in varchar2,currentpage in number,pageSize in number,inWhere in varchar2,myCursor out sys_refcursor) as v_sql varchar2(300); v_where varchar2(200); begin原创 2013-10-02 21:53:50 · 715 阅读 · 0 评论