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;
/
怎么回事?????????
解决方案 »
- plsql检索出来的现实不全
- oracle 开发求解
- 求救:AMP8.0迁移oracle数据库,出现错误提示字符集不匹配,如何解决
- 高薪招聘,请进.
- 急找会oracel developer 2000人员,有程序可外包
- 9i乱码问题
- 求一个超简单SQL语句,关于表空间的。
- 如何限制同一用户名的登录?
- 怎样将SQL中的表导入到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 ....