select vc_sendtranno,nu_sendrecords,dt_trandatetime
from t_tran_type where vc_shopid='002042'有数据吗
from t_tran_type where vc_shopid='002042'有数据吗
解决方案 »
- OleDbCommand Parameter 时 IN 关键字查询问题
- oracle的存储过程里只能select into 而不能直接select ?
- sql 中查找表名为中文带-,有人告诉用双引号,但双引号怎么加呢????
- oracle中使用clientdataset的applyupdates进行提交提示表或视图不存在
- 不装Oracle客户端怎么运行编译好的exe
- sql plus 中,修改上次错误的查询用什么命令?
- 在线等待,解决就地加分:关于Oracle中的游标!!!为什么最后一条记录会出现两次,如何解决
- 如何解决在单机WIN2000下安装ORACLE8.0.5后TNSLISTER不能启动问题
- nvl(a/24,0)(a<24)的值是0?
- 查看某个用户属于哪个表空间
- 如何实现表的复制(SQL SERVER 里面的select * into newtablename from oldtablename)
- 关于oralce9.2.0.1.0链接问题???
tranno varchar2(50);
srcrecords varchar2(50);
trandatetime date;
destshopid varchar(20);begin
destshopid:='002042';
select vc_sendtranno,nu_sendrecords,dt_trandatetime into tranno,srcrecords,trandatetime from t_tran_type where vc_shopid=destshopid and rownum<2;
没有vc_shopid = '002042'的记录,肯定报错嘛!
declare
tranno varchar2(50);
srcrecords varchar2(50);
trandatetime date;
destshopid varchar(20);begin
destshopid:='002042';
select vc_sendtranno,nu_sendrecords,dt_trandatetime into tranno,srcrecords,trandatetime from t_tran_type where vc_shopid=destshopid and rownum<2;建议以后定义这种变量的时候请用destshopid t_tran_type.vc_shopid%type;
select vc_sendtranno,nu_sendrecords,dt_trandatetime into tranno,srcrecords,trandatetime from t_tran_type where vc_shopid='002042' and rownum<2;就没问题
destshopid是varchar2类型的,destshopid:=002042时,会自动先把002042作为number,化成2042,再转化成varchar2型,即'2042',所以实际上变成了destshopid:='2042'。应该是:declare
tranno varchar2(50);
srcrecords varchar2(50);
trandatetime date;
destshopid varchar(20);begin
destshopid:='002042';
select vc_sendtranno,nu_sendrecords,dt_trandatetime
into tranno,srcrecords,trandatetime
from t_tran_type
where vc_shopid=destshopid and rownum<2;end;