create or replace procedure find_bypage(pages number) is
begin
select * from(select rownum pages,* from book) where pages>(pages-1)
*10 and pages<pages*10;
end;
/
怎么回事?????????
begin
select * from(select rownum pages,* from book) where pages>(pages-1)
*10 and pages<pages*10;
end;
/
怎么回事?????????
解决方案 »
- 请教一个SQL计数问题
- 9i 2003 群集 思科 ASA-5520-K8 远程连接超时问题
- 急救
- sql高手帮忙
- 请问,如何实现这个查询功能
- oracle9i安装出现问题,怎么卸载才能卸载干净不影响以后安装
- ORACLE的猪头问题ORA-01722错误
- 用orcaleclient 了解orcale8.17(字符集:AMERICA US7ASCII) 取出的数据为什么都是乱码,怎么解决啊
- 用触发器中,我想得到当前被UpDate的行的rowid?应该如何实现???
- Oracle的登录问题!
- 请问高人:定时间每隔一个月运行一次存储过程,时间那段如何计算( DBMS—JOB。SUBMIT(:JOBNO,‘PROCEDURE—NAME’,SYSDATE,‘SYSDA
- unix下 oralce 8.0.5 连接unix 下8.1.6的问题
where pages between (pages-1)*10+1 to pages*10;
create or replace procedure find_bypage(pages number) is
begin
select * from(select rownum pages,* from book)
where pages between (pages-1)*10+1 to pages*10;
end;
/
SQL> show err;
PROCEDURE FINDBOOKBY_PAGE 出现错误:LINE/COL ERROR
-------- -----------------------------------------------------------------
3/35 PLS-00103: 出现符号 "*"在需要下列之一时:
(-+modnull<an identifier>
<a double-quoted delimited-identifier><a bind variable>table
avgcountcurrentmaxminpriorsqlstddevsumvarianceexecutethe
foralltimetimestampintervaldate
<a string literal with character set specification>
<a number><a single-quoted SQL string>3/81 PLS-00103: 出现符号 "TO"在需要下列之一时:
*&-+/atmodrem
<an exponent (**)>and||LINE/COL ERROR
-------- -----------------------------------------------------------------
符号 "and在 "TO" 继续之前已插入。
where pages between (pages-1)*10+1 and pages*10;
create or replace procedure findbookby_page(pages number) is
begin
select * from(select rownum pages,* from book) where pages between (pages-1)*10+1 and pages*10;
end;
/
警告: 创建的过程带有编译错误。SQL> show err;
PROCEDURE FINDBOOKBY_PAGE 出现错误:LINE/COL ERROR
-------- -----------------------------------------------------------------
3/35 PLS-00103: 出现符号 "*"在需要下列之一时:
(-+modnull<an identifier>
<a double-quoted delimited-identifier><a bind variable>table
avgcountcurrentmaxminpriorsqlstddevsumvarianceexecutethe
foralltimetimestampintervaldate
<a string literal with character set specification>
<a number><a single-quoted SQL string>
select ..... into.....from ....