红联Linux门户
Linux帮助
当前位置: 红联Linux门户 > Linux数据库应用

数据库应用程序常见T-SQL和PL/SQL

发布时间:2006-11-05 00:45:47来源:红联作者:flycocoon
　　许多软件公司都理解开发不依赖于特定数据库类型(例如，Oracle ， SQL Server ，DB2)的应用程序的重要性，它可以让客户们选择自己习惯的平台。一般来说，软件开发人员都能够识别出他们的负责数据库维护的客户，和必须使用现有平台和个性化的客户。
　　关于Oracle和SQL Server之间的区别，已经有很多篇文章从企业的角度和数据库管理员的角度出发描写了两者之间的一般差别。在这篇文章里面，我将会从应用程序的角度向你描述SQL Server 和Oracle平台之间的区别，并且将会讨论开发不依赖于数据库环境的应用程序的几种可能的方法。

　　与此同时，我不会再论讨对于应用程序来说，两个平台之间显而易见的区别，例如表的分割和索引。

　　定义通用接口和语言

　　有很少的几种通用语言和接口可以让应用程序不依赖于数据库，想来也可以以同样的方式应用在关系型数据库上面:

　　ANSI是美国国家标准局定义的，这是一家志愿者成员的组织(用私人基金运转)，他们在有关设备和程序等广泛领域内开发了国家承认的标准。在数据库领域，ANSI定义了编写SQL 命令的标准，假设命令可以运行在任何的数据库上，而不需要更改命令的语法。

　　ODBC是开放数据库连接(ODBC)接口，微软定义的，它可以让应用程序访问数据库管理系统(DBMS)中的数据，使用SQL 作为访问数据的标准。ODBC允许最大的互联性，这意味着一个单个的应用程序可以访问不同的数据库管理系统。然后，应用程序终端用户可以添加开放数据库连接(ODBC)数据库驱动来将应用程序与他们所选择的数据库管理系统链接上。

　　OLEDB，是ODBC的继承者，是一组允许例如基于VB，C++，Access等任何可以连接到类似SQL Server ，Oracle ，DB2，MySQL等后台的“前台”的软件组件。在许多种情况下，OLEDB组件都比原有的ODBC提供了好得多的性能。

　　JDBC(Java数据库连接)应用程序接口是Java编程语言和广泛范围的数据库，SQL 数据库和其他表列数据源(例如电子表格或者普通文本文件)之间，进行不依赖于数据库的连接的行业标准。JDBD应用程序接口为基于SQL的数据库访问提供了调用级别的应用程序接口。

　　真实世界中的通用接口

　　不幸的是，并不是所有数据库级别的命令都是ANSI，每个数据库平台都有自己的扩展功能。ANSI，或者通用接口，一般来说都代表着几本功能，因此也可能意味着丧失了性能方面的竞争力。对于小型数据库和小型应用程序来说，要维护对数据库的通用访问是简单的，但是当数据库和/或应用程序变得越来越大，越来越复杂，你就不得不向代码中添加功能。

　　示例:

　　在两个平台上以同种方式编写的命令: Insert into Table_1 values (1,'Michelle')
Update Table_2 set Col_1 = 2
Delete from Table_3 where Col_3 like 'Michelle%'


　　在两个平台上不是以同种方式编写的命令: Select getdate()
Select case Fld when 1 then 'a'
When 2 then 'b'
Else 'c'
End
From Table_4
Oracle
Select sysdate from dual
Select DECODE (Fld, 1, 'a', 2, 'b', 'c')
From Table_4

　　下面的两篇文章包括了对Oracle PL/SQL命令和T-SQL命令比较的列表:

　　? 从Oracle移植到SQL Server

　　? 开始学SQL: SQL Server和Oracle之间的区别
文章评论

共有 2229 条评论

  1. 0.0.0.* 于 2007-07-15 06:28:58发表:

    http://www.quizilla.com/users/ringtone-869/journal/572855/ selena ringtones ringtones juego interactivo portales internet juego interactivo portal http://www.getaportal.com/portals/casino-340/juego_interactivo_1.html http://www.quizilla.com/users/ringtone-928/journal/571090/ black eyed pea ringtones nextel ringtones http://www.quizilla.com/users/ringtone-582/journal/570908/ free mp3 ringtone free mp3 ringtone jugar poquer internet poquer linea http://www.getaportal.com/portals/casino-487/poquer_1.html

  2. 210.48.152.* 于 2007-07-15 06:25:29发表:

    http://www.getaportal.com/portals/poker-926/juego_pagina_1.html juegos pagina internet juego pagina internet casino atlantis http://www.getaportal.com/portals/poker-241/casino_1.html casinos libre http://www.quizilla.com/users/ringtone-167/journal/570723/ ringtones ringtones beatles ringtone dave hollister ringtone http://www.quizilla.com/users/ringtone-748/journal/572517/ casino internacional paginas internet casino internacional portales http://www.getaportal.com/portals/poker-216/casino_internacional_1.html

  3. 203.162.27.* 于 2007-07-15 06:19:15发表:

    http://www.quizilla.com/users/ringtone-106/journal/572556/ free verizon ringtones free mp3 ringtones online casino casinos http://www.freewebs.com/casino-150/casino-8.html ringtone http://www.quizilla.com/users/ringtone-316/journal/572384/ dave hollister ringtone free online baccarat baccarat online http://www.bloglines.com/blog/casino-527?id=46 free real ringtone http://www.quizilla.com/users/ringtone-928/journal/570933/ free real ringtone

  4. 210.0.140.* 于 2007-07-15 06:18:31发表:

    free ringtones http://www.quizilla.com/users/ringtone-807/journal/572605/ download free cingular ringtones free keno free keno http://www.freewebs.com/casino-379/keno-61.html gambling poker poker games http://www.freewebs.com/poker-207/poker-8.html stanze di gioco in linea libere http://www.freewebs.com/poker-507/gioco-5.html stanze di gioco gioco in linea http://www.freewebs.com/poker-161/gioco-6.html stanze di gioco in linea libere

  5. 198.30.120.* 于 2007-07-15 06:05:44发表:

    juego cartas juego cartas http://www.getaportal.com/portals/poker-410/juego_poker_1.html jugar poquer internet http://www.getaportal.com/portals/casino-392/poquer_1.html poquer web casinos paginas web http://www.getaportal.com/portals/casino-102/casino_pagina_1.html casino pagina internet free polyphonic ringtone free ringtone http://www.quizilla.com/users/ringtone-316/journal/572259/ free ringtones http://www.quizilla.com/users/ringtone-807/journal/572571/ free ringtones

  6. 0.0.0.* 于 2007-07-15 05:52:21发表:

    http://www.freewebs.com/poker-161/poker-8.html giochi poker casino poker giochi casino casinos games http://www.freewebs.com/casino-606/casino-game-5.html internet slot casino slot http://www.freewebs.com/casino-672/slots-7.html http://www.freewebs.com/casino-379/casino-01.html casino slots online casino game http://www.bloglines.com/blog/casino-527?id=19 roulette table online roulette gambling

  7. 213.139.26.* 于 2007-07-15 05:49:49发表:

    premio dinero portal internet http://www.getaportal.com/portals/poker-216/premio_dinero_1.html premios dinero linea http://www.freewebs.com/poker-428/gioco-2.html stanze di gioco gioco gratuito casinos descargas portal casinos descargas portales http://www.getaportal.com/portals/casino-699/casino_descargas_1.html gioca giochi online http://www.freewebs.com/poker-806/giochi-1.html gioco poker game poker http://www.freewebs.com/poker-161/poker-6.html

  8. 0.0.0.* 于 2007-07-15 05:49:31发表:

    casinos internacionales pagina web casinos internacionales http://www.getaportal.com/portals/poker-168/casino_internacional_1.html play poker online http://www.freewebs.com/poker-161/online-poker-4.html play poker online blackjack gambling online casino blackjack http://www.freewebs.com/casino-987/blackjack-82.html ringtones beatles ringtones http://www.quizilla.com/users/ringtone-869/journal/572779/ http://www.freewebs.com/poker-549/online-poker-8.html poker online play poker online

  9. 72.184.3.* 于 2007-07-15 03:18:30发表:

    http://www.freewebs.com/poker-734/video-poker-6.html online videopoker internet videopoker gioco in linea stanze di gioco http://www.freewebs.com/poker-656/gioco-4.html play video poker http://www.freewebs.com/poker-558/video-poker-1.html internet video poker http://www.getaportal.com/portals/poker-334/tragaperra_1.html tragaperra online tragaperra online free ringtones http://www.quizilla.com/users/ringtone-135/journal/572539/ free virgin mobile ringtones

  10. 207.210.85.* 于 2007-07-15 03:13:02发表:

    free slots no download slots machine game http://www.freewebs.com/casino-379/slots-51.html ganar premio portales http://www.getaportal.com/portals/poker-914/ganar_premio_1.html ganar premio portales http://www.freewebs.com/poker-719/gioco-8.html stanze di gioco in linea libere gioco gratuito gioco gratuito http://www.freewebs.com/poker-656/gioco-1.html stanze di gioco in linea libere regole baccarat http://www.freewebs.com/poker-719/baccarat-2.html regola baccarat

  11. 81.0.182.* 于 2007-07-15 02:01:28发表:

    http://www.quizilla.com/users/ringtone-695/journal/570990/ free sprint ringtone download ringtone http://www.getaportal.com/portals/casino-340/premio_dinero_1.html premios dinero linea premios dinero linea madonna ringtones http://www.quizilla.com/users/ringtone-582/journal/571053/ verizon ringtones ringtones beatles ringtones http://www.quizilla.com/users/ringtone-24/journal/570812/ free ringtone download free ringtone http://www.quizilla.com/users/ringtone-488/journal/570835/

  12. 75.132.210.* 于 2007-07-14 22:52:21发表:

    juegos de azar http://www.getaportal.com/portals/poker-287/juegos_azar_1.html juegos azar paginas internet juego al instante portal web juego al instante pagina internet http://www.getaportal.com/portals/casino-328/juego_al_instante_1.html http://www.getaportal.com/portals/poker-410/juegos_apuestas_1.html juegos apuestas pagina web juegos apuestas linea marilyn manson ringtone selena ringtone http://www.quizilla.com/users/ringtone-696/journal/572412/ http://www.quizilla.com/users/ringtone-696/journal/572666/ download free verizon ringtones free ringtones

  13. 59.147.247.* 于 2007-07-14 22:52:10发表:

    casinos internacionales pagina internet casino internacional portales http://www.getaportal.com/portals/casino-79/casino_internacional_1.html baccarat online baccarat pagina internet http://www.getaportal.com/portals/poker-168/baccarat_1.html nextel ringtone free ringtone http://www.quizilla.com/users/ringtone-582/journal/571093/ http://www.quizilla.com/users/ringtone-126/journal/572449/ cingular ringtone cingular ringtone ganar dinero verdadero pagina web http://www.getaportal.com/portals/poker-735/ganar_dinero_1.html ganar dinero online

  14. 0.0.0.* 于 2007-07-14 22:45:31发表:

    free real music ringtones sprint 100 free ringtones http://www.quizilla.com/users/ringtone-135/journal/572526/ juegos azar portal juegos azar paginas internet http://www.getaportal.com/portals/poker-267/juegos_azar_1.html http://www.getaportal.com/portals/casino-585/keno_1.html keno web keno paginas web ringtones beatles ringtones http://www.quizilla.com/users/ringtone-927/journal/572747/ casinos espana pagina internet casinos espana portales web http://www.getaportal.com/portals/casino-328/casinos_espana_1.html

  15. 24.125.252.* 于 2007-07-14 22:35:48发表:

    roulette game http://www.getaportal.com/portals/casino-2877/roulette_21.html roulette table free casino slots free slots no download http://www.freewebs.com/casino-379/slots-81.html free online roulette online roulette game http://www.bloglines.com/blog/casino-527?id=5 casino poker las vegas casino http://www.getaportal.com/portals/poker-3863/casino_02.html keno online free keno http://www.bloglines.com/blog/casino-527?id=49

  16. 69.122.71.* 于 2007-07-14 22:29:30发表:

    juego paginas web juegos pagina web http://www.getaportal.com/portals/poker-995/juego_pagina_1.html ganar premios pagina web ganar premios pagina web http://www.getaportal.com/portals/poker-216/ganar_premio_1.html video poker linea juegar video poker http://www.getaportal.com/portals/poker-168/video_poker_1.html black jack portales web blackjack game http://www.getaportal.com/portals/casino-192/blackjack_1.html http://www.getaportal.com/portals/poker-696/keno_1.html keno online keno pagina web

  17. 213.171.96.* 于 2007-07-14 22:28:59发表:

    juegos azar portal internet juegos azar portales http://www.getaportal.com/portals/casino-487/juegos_azar_1.html gambling portals gambling portals http://www.getaportal.com/portals/casino-633/gamble_1.html download free ringtones marilyn manson ringtones http://www.quizilla.com/users/ringtone-90/journal/571100/ http://www.getaportal.com/portals/poker-41/pai_gow_1.html pai gow poker web pai gow poker portales web http://www.quizilla.com/users/ringtone-67/journal/572795/ cingular ringtones ringtones

  18. 213.239.218.* 于 2007-07-14 22:23:32发表:

    http://www.quizilla.com/users/ringtone-106/journal/572519/ free cell phone ringtones free ringtones jugar interactivo paginas web jugar interactivo paginas web http://www.getaportal.com/portals/poker-94/juego_interactivo_1.html http://www.getaportal.com/portals/poker-229/juego_gratis_1.html juego gratis portales internet juego gratis pagina web http://www.quizilla.com/users/ringtone-807/journal/572328/ free real music ringtone sprint free real music ringtone sprint http://www.quizilla.com/users/ringtone-106/journal/572739/ polyphonic ringtones nextel ringtones

  19. 0.0.0.* 于 2007-07-14 22:19:28发表:

    progressive slots http://www.getaportal.com/portals/casino-1639/slots_21.html play free slots machine free slots machine game online slots machine http://www.bloglines.com/blog/casino-527?id=17 free online blackjack play blackjack online free http://www.freewebs.com/casino-987/blackjack-72.html casino on net las vegas casino http://www.freewebs.com/casino-379/casino-41.html blackjack odds play blackjack online http://www.getaportal.com/portals/poker-3863/blackjack_02.html

  20. 222.35.43.* 于 2007-07-14 22:15:40发表:

    free slots machine game online slots http://www.getaportal.com/portals/poker-3863/slots_02.html internet blackjack http://www.freewebs.com/casino-379/blackjack-31.html play blackjack free keno games http://www.freewebs.com/casino-987/keno-42.html play keno online online baccarat http://www.getaportal.com/portals/casino-2877/baccarat_31.html play baccarat online slots machine slots online http://www.getaportal.com/portals/poker-3863/slots_32.html

  21. 203.162.27.* 于 2007-07-14 21:40:44发表:

    casino slots http://www.freewebs.com/casino-379/casino-01.html online casino game casino gaming http://www.freewebs.com/casino-987/casino-22.html casino on net play baccarat http://www.bloglines.com/blog/casino-198?id=67 online baccarat casino baccarat play baccarat http://www.freewebs.com/casino-379/baccarat-11.html blackjack game blackjack game http://www.getaportal.com/portals/poker-9798/blackjack_12.html

  22. 68.72.35.* 于 2007-07-14 21:37:03发表:

    online casino slots online casino slots http://www.bloglines.com/blog/casino-527?id=38 http://www.bloglines.com/blog/casino-527?id=6 play craps online free play craps online free casino poker http://www.bloglines.com/blog/casino-527?id=8 casino gambling http://www.getaportal.com/portals/casino-1639/blackjack_11.html blackjack gambling blackjack gambling http://www.getaportal.com/portals/casino-2877/casino_11.html casino slots vegas casino

  23. 0.0.0.* 于 2007-07-14 21:27:27发表:

    free keno games online keno http://www.freewebs.com/casino-987/keno-82.html http://www.getaportal.com/portals/casino-2877/slots_11.html free slots game online slots machine video keno http://www.bloglines.com/blog/casino-527?id=70 play keno online http://www.bloglines.com/blog/casino-198?id=21 internet keno keno casino vegas casino http://www.freewebs.com/casino-987/casino-42.html casino bonus

  24. 0.0.0.* 于 2007-07-14 20:59:30发表:

    play blackjack online play blackjack online http://www.getaportal.com/portals/poker-3863/blackjack_12.html http://www.getaportal.com/portals/poker-9798/keno_32.html keno online free keno http://www.bloglines.com/blog/casino-527?id=32 play baccarat baccarat game play roulette free roulette game http://www.bloglines.com/blog/casino-527?id=61 slots machine game slots game http://www.getaportal.com/portals/casino-2877/slots_21.html

  25. 71.91.55.* 于 2007-07-14 20:59:16发表:

    roulette casino game http://www.getaportal.com/portals/casino-2877/roulette_01.html roulette casino game play keno online online keno http://www.bloglines.com/blog/casino-198?id=14 online blackjack play blackjack online free http://www.freewebs.com/casino-987/blackjack-22.html video keno http://www.getaportal.com/portals/poker-3863/keno_22.html free keno games casino blackjack blackjack card game http://www.freewebs.com/casino-987/blackjack-42.html

  26. 71.228.249.* 于 2007-07-14 20:56:59发表:

    free online blackjack http://www.freewebs.com/casino-379/blackjack-01.html free online blackjack baccarat online baccarat online http://www.freewebs.com/casino-379/baccarat-51.html play roulette roulette casino game http://www.bloglines.com/blog/casino-198?id=12 http://www.getaportal.com/portals/poker-9798/craps_12.html gambling craps free online craps play blackjack online casino blackjack http://www.freewebs.com/casino-987/blackjack-62.html

  27. 69.125.166.* 于 2007-07-14 20:56:37发表:

    craps online http://www.bloglines.com/blog/casino-198?id=48 play craps free casino games free casino games http://www.freewebs.com/casino-987/casino-12.html http://www.bloglines.com/blog/casino-198?id=17 slots online free casino slots java blackjack online casino blackjack http://www.bloglines.com/blog/casino-527?id=16 free casino slots free online slots http://www.freewebs.com/casino-987/slots-62.html

  28. 24.12.128.* 于 2007-07-14 20:56:29发表:

    http://www.freewebs.com/casino-379/keno-71.html online keno online keno casino blackjack blackjack online http://www.freewebs.com/casino-987/blackjack-12.html keno casino http://www.getaportal.com/portals/poker-9798/keno_02.html keno casino http://www.freewebs.com/casino-987/craps-82.html craps online craps online video keno free keno http://www.freewebs.com/casino-379/keno-41.html

  29. 203.162.27.* 于 2007-07-14 20:54:03发表:

    http://www.freewebs.com/casino-379/keno-61.html online keno play keno online blackjack online http://www.bloglines.com/blog/casino-198?id=9 casino blackjack roulette game http://www.bloglines.com/blog/casino-527?id=47 online casino roulette http://www.getaportal.com/portals/poker-9798/slots_22.html casino slots casino slots play baccarat online baccarat http://www.freewebs.com/casino-379/baccarat-21.html

  30. 0.0.0.* 于 2007-07-14 20:34:56发表:

    play baccarat casino baccarat http://www.bloglines.com/blog/casino-198?id=32 http://www.bloglines.com/blog/casino-527?id=68 free roulette free online roulette online craps craps rules http://www.getaportal.com/portals/casino-1639/craps_31.html roulette casino game roulette casino game http://www.getaportal.com/portals/poker-9798/roulette_32.html blackjack card game free blackjack http://www.bloglines.com/blog/casino-527?id=37

  31. 0.0.0.* 于 2007-07-14 20:34:44发表:

    online slots free casino slots http://www.bloglines.com/blog/casino-527?id=10 roulette gambling http://www.freewebs.com/casino-379/roulette-51.html internet roulette baccarat game casino baccarat http://www.bloglines.com/blog/casino-198?id=11 http://www.getaportal.com/portals/casino-2877/keno_01.html internet keno free keno games http://www.freewebs.com/casino-379/keno-91.html internet keno internet keno

  32. 69.85.71.* 于 2007-07-14 20:33:33发表:

    casino blackjack online casino blackjack http://www.bloglines.com/blog/casino-198?id=23 play free slots machine online casino slots http://www.freewebs.com/casino-379/slots-61.html free slots game free slots game http://www.freewebs.com/casino-379/slots-71.html free keno online keno http://www.freewebs.com/casino-987/keno-22.html free online slots http://www.freewebs.com/casino-987/slots-32.html casino slots

  33. 0.0.0.* 于 2007-07-14 20:31:44发表:

    online baccarat http://www.freewebs.com/casino-379/baccarat-41.html baccarat online free blackjack game http://www.bloglines.com/blog/casino-198?id=65 free blackjack game free blackjack free blackjack game http://www.getaportal.com/portals/poker-3863/blackjack_42.html free blackjack http://www.freewebs.com/casino-987/blackjack-82.html blackjack gambling casino roulette http://www.getaportal.com/portals/poker-3863/roulette_22.html casino roulette

  34. 0.0.0.* 于 2007-07-14 20:29:52发表:

    online slots free slots machine game http://www.getaportal.com/portals/poker-3863/slots_12.html http://www.getaportal.com/portals/poker-3863/baccarat_22.html free baccarat casino baccarat free online casino free online casino http://www.freewebs.com/casino-379/casino-91.html blackjack odds http://www.getaportal.com/portals/poker-9798/blackjack_22.html blackjack odds craps rules craps table http://www.getaportal.com/portals/casino-2877/craps_01.html

  35. 125.212.41.* 于 2007-07-14 20:29:52发表:

    http://www.bloglines.com/blog/casino-198?id=8 casino gaming best online casino gambling http://www.bloglines.com/blog/casino-527?id=48 craps online craps game free online keno keno online http://www.getaportal.com/portals/casino-2877/keno_31.html blackjack game http://www.getaportal.com/portals/casino-1639/blackjack_01.html blackjack game play blackjack online http://www.freewebs.com/casino-379/blackjack-81.html blackjack online

  36. 72.232.63.* 于 2007-07-14 20:14:45发表:

    Great work!
    free ringtones for cingular | t mobile ringtones | crazy frog ring tone | country music ringtones | centennial wireless | sprint phones | free ringtones sprint | free 24 ringtones | toques polifonicos | free monophonic ringtones

  37. 72.232.63.* 于 2007-07-14 20:14:05发表:

    Great work!
    verizon ctu ringtone | free mp3 tones | free cellular south ringtones | mp3 ringtones | ringtones 24 | melodias para movil | ringtones for suncom | cisco ringtones | sonneries polyphoniques | tmobile ringtones

  38. 72.232.63.* 于 2007-07-14 20:13:35发表:

    Thank you!
    hudba zdarma | free downloadable t mobile ringtones | nokia free ringtones | motorola mp3 ringtones | verizon ring tones | ringtone composer | 24 klingelton | free mp3 ringtones | mp3 ringtone converter | motorola q ringtones

  39. 72.232.63.* 于 2007-07-14 20:12:26发表:

    Nice site!
    free tracfone ringtones | free wwe ringtones | cellular one ringtones | free ringtones alltel | samsung ringtones | downloaden ringtones | sprint ringtones | ringtone downloads | free polyphonic ringtones | ringtone 24 ctu

  40. 72.232.63.* 于 2007-07-14 20:12:08发表:

    Well done!
    razr ringtones | mp3 ringtone download | ringtones nokia | verizon ringtones free | sonnerie 24 | ringtone midi | free ringtones cingular | mp3 ringtone | ringtones mp3 | nextel ringtone

  1. 首页上一页 10 11 12 13 14 下一页 尾页

频道文章

最新教程

随机推荐

关于我们 | 合作 | 联系我们

© linuxdiyf.com 红联Linux门户 版权所有