declare
pageno number(3);
pagesize number(3);
pagecount number(3);
recordcount number(5);
begin
pageno:=1;
pagesize:=5;
select count(*) into recordcount from student_info;
pagecount := ceil(recordcount/pagesize);
if pageno <1 then
pageno := 1;
end if;
if pageno > pagecount then
pageno := pagecount;
end if;
select * from student_info;
--select * from(select student_id,student_name,student_sex,born_date,class_no,ru_date,address,comment1,rownum as rown from student_info s)
--where rown between pageno*pagesize-pagesize+1 and pageno*pagesize;
end;刚才始使用 --select * from(select student_id,student_name,student_sex,born_date,class_no,ru_date,address,comment1,rownum as rown from student_info s)
--where rown between pageno*pagesize-pagesize+1 and pageno*pagesize;
现在只用select * from这一个简单的语句都提示错误
提示select 缺少 into语句
pageno number(3);
pagesize number(3);
pagecount number(3);
recordcount number(5);
begin
pageno:=1;
pagesize:=5;
select count(*) into recordcount from student_info;
pagecount := ceil(recordcount/pagesize);
if pageno <1 then
pageno := 1;
end if;
if pageno > pagecount then
pageno := pagecount;
end if;
select * from student_info;
--select * from(select student_id,student_name,student_sex,born_date,class_no,ru_date,address,comment1,rownum as rown from student_info s)
--where rown between pageno*pagesize-pagesize+1 and pageno*pagesize;
end;刚才始使用 --select * from(select student_id,student_name,student_sex,born_date,class_no,ru_date,address,comment1,rownum as rown from student_info s)
--where rown between pageno*pagesize-pagesize+1 and pageno*pagesize;
现在只用select * from这一个简单的语句都提示错误
提示select 缺少 into语句
Begin
Select * From dual;
End;这样也会报错在Plsql块中不能这样写
select * from student_info;
没有任何意义...你要打印的话,用
先SLECET 字段1,,,, into 变量1,.... from
DBMS_OUTPUT.PUTLINE(变量1,.... )
或者执行动态语句
参考http://zzx0421.javaeye.com/blog/281015
pagecount number(3);
recordcount number(3);
begin
pageno:=1;
pagesize:=5;
select count(*) into recordcount from student_info;
pagecount := ceil(recordcount/pagesize);
if pageno <1 then
pageno := 1;
end if;
if pageno > pagecount then
pageno := pagecount;
end if;
open v_stuinfo for
select * from(select student_id,student_name,student_sex,born_date,class_no,ru_date,address,comment1,rownum as rown from student_info s)
where rown between pageno*pagesize-pagesize+1 and pageno*pagesize;
end page_set;PROCEDURE IGHACK.PAGE_SIZE_SET 编译错误错误:PLS-00103: 出现符号 "("在需要下列之一时:
:= . ) , @ % default
character
符号 ":=" 被替换为 "(" 后继续。
行:1
文本:create or replace procedure page_size_set(pageno in number(3),pagesize in number(3),v_stuinfo out ighack.v_ref_stuinfo)错误:PLS-00103: 出现符号 "("在需要下列之一时:
:= . ) , @ % default
character
符号 ":=" 被替换为 "(" 后继续。
行:1
文本:create or replace procedure page_size_set(pageno in number(3),pagesize in number(3),v_stuinfo out ighack.v_ref_stuinfo)
提示select 缺少 into语句plsql里不能写没有into 变量 的select语句
支持!!!
要不into,要不返回游标