| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mysql >> jiang shu ju cong MySQL qian dao Oracle de ji dian zhu yi shi xiang

jiang shu ju cong MySQL qian dao Oracle de ji dian zhu yi shi xiang

2008-07-19 08:21:39 编辑來源:互联网 评论
 
 
 
本文为【将数据从MySQL迁到Oracle的几点注意事项】的拼音翻译版
  you hen duo ying yong xiang mu , gang qi bu de shi hou yong MySQL shu ju ku ji ben shang neng shi xian ge zhong gong neng xu qiu , sui zhe ying yong yong hu de zeng duo , shu ju liang de zeng jia ,MySQL jian jian di chu xian bu kan chong fu de qing kuang : lian jie hen man shen zhi dang ji , yu shi jiu you ba shu ju cong MySQL qian dao Oracle de xu qiu , ying yong cheng xu ye yao xiang ying zuo yi xie xiu gai 。 ben ren zong jie chu yi xia ji dian zhu yi shi xiang , xi wang dui da jia you suo bang zhu 。
  1. zi dong zeng chang de shu ju lei xing chu li MySQL you zi dong zeng chang de shu ju lei xing , cha ru ji lu shi bu yong cao zuo ci zi duan , hui zi dong huo de shu ju zhi 。 Oracle mei you zi dong zeng chang de shu ju lei xing , xu yao jian li yi ge zi dong zeng chang de xu lie hao , cha ru ji lu shi yao ba xu lie hao de xia yi ge zhi fu yu ci zi duan 。
  CREATE SEQUENCE xu lie hao de ming cheng ( zui hao shi biao ming xu lie hao biao ji ) INCREMENT BY 1 START WITH 1 MAXVALUE 99999 CYCLE NOCACHE; qi zhong zui da de zhi an zi duan de chang du lai ding , ru guo ding yi de zi dong zeng chang de xu lie hao NUMBER(6) , zui da zhi wei 999999 INSERT yu ju cha ru zhe ge zi duan zhi wei : xu lie hao de ming cheng .NEXTVAL
  2. dan yin hao de chu li MySQL li ke yi yong shuang yin hao bao qi zi fu chuan ,Oracle li zhi ke yi yong dan yin hao bao qi zi fu chuan 。 zai cha ru he xiu gai zi fu chuan qian bi xu zuo dan yin hao de ti huan : ba suo you chu xian de yi ge dan yin hao ti huan cheng liang ge dan yin hao 。
  3. fan ye de SQL yu ju de chu li MySQL chu li fan ye de SQL yu ju bi jiao jian dan , yong LIMIT kai shi wei zhi , ji lu ge shu ;PHP li huan ke yi yong SEEK ding wei dao jie guo ji de wei zhi 。 Oracle chu li fan ye de SQL yu ju jiu bi jiao fan suo le 。 mei ge jie guo ji zhi you yi ge ROWNUM zi duan biao ming ta de wei zhi , bing qie zhi neng yong ROWNUM<100, bu neng yong ROWNUM>80。 yi xia shi jing guo fen xi hou jiao hao de liang zhong Oracle fan ye SQL yu ju ( ID shi wei yi guan jian zi de zi duan ming ):
  yu ju yi :
  SELECT ID, [FIELD_NAME,...] FROM TABLE_NAME WHERE
  ID IN ( SELECT ID FROM (SELECT ROWNUM AS NUMROW,
  ID FROM TABLE_NAME WHERE tiao jian 1 ORDER BY tiao jian 2)
  WHERE NUMROW > 80 AND NUMROW < 100 ) ORDER BY tiao jian 3;
  yu ju er :
  SELECT * FROM (( SELECT ROWNUM AS NUMROW,
  c.* from (select [FIELD_NAME,...]
  FROM TABLE_NAME WHERE tiao jian 1 ORDER BY tiao jian 2) c)
  WHERE NUMROW > 80 AND NUMROW < 100 ) ORDER BY tiao jian 3;
  4. chang zi fu chuan de chu li chang zi fu chuan de chu li Oracle ye you ta te shu de di fang 。INSERT he UPDATE shi zui da ke cao zuo de zi fu chuan chang du xiao yu deng yu 4000 ge dan zi jie , ru guo yao cha ru geng chang de zi fu chuan , qing kao lv zi duan yong CLOB lei xing , fang fa jie yong Oracle li zi dai de DBMS_LOB cheng xu bao 。 cha ru xiu gai ji lu qian yi ding yao zuo jin xing fei kong he chang du pan duan , bu neng wei kong de zi duan zhi he chao chu chang du zi duan zhi dou ying gai ti chu jing gao , fan hui shang ci cao zuo 。
  5. ri qi zi duan de chu li MySQL ri qi zi duan fen DATE he TIME liang zhong ,Oracle ri qi zi duan zhi you DATE, bao han nian yue ri shi fen miao xin xi , yong dang qian shu ju ku de xi tong shi jian wei SYSDATE, jing que dao miao , huo zhe yong zi fu chuan zhuan huan cheng ri qi xing han shu TO_DATE(‘2001-08-01’,’YYYY-MM-DD’) nian - yue - ri 24 xiao shi : fen zhong : miao de ge shi YYYY-MM-DD HH24:MI:SS TO_DATE() huan you hen duo zhong ri qi ge shi , ke yi shen kan Oracle DOC. ri qi xing zi duan zhuan huan cheng zi fu chuan han shu TO_CHAR(‘2001-08-01’,’YYYY-MM-DD HH24:MI:SS’) ri qi zi duan de shu xue yun suan gong shi you hen da de bu tong 。 MySQL zhao dao li dang qian shi jian 7 tian yong DATE_FIELD_NAME > SUBDATE((NOW(),INTERVAL 7 DAY) Oracle zhao dao li dang qian shi jian 7 tian yong DATE_FIELD_NAME >SYSDATE - 7;
  6. kong zi fu de chu li MySQL de fei kong zi duan ye you kong de nei rong ,Oracle li ding yi le fei kong zi duan jiu bu rong xu you kong de nei rong 。 an MySQL de NOT NULL lai ding yi Oracle biao jie gou , dao shu ju de shi hou hui chan sheng cuo wu 。 yin ci dao shu ju shi yao dui kong zi fu jin xing pan duan , ru guo wei NULL huo kong zi fu , xu yao ba ta gai cheng yi ge kong ge de zi fu chuan 。
  7. zi fu chuan de mo hu bi jiao MySQL li yong zi duan ming like Oracle li ye ke yi yong zi duan ming like dan zhe zhong fang fa bu neng shi yong suo yin , su du bu kuai yong zi fu chuan bi jiao han shu instr( zi duan ming , zi fu chuan )>0 hui de dao geng jing que de cha zhao jie guo 8. cheng xu he han shu li , cao zuo shu ju ku de gong zuo wan cheng hou qing zhu yi jie guo ji he zhi zhen de shi fang 。【原文】【汉音对照
 
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

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

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

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

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

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

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

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

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

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

 
 
you hen duo ying yong xiang mu , gang qi bu de shi hou yong MySQL shu ju ku ji ben shang neng shi xian ge zhong gong neng xu qiu , sui zhe ying yong yong hu de zeng duo , shu ju liang de zeng jia ,MySQL jian jian di chu xian bu kan chong fu de qing kuang : lian jie hen man shen zhi dang ji , yu shi jiu you ba shu ju cong MySQL qian dao Oracle de xu qiu , ying yong cheng xu ye yao xiang ying zuo yi xie xiu gai 。 ben ren zong jie chu yi xia ji dian zhu yi shi xiang , xi wang dui da jia you suo bang zhu 。 1. zi dong zeng chang de shu ju lei xing chu li MySQL you zi dong zeng chang de shu ju lei xing , cha ru ji lu shi bu yong cao zuo ci zi duan , hui zi dong huo de shu ju zhi 。 Oracle mei you zi dong zeng chang de shu ju lei xing , xu yao jian li yi ge zi dong zeng chang de xu lie hao , cha ru ji lu shi yao ba xu lie hao de xia yi ge zhi fu yu ci zi duan 。 CREATE SEQUENCE xu lie hao de ming cheng ( zui hao shi biao ming xu lie hao biao ji ) INCREMENT BY 1 START WITH 1 MAXVALUE 99999 CYCLE NOCACHE; qi zhong zui da de zhi an zi duan de chang du lai ding , ru guo ding yi de zi dong zeng chang de xu lie hao NUMBER(6) , zui da zhi wei 999999 INSERT yu ju cha ru zhe ge zi duan zhi wei : xu lie hao de ming cheng .NEXTVAL 2. dan yin hao de chu li MySQL li ke yi yong shuang yin hao bao qi zi fu chuan ,Oracle li zhi ke yi yong dan yin hao bao qi zi fu chuan 。 zai cha ru he xiu gai zi fu chuan qian bi xu zuo dan yin hao de ti huan : ba suo you chu xian de yi ge dan yin hao ti huan cheng liang ge dan yin hao 。 3. fan ye de SQL yu ju de chu li MySQL chu li fan ye de SQL yu ju bi jiao jian dan , yong LIMIT kai shi wei zhi , ji lu ge shu ;PHP li huan ke yi yong SEEK ding wei dao jie guo ji de wei zhi 。 Oracle chu li fan ye de SQL yu ju jiu bi jiao fan suo le 。 mei ge jie guo ji zhi you yi ge ROWNUM zi duan biao ming ta de wei zhi , bing qie zhi neng yong ROWNUM<100, bu neng yong ROWNUM>80。 yi xia shi jing guo fen xi hou jiao hao de liang zhong Oracle fan ye SQL yu ju ( ID shi wei yi guan jian zi de zi duan ming ): yu ju yi : SELECT ID, [FIELD_NAME,...] FROM TABLE_NAME WHERE ID IN ( SELECT ID FROM (SELECT ROWNUM AS NUMROW, ID FROM TABLE_NAME WHERE tiao jian 1 ORDER BY tiao jian 2) WHERE NUMROW > 80 AND NUMROW < 100 ) ORDER BY tiao jian 3; yu ju er : SELECT * FROM (( SELECT ROWNUM AS NUMROW, c.* from (select [FIELD_NAME,...] FROM TABLE_NAME WHERE tiao jian 1 ORDER BY tiao jian 2) c) WHERE NUMROW > 80 AND NUMROW < 100 ) ORDER BY tiao jian 3; 4. chang zi fu chuan de chu li chang zi fu chuan de chu li Oracle ye you ta te shu de di fang 。INSERT he UPDATE shi zui da ke cao zuo de zi fu chuan chang du xiao yu deng yu 4000 ge dan zi jie , ru guo yao cha ru geng chang de zi fu chuan , qing kao lv zi duan yong CLOB lei xing , fang fa jie yong Oracle li zi dai de DBMS_LOB cheng xu bao 。 cha ru xiu gai ji lu qian yi ding yao zuo jin xing fei kong he chang du pan duan , bu neng wei kong de zi duan zhi he chao chu chang du zi duan zhi dou ying gai ti chu jing gao , fan hui shang ci cao zuo 。 5. ri qi zi duan de chu li MySQL ri qi zi duan fen DATE he TIME liang zhong ,Oracle ri qi zi duan zhi you DATE, bao han nian yue ri shi fen miao xin xi , yong dang qian shu ju ku de xi tong shi jian wei SYSDATE, jing que dao miao , huo zhe yong zi fu chuan zhuan huan cheng ri qi xing han shu TO_DATE(‘2001-08-01’,’YYYY-MM-DD’) nian - yue - ri 24 xiao shi : fen zhong : miao de ge shi YYYY-MM-DD HH24:MI:SS TO_DATE() huan you hen duo zhong ri qi ge shi , ke yi shen kan Oracle DOC. ri qi xing zi duan zhuan huan cheng zi fu chuan han shu TO_CHAR(‘2001-08-01’,’YYYY-MM-DD HH24:MI:SS’) ri qi zi duan de shu xue yun suan gong shi you hen da de bu tong 。 MySQL zhao dao li dang qian shi jian 7 tian yong DATE_FIELD_NAME > SUBDATE((NOW(),INTERVAL 7 DAY) Oracle zhao dao li dang qian shi jian 7 tian yong DATE_FIELD_NAME >SYSDATE - 7; 6. kong zi fu de chu li MySQL de fei kong zi duan ye you kong de nei rong ,Oracle li ding yi le fei kong zi duan jiu bu rong xu you kong de nei rong 。 an MySQL de NOT NULL lai ding yi Oracle biao jie gou , dao shu ju de shi hou hui chan sheng cuo wu 。 yin ci dao shu ju shi yao dui kong zi fu jin xing pan duan , ru guo wei NULL huo kong zi fu , xu yao ba ta gai cheng yi ge kong ge de zi fu chuan 。 7. zi fu chuan de mo hu bi jiao MySQL li yong zi duan ming like Oracle li ye ke yi yong zi duan ming like dan zhe zhong fang fa bu neng shi yong suo yin , su du bu kuai yong zi fu chuan bi jiao han shu instr( zi duan ming , zi fu chuan )>0 hui de dao geng jing que de cha zhao jie guo 8. cheng xu he han shu li , cao zuo shu ju ku de gong zuo wan cheng hou qing zhu yi jie guo ji he zhi zhen de shi fang 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
华丽的模特拍摄(8)
华丽的模特拍摄(7)
华丽的模特拍摄(6)
华丽的模特拍摄(5)
八里沟
朝阳宫
天下峨眉 云上金顶
老家(四)
 
>>返回首页<<
 
 
 为你推荐
 
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
 
©2005- 王朝网络 版权所有