ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 9i的bug?

9i的bug?

原创 Linux操作系统 作者:yellowlee 时间:2009-04-28 20:43:08 0 删除 编辑

create table t_test_card as
select '11111',
       '11111',
       '11111111111',
       '11111',
       '11111',
       '111111111111111',
       '111111111111111'
  from dual
 where 1 = 2;

select * from t_test_card ;

--子查询不行,显示的全是同一行
select *
  from t_billcard_mapping_fina@core a
 where --bill_no = '000021854276818'
 a.bill_no in (select lpad(danzhenghao, 15, '0') from t_test_card);

--子查询加rownum条件 ok
select *
  from t_billcard_mapping_fina@core a
 where --bill_no = '000021854276818'
 a.bill_no in (select lpad(danzhenghao, 15, '0') from t_test_card where rownum <10);

--连接ok
select a.*, b.danzhenghao, lpad(b.danzhenghao,15,'0')
  from t_billcard_mapping_fina@core a,
       t_test_card b
 where a.bill_no=lpad(b.danzhenghao,15,'0')

本地环境:
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
PL/SQL Release 9.2.0.1.0 - Production
CORE 9.2.0.1.0 Production
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
NLSRTL Version 9.2.0.1.0 - Production

远程环境:
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production


 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16179598/viewspace-592114/,如需转载,请注明出处,否则将追究法律责任。

下一篇: out of spring
请登录后发表评论 登录
全部评论

注册时间:2008-12-27

  • 博文量
    316
  • 访问量
    659625