这个语名提示NUM1无效,求解答,这是从SQLSERVER改过来的!谢谢,兄弟没有分了declare
n number;
pageNum number;
pageIndex number;
count1 number;
num1 number;
begin
pageNum:=10;
pageIndex:=1;
num1:= pageIndex*pageNum;
select count(*) into count1 from NBMM_USER_MSG where mType=''+1+'';
if(count1<num1)
then
n:=count1-((pageIndex-1)*pageNum);
else
n:=pageNum;
end if;
Execute Immediate 'select mid,mtype,m_mid,m_floor,muser,mmail,muserip,msg,muserimg,mdate,count1 as allcount from (select * from (select * from NBMM_USER_MSG where mType=''+1+'' and rownum<=num1 order by mDate desc) A where rownum<=n order by mDate asc ) B order by mDate desc';
end;
n number;
pageNum number;
pageIndex number;
count1 number;
num1 number;
begin
pageNum:=10;
pageIndex:=1;
num1:= pageIndex*pageNum;
select count(*) into count1 from NBMM_USER_MSG where mType=''+1+'';
if(count1<num1)
then
n:=count1-((pageIndex-1)*pageNum);
else
n:=pageNum;
end if;
Execute Immediate 'select mid,mtype,m_mid,m_floor,muser,mmail,muserip,msg,muserimg,mdate,count1 as allcount from (select * from (select * from NBMM_USER_MSG where mType=''+1+'' and rownum<=num1 order by mDate desc) A where rownum<=n order by mDate asc ) B order by mDate desc';
end;
解决方案 »
- 在线等!!!!!!!!!!下面这个应该怎么改啊??
- 设计数据库时,n维,如何设计,求高人解答
- oracle 新建定期执行的作业需要什么权限?
- sql语句查询等级问题
- oracle触发器中NEW_VALUE和OLD_VALUE的问题。。谢谢大家了
- query error:ORA-00911: 无效字符
- 新手入门级问题,关于字母大小写的查询问题,譬如说ABC,abc,Abc,AbC这些类似的数据,我想一次就能都查询出来,怎么写这个语句?
- 请问,我错在那里?
- 高分求sql!
- 在VB中连接Oracle的问题??请高手指点呀!Oracle真的好奇怪~~~
- 数据库存储的数据去除空行
- Oracle编程时遇到的字符连接串疑惑
using num1,n;
在oracle中用||而不是+
如'a'||'b' ——> 'ab'
这句有问题,num1、n是变量,不能放在字符串里面,应该用连接符||连接