| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> oracle >> shen ru tan tao Oracle shu ju ku cun chu guo cheng de ruo gan wen ti
 

shen ru tan tao Oracle shu ju ku cun chu guo cheng de ruo gan wen ti

2008-08-03 06:51:33 编辑來源:互联网 评论
 
本文为【深入探讨Oracle数据库存储过程的若干问题】的拼音翻译版
  1. zai oracle zhong , shu ju biao bie ming bu neng jia as, ru :
  select a.appname from appinfo a;-- zheng que
  select a.appname from appinfo as a;-- cuo wu
  ye xu , shi pa he oracle zhong de cun chu guo cheng zhong de guan jian zi as chong tu de wen ti ba
  2. zai cun chu guo cheng zhong ,select mou yi zi duan shi , hou mian bi xu jin gen into, ru guo select zheng ge ji lu , li yong you biao de hua jiu ling dang bie lun le 。
  select af.keynode into kn from APPFOUNDATION af where af.appid=aid and af.foundationid=fid;-- you into, zheng que bian yi
  select af.keynode from APPFOUNDATION af where af.appid=aid and af.foundationid=fid;-- mei you into, bian yi bao cuo , ti shi :Compilation
  Error: PLS-00428: an INTO clause is expected in this Select statement
  3. zai li yong select...into... yu fa shi , bi xu xian que bao shu ju ku zhong you gai tiao ji lu , fou ze hui bao chu "no data found" yi chang 。
  ke yi zai gai yu fa zhi qian , xian li yong select count(*) from cha kan shu ju ku zhong shi fou cun zai gai ji lu , ru guo cun zai , zai li yong select...into...
  4. zai cun chu guo cheng zhong , bie ming bu neng he zi duan ming cheng xiang tong , fou ze sui ran bian yi ke yi tong guo , dan zai yun xing jie duan hui bao cuo
  select keynode into kn from APPFOUNDATION where appid=aid and foundationid=fid;-- zheng que yun xing
  select af.keynode into kn from APPFOUNDATION af where af.appid=appid and af.foundationid=foundationid;-- yun xing jie duan bao cuo , ti shi
  orA-01422:exact fetch returns more than requested number of rows
  5. zai cun chu guo cheng zhong , guan yu chu xian null de wen ti
  jia she you yi ge biao A, ding yi ru xia :
  create table A(
  id varchar2(50) primary key not null,
  vcount number(8) not null,
  bid varchar2(50) not null -- wai jian
  ); ru guo zai cun chu guo cheng zhong , shi yong ru xia yu ju :
  select sum(vcount) into fcount from A where bid='xxxxxx'; ru guo A biao zhong bu cun zai bid="xxxxxx" de ji lu , ze fcount=null( ji shi fcount ding yi shi she zhi le mo ren zhi , ru :fcount number(8):=0 yi ran wu xiao ,fcount huan shi hui bian cheng null), zhe yang yi hou shi yong fcount shi jiu ke neng you wen ti , suo yi zai zhe li zui hao xian pan duan yi xia :
  if fcount is null then
  fcount:=0;
  end if; zhe yang jiu yi qie ok le 。
  6.Hibernate tiao yong oracle cun chu guo cheng
  this.pnumberManager.getHibernateTemplate().execute(
  new HibernateCallback() ...{
  public Object doInHibernate(Session session)
  throws HibernateException, SQLException ...{
  CallableStatement cs = session
  .connection()
  .prepareCall("{call modifyapppnumber_remain(?)}");
  cs.setString(1, foundationid);
  cs.execute();
  return null;
  }
  });【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
1. zai oracle zhong , shu ju biao bie ming bu neng jia as, ru : select a.appname from appinfo a;-- zheng que select a.appname from appinfo as a;-- cuo wu ye xu , shi pa he oracle zhong de cun chu guo cheng zhong de guan jian zi as chong tu de wen ti ba 2. zai cun chu guo cheng zhong ,select mou yi zi duan shi , hou mian bi xu jin gen into, ru guo select zheng ge ji lu , li yong you biao de hua jiu ling dang bie lun le 。 select af.keynode into kn from APPFOUNDATION af where af.appid=aid and af.foundationid=fid;-- you into, zheng que bian yi select af.keynode from APPFOUNDATION af where af.appid=aid and af.foundationid=fid;-- mei you into, bian yi bao cuo , ti shi :Compilation Error: PLS-00428: an INTO clause is expected in this Select statement 3. zai li yong select...into... yu fa shi , bi xu xian que bao shu ju ku zhong you gai tiao ji lu , fou ze hui bao chu "no data found" yi chang 。 ke yi zai gai yu fa zhi qian , xian li yong select count(*) from cha kan shu ju ku zhong shi fou cun zai gai ji lu , ru guo cun zai , zai li yong select...into... 4. zai cun chu guo cheng zhong , bie ming bu neng he zi duan ming cheng xiang tong , fou ze sui ran bian yi ke yi tong guo , dan zai yun xing jie duan hui bao cuo select keynode into kn from APPFOUNDATION where appid=aid and foundationid=fid;-- zheng que yun xing select af.keynode into kn from APPFOUNDATION af where af.appid=appid and af.foundationid=foundationid;-- yun xing jie duan bao cuo , ti shi orA-01422:exact fetch returns more than requested number of rows 5. zai cun chu guo cheng zhong , guan yu chu xian null de wen ti jia she you yi ge biao A, ding yi ru xia : create table A( id varchar2(50) primary key not null, vcount number(8) not null, bid varchar2(50) not null -- wai jian ); ru guo zai cun chu guo cheng zhong , shi yong ru xia yu ju : select sum(vcount) into fcount from A where bid='xxxxxx'; ru guo A biao zhong bu cun zai bid="xxxxxx" de ji lu , ze fcount=null( ji shi fcount ding yi shi she zhi le mo ren zhi , ru :fcount number(8):=0 yi ran wu xiao ,fcount huan shi hui bian cheng null), zhe yang yi hou shi yong fcount shi jiu ke neng you wen ti , suo yi zai zhe li zui hao xian pan duan yi xia : if fcount is null then fcount:=0; end if; zhe yang jiu yi qie ok le 。 6.Hibernate tiao yong oracle cun chu guo cheng this.pnumberManager.getHibernateTemplate().execute( new HibernateCallback() ...{ public Object doInHibernate(Session session) throws HibernateException, SQLException ...{ CallableStatement cs = session .connection() .prepareCall("{call modifyapppnumber_remain(?)}"); cs.setString(1, foundationid); cs.execute(); return null; } });
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
时尚性感的燕子(3)
时尚性感的燕子(2)
纯美的女生生活写真(14)
纯美的女生生活写真(13)
来自束河[]
恰巧-巧家~~
高尔夫
行摄匆匆天子山
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有