Oracle
iteye_21126
这个作者很懒,什么都没留下…
展开
-
Oracle列转换行
select p.id, wmsys.wm_concat(d.day) from plan p left join plan_day d on p.plan_id=d.plan_id group by p.plan_id From: http://cache.baidu.com/c?m=9d78d513d9d437ad4f9b96697c15c0101b4381132b...原创 2011-09-28 14:47:55 · 110 阅读 · 0 评论 -
Oracle rownum
create table student (ID char(6), name VARCHAR2(100)); insert into student values('200001','张一'); insert into student values('200002','王二'); insert into student values('200003','李三'); insert in...2011-10-19 09:55:50 · 108 阅读 · 0 评论