本月博客排行
年度博客排行
-
第1名
青否云后端云 -
第2名
zw7534313 -
第3名
大家都说我很棒 - liyihz2008
- wy_19921005
- gengyun12
- hbxflihua
- e_e
- luxurioust
- dbagirl
- zysnba
- robotmen
- Alsmile
- gaozzsoft
- jywhltj
- cpongo1
- leslie26
- qepwqnp
- zhangdaiscott
- 解宜然
- cuityang
- sichunli_030
- gashero
- fantaxy025025
- vipbooks
- gdpglc
- wallimn
- ssydxa219
- ranbuijj
- javashop
- jickcai
- hanbaohong
- johnsmith9th
- appalese
- gaojingsong
- weiyides
- 淡看人生
- zhangyi0618
- java-007
- AVI
- laiyangdeli
- xpenxpen
- liunancun
- 龙哥IT
- conkeyn
- nychen2000
- lyndon.lin
- ouanui
- silverend
- jveqi
最新文章列表
经典的Oracle分页
1、按rowid分页
select * from area where rowid in(select rid from (select rownum rn,rid from(select rowid rid,id fromarea order by id desc ) where rownum<82000) where rn>81980) order by id desc;
...
数据库sql分页
取出sql表中第31到40的记录(以自动增长ID为主键)
sql server方案1:
select
top 10 * from t where id not in (select top 30 id from t order by id ) orde by
id
sql server方案2:
select
top 10 * from t where id in ( ...
Oracle数据库中的分页语句
方式一:
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
)
WHERE RN BETWEEN 3*(3-1)+1 AND 3*3
方式二分页查询格式:
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME ORDER ...
ch02 oracle基础二
本章任务
1:游标
--
DECLARE
CURSOR sales_cur IS SELECT * FROM EMP;
BEGIN
FOR sales_rec IN sales_cur LOOP
DBMS_OUTPUT.PUT_LINE('工资:'||sales_rec.empno);
END LOOP;
END;
/
2:存储过程与函数 ...