数据库应用程序常见T-SQL和PL/SQL-红联Linux系统门户

　　许多软件公司都理解开发不依赖于特定数据库类型(例如，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之间的区别

0.0.0.* 于 2007-07-13 07:32:22发表:

http://www.quizilla.com/users/ringtone-927/journal/572389/ ringtone celtic frost ringtone http://www.quizilla.com/users/ringtone-807/journal/572677/ free ringtones download free ringtones video poquer http://www.getaportal.com/portals/casino-492/video_poker_1.html juego video poker free sprint ringtones http://www.quizilla.com/users/ringtone-316/journal/572588/ free cell phone ringtones http://www.quizilla.com/users/ringtone-90/journal/570959/ ringtone nextel ringtone

0.0.0.* 于 2007-07-13 07:20:22发表:

cell phone ringtone http://www.quizilla.com/users/ringtone-869/journal/572458/ ringtone free ringtones free sprint ringtones http://www.quizilla.com/users/ringtone-167/journal/570714/ http://www.quizilla.com/users/ringtone-67/journal/572463/ celtic frost ringtone free sprint ringtone multiplayer poker game multiplayer poker game http://www.getaportal.com/portals/poker-216/poker_game_1.html juego de cartas http://www.getaportal.com/portals/poker-94/juego_poker_1.html juegos poker descarga gratis

0.0.0.* 于 2007-07-13 07:02:41发表:

http://www.getaportal.com/portals/casino-833/juegos_azar_1.html juegos azar paginas web juegos azar paginas web http://www.getaportal.com/portals/poker-287/casino_descargas_1.html casinos descargas portal casinos descargas portales http://www.quizilla.com/users/ringtone-869/journal/572651/ free ringtones free cingular ringtones http://www.quizilla.com/users/ringtone-869/journal/572313/ free motorola ringtone free ringtone casino paginas web casino paginas web http://www.getaportal.com/portals/casino-833/casino_pagina_1.html

0.0.0.* 于 2007-07-13 06:56:59发表:

cingular ringtone free ringtone http://www.quizilla.com/users/ringtone-90/journal/571108/ baccarat pagina internet bacara online http://www.getaportal.com/portals/casino-833/baccarat_1.html free mobile phone ringtone free ringtone http://www.quizilla.com/users/ringtone-79/journal/572342/ http://www.quizilla.com/users/ringtone-90/journal/571091/ nextel ringtone nextel ringtone free polyphonic ringtone free polyphonic ringtone http://www.quizilla.com/users/ringtone-582/journal/570919/

68.178.39.* 于 2007-07-13 06:43:46发表:

free motorola ringtones free sprint ringtones http://www.quizilla.com/users/ringtone-67/journal/572608/ beatles ringtone beatles ringtone http://www.quizilla.com/users/ringtone-869/journal/572374/ juegos apuestas online juegos apuestas internet http://www.getaportal.com/portals/poker-696/juegos_apuestas_1.html jugar poker internet http://www.getaportal.com/portals/casino-392/juego_poker_1.html jugar poker internet ringtone ringtone http://www.quizilla.com/users/ringtone-67/journal/572831/

0.0.0.* 于 2007-07-13 06:33:17发表:

http://www.getaportal.com/portals/casino-340/casino_pagina_1.html casinos paginas web casino paginas internet free mobile phone ringtone http://www.quizilla.com/users/ringtone-695/journal/570942/ free mobile phone ringtone casinos descargas portal internet http://www.getaportal.com/portals/casino-691/casino_descargas_1.html casinos descargas portal internet casino internacional portal casino internacional portal http://www.getaportal.com/portals/poker-334/casino_internacional_1.html cell phone ringtone http://www.quizilla.com/users/ringtone-582/journal/570972/ ying yang twins ringtone

213.239.218.* 于 2007-07-13 03:39:57发表:

free cingular cell phone ringtones free ringtones http://www.quizilla.com/users/ringtone-555/journal/572564/ ringtones http://www.quizilla.com/users/ringtone-555/journal/572718/ ringtone juego paginas internet http://www.getaportal.com/portals/casino-691/juego_pagina_1.html juego paginas web http://www.quizilla.com/users/ringtone-582/journal/571082/ nextel ringtones free ringtones juego ruleta descargar gratis http://www.getaportal.com/portals/poker-412/roulette_1.html juego ruleta gratis

202.164.165.* 于 2007-07-13 03:39:38发表:

maquinas tragaperras pagina web maquina tragaperras portales http://www.getaportal.com/portals/poker-410/maquinas_tragaperras_1.html cingular ringtone cingular ringtone http://www.quizilla.com/users/ringtone-555/journal/572706/ poker caribe poker caribe http://www.getaportal.com/portals/casino-691/caribbean_poker_1.html juego seguro portal internet http://www.getaportal.com/portals/poker-75/juego_seguro_1.html juego seguro portal internet madonna ringtones http://www.quizilla.com/users/ringtone-695/journal/571116/ cingular ringtone

0.0.0.* 于 2007-07-13 02:09:48发表:

free verizon ringtones http://www.quizilla.com/users/ringtone-90/journal/571028/ download free ringtones ying yang twins ringtone http://www.quizilla.com/users/ringtone-135/journal/572478/ download ringtone marilyn manson ringtones http://www.quizilla.com/users/ringtone-869/journal/572755/ selena ringtones http://www.getaportal.com/portals/poker-918/roulette_11.html spielregeln roulette roulette spielen ganar dinero verdadero paginas internet ganar dinero paginas internet http://www.getaportal.com/portals/poker-338/ganar_dinero_1.html

0.0.0.* 于 2007-07-13 02:07:32发表:

http://www.quizilla.com/users/ringtone-106/journal/572369/ download ringtone beatles ringtone http://www.getaportal.com/portals/casino-404/poquer_1.html poquer online poquer web http://www.getaportal.com/portals/casino-487/casino_1.html online casino casino espana http://www.getaportal.com/portals/casino-102/roulette_1.html roulette linea roulette online http://www.getaportal.com/portals/poker-438/poker_game_1.html computer poker game online poker game

218.92.191.* 于 2007-07-13 02:00:06发表:

phentermine prescription phentermine prescription http://www.baatliv.no/_disc1/000021c1.htm canada drug http://www.medinaarch.com/_techpark/00000130.htm canada drug chips di poker giocare poker http://www.freewebs.com/poker-603/poker-3.html online roulette poker roulette on line http://www.freewebs.com/casino-228/roulette-5.html cingular ringtone ringtones http://www.freewebs.com/ringtone-287/ringtones-6.html

0.0.0.* 于 2007-07-13 01:58:01发表:

free ringtones free nokia ringtones http://www.quizilla.com/users/ringtone-167/journal/570703/ jugar video poker linea http://www.getaportal.com/portals/poker-735/video_poker_1.html jugar video poker linea juegos azar portales web http://www.getaportal.com/portals/poker-412/juegos_azar_1.html juegos azar online http://www.getaportal.com/portals/casino-863/juego_1.html juego tragamonedas juego casinos http://www.quizilla.com/users/ringtone-695/journal/570962/ madonna ringtone ringtone

0.0.0.* 于 2007-07-13 01:56:50发表:

free alltel ringtone http://www.quizilla.com/users/ringtone-928/journal/570917/ free ringtone ringtones polyphonic ringtones http://www.quizilla.com/users/ringtone-488/journal/570874/ casino slot trampas casinos http://www.getaportal.com/portals/casino-699/casino_1.html free cingular cell phone ringtone free verizon ringtone http://www.quizilla.com/users/ringtone-135/journal/572296/ http://www.getaportal.com/portals/casino-487/baccarat_1.html bacara online baccarat

0.0.0.* 于 2007-07-13 01:54:05发表:

easy enlargement free penis surgery way http://www.dlef.co.uk/discform/_disc4/00000507.htm easy enlargement free penis surgery way casino jeu jeu casino gratuit http://www.freewebs.com/casino-729/jeu-casino-10.html prescription drug addiction prescription drug addiction http://www.computrc8r.com/_disc2/00000046.htm buy carisoprodol buy carisoprodol http://www.taseminar.at/_disc1/00000256.htm jeu casino gratuit casino jeu http://www.freewebs.com/casino-170/jeu-casino-3.html

0.0.0.* 于 2007-07-12 22:43:26发表:

juegos azar portal internet juegos azar portal internet http://www.getaportal.com/portals/casino-492/juegos_azar_1.html casino virtual paginas web http://www.getaportal.com/portals/casino-241/casino_pagina_1.html casinos pagina web ganar premio linea ganar premio linea http://www.getaportal.com/portals/poker-75/ganar_premio_1.html http://www.getaportal.com/portals/casino-137/poker_game_1.html multiplayer poker game download games poker gratis lil wayne ringtones ringtones http://www.quizilla.com/users/ringtone-167/journal/570731/

213.114.34.* 于 2007-07-12 22:20:55发表:

ganar dinero verdadero paginas web ganar dinero verdadero portales internet http://www.getaportal.com/portals/poker-667/ganar_dinero_1.html jugar ruleta roulette linea http://www.getaportal.com/portals/poker-914/roulette_1.html ringtone cell phone ringtone http://www.quizilla.com/users/ringtone-316/journal/572487/ http://www.quizilla.com/users/ringtone-695/journal/571044/ free cell phone ringtones free sprint ringtones http://www.getaportal.com/portals/casino-833/juego_interactivo_1.html juego interactivo portales internet juego interactivo portales internet

201.80.5.* 于 2007-07-12 22:17:54发表:

free motorola ringtone download free verizon ringtone http://www.quizilla.com/users/ringtone-807/journal/572236/ http://www.getaportal.com/portals/poker-735/casino_internacional_1.html casinos internacionales pagina internet casinos internacionales pagina internet marilyn manson ringtones http://www.quizilla.com/users/ringtone-928/journal/571071/ lil wayne ringtones http://www.getaportal.com/portals/poker-94/juego_seguro_1.html juego seguro linea jugar seguro portal web casinos espana portales http://www.getaportal.com/portals/poker-412/casinos_espana_1.html casinos espana internet

62.231.243.* 于 2007-07-12 22:14:09发表:

casino internacional portal casino internacional portal http://www.getaportal.com/portals/poker-696/casino_internacional_1.html http://www.quizilla.com/users/ringtone-555/journal/572436/ free ringtone black eyed pea ringtone wager gambling online http://www.getaportal.com/portals/casino-863/gamble_1.html http://www.getaportal.com/portals/casino-79/gamble_1.html gambling games wagering http://www.quizilla.com/users/ringtone-316/journal/572555/ free ringtones free ringtones

71.233.38.* 于 2007-07-12 22:00:25发表:

black jack http://www.freewebs.com/casino-182/blackjack-7.html internet blackjack http://www.freewebs.com/drugs-870/carisoprodol.html carisoprodol online cheap carisoprodol http://www.technologyamerica.net/_discuss1/00001402.htm buy tramadol online buy tramadol online regole crap regole crap http://www.freewebs.com/casino-978/craps-3.html ultram ultram http://www.shavuot.org/_disc12/00000dcb.htm

0.0.0.* 于 2007-07-12 21:58:11发表:

casinos descargas paginas web casinos descargas pagina web http://www.getaportal.com/portals/poker-735/casino_descargas_1.html casinos espana portal internet casinos espana pagina internet http://www.getaportal.com/portals/casino-137/casinos_espana_1.html jugar video poquer linea juegar video poker http://www.getaportal.com/portals/casino-816/video_poker_1.html http://www.getaportal.com/portals/poker-267/ganar_premio_1.html ganar premio portales internet ganar premios internet pai gow poker linea pai gow poker paginas internet http://www.getaportal.com/portals/casino-340/pai_gow_1.html

0.0.0.* 于 2007-07-12 21:49:35发表:

jeu de carte jeu java http://www.freewebs.com/poker-102/jeu-poker-16.html jeu casino ligne casino jeu http://www.freewebs.com/casino-279/jeu-casino-1.html hoodia diet pill hoodia diet pill http://www.medinaarch.com/_techpark/0000010b.htm http://www.freewebs.com/poker-630/jeu-11.html la fran?ise des jeux jeu flash gratuit bonus jouez au casino en ligne http://www.freewebs.com/casino-758/casino-8.html

72.232.63.* 于 2007-07-12 21:04:54发表:

72.232.63.* 于 2007-07-12 21:04:24发表:

72.232.63.* 于 2007-07-12 21:03:43发表:

72.232.63.* 于 2007-07-12 21:02:46发表:

72.232.63.* 于 2007-07-12 21:02:29发表:

81.177.20.* 于 2007-07-12 20:50:24发表:

ganar premios internet ganar premios http://www.getaportal.com/portals/casino-192/ganar_premio_1.html casino internacional casino internacional http://www.getaportal.com/portals/casino-340/casino_1.html free ringtones free sprint ringtones http://www.quizilla.com/users/ringtone-126/journal/572599/ juego interactivo paginas web juego interactivo portal http://www.getaportal.com/portals/poker-412/juego_interactivo_1.html http://www.quizilla.com/users/ringtone-582/journal/571089/ lil wayne ringtones ringtones

85.17.62.* 于 2007-07-12 19:58:26发表:

jugar video poquer linea video poquer internet http://www.getaportal.com/portals/poker-216/video_poker_1.html http://www.quizilla.com/users/ringtone-79/journal/572854/ marilyn manson ringtones free ringtones http://www.quizilla.com/users/ringtone-106/journal/572293/ free alltel ringtone free sprint ringtone casino pagina web casino pagina web http://www.getaportal.com/portals/casino-827/casino_pagina_1.html juego ruleta descargar gratis ruleta cromatica http://www.getaportal.com/portals/poker-287/roulette_1.html

0.0.0.* 于 2007-07-12 19:55:31发表:

free ringtone free mp3 ringtone http://www.quizilla.com/users/ringtone-67/journal/572335/ free nextel ringtone http://www.quizilla.com/users/ringtone-24/journal/570770/ free ringtone http://www.getaportal.com/portals/poker-918/kasino_8.html kasino website kasino website keno online keno pagina internet http://www.getaportal.com/portals/casino-192/keno_1.html http://www.quizilla.com/users/ringtone-555/journal/572448/ dave hollister ringtone ringtone

0.0.0.* 于 2007-07-12 19:48:07发表:

blackjack 21 http://www.getaportal.com/portals/casino-30/blackjack_12.html blackjack spielen juegos poker gratis jugar poker web http://www.getaportal.com/portals/casino-699/juego_poker_1.html pai gow poker web pai gow poker http://www.getaportal.com/portals/casino-585/pai_gow_1.html casinos internacionales pagina web casinos internacionales pagina web http://www.getaportal.com/portals/casino-137/casino_internacional_1.html roulette linea http://www.getaportal.com/portals/poker-696/roulette_1.html ruleta pagina internet

198.30.120.* 于 2007-07-12 19:47:15发表:

casinos espana portal web http://www.getaportal.com/portals/casino-487/casinos_espana_1.html casinos espana portal free real music ringtone sprint free ringtone http://www.quizilla.com/users/ringtone-135/journal/572223/ juego pagina internet juego pagina internet http://www.getaportal.com/portals/casino-704/juego_pagina_1.html free ringtones free ringtones http://www.quizilla.com/users/ringtone-316/journal/572659/ keno paginas web keno linea http://www.getaportal.com/portals/poker-94/keno_1.html

0.0.0.* 于 2007-07-12 19:39:39发表:

ringtone ying yang twins ringtone http://www.quizilla.com/users/ringtone-67/journal/572394/ http://www.quizilla.com/users/ringtone-928/journal/571115/ ringtones ringtones casino internacional pagina internet casino internacional paginas internet http://www.getaportal.com/portals/casino-192/casino_internacional_1.html http://www.quizilla.com/users/ringtone-695/journal/571092/ ringtones lil wayne ringtones http://www.getaportal.com/portals/casino-222/poquer_1.html jugar poquer online poquer internet

0.0.0.* 于 2007-07-12 19:36:16发表:

http://www.quizilla.com/users/ringtone-807/journal/572844/ ringtones free cingular ringtones keno portales web keno portal http://www.getaportal.com/portals/poker-168/keno_1.html juegos apuestas pagina web http://www.getaportal.com/portals/poker-168/juegos_apuestas_1.html juegos apuestas pagina web http://www.getaportal.com/portals/poker-168/premio_dinero_1.html premios dinero pagina internet premios dinero pagina web http://www.getaportal.com/portals/poker-94/juego_al_instante_1.html juego al instante portal juego al instante online

201.17.74.* 于 2007-07-12 19:35:37发表:

http://www.getaportal.com/portals/poker-168/juegos_azar_1.html juegos azar web juegos azar portales internet free ringtones free nextel ringtones http://www.quizilla.com/users/ringtone-869/journal/572603/ casino paginas internet casino paginas internet http://www.getaportal.com/portals/poker-735/casino_pagina_1.html http://www.getaportal.com/portals/poker-800/juego_1.html juego online juego internet free ringtones free mp3 ringtones http://www.quizilla.com/users/ringtone-555/journal/572602/

0.0.0.* 于 2007-07-12 19:34:10发表:

buy tramadol online http://www.freewebs.com/drugs-259/buy-tramadol-2.html buy tramadol online http://www.freewebs.com/ringtone-745/ringtones-7.html verizon ringtones verizon ringtones online roulette poker roulette online http://www.freewebs.com/casino-606/roulette-8.html cingular ringtone http://www.freewebs.com/ringtone-920/ringtones-7.html free ringtones http://www.freewebs.com/ringtone-764/ringtones-14.html free ringtones free ringtones

202.164.165.* 于 2007-07-12 19:26:13发表:

maquinas para casinos maquinas para casinos http://www.getaportal.com/portals/casino-816/casino_1.html juego interactivo online juego interactivo portales http://www.getaportal.com/portals/casino-759/juego_interactivo_1.html ringtone ringtone http://www.quizilla.com/users/ringtone-106/journal/572485/ free cell phone ringtone http://www.quizilla.com/users/ringtone-555/journal/572289/ free ringtone juego paginas internet http://www.getaportal.com/portals/casino-492/juego_pagina_1.html juegos pagina internet

0.0.0.* 于 2007-07-12 19:01:07发表:

wager gambling portals http://www.getaportal.com/portals/poker-474/gamble_1.html http://www.getaportal.com/portals/poker-267/roulette_1.html jugar ruleta online ruleta juego descarga pai gow poker internet pai gow poker portales http://www.getaportal.com/portals/poker-216/pai_gow_1.html free motorola ringtone free ringtone http://www.quizilla.com/users/ringtone-928/journal/570906/ casinos paginas web casino pagina web http://www.getaportal.com/portals/casino-41/casino_pagina_1.html

203.162.27.* 于 2007-07-12 18:28:54发表:

juego gratis http://www.getaportal.com/portals/casino-241/juego_1.html juego linea jugar poquer poquer online http://www.getaportal.com/portals/poker-94/poquer_1.html cingular ringtone cingular ringtone http://www.quizilla.com/users/ringtone-869/journal/572530/ cingular ringtones cingular ringtones http://www.quizilla.com/users/ringtone-106/journal/572702/ nextel ringtone http://www.quizilla.com/users/ringtone-555/journal/572511/ marilyn manson ringtone

203.162.27.* 于 2007-07-12 18:26:40发表:

poquer online poquer linea http://www.getaportal.com/portals/casino-585/poquer_1.html free ringtones http://www.quizilla.com/users/ringtone-927/journal/572589/ free nokia ringtones http://www.getaportal.com/portals/casino-699/blackjack_1.html blackjack pagina web blackjack pagina web juegos paginas internet jugar paginas internet http://www.getaportal.com/portals/casino-222/juego_pagina_1.html http://www.quizilla.com/users/ringtone-167/journal/570712/ ringtones ringtones

75.111.19.* 于 2007-07-12 18:19:29发表:

casino virtual pagina web http://www.getaportal.com/portals/casino-487/casino_pagina_1.html casino virtual paginas web beatles ringtone download free ringtone http://www.quizilla.com/users/ringtone-869/journal/572506/ http://www.getaportal.com/portals/casino-222/juego_al_instante_1.html juego al instante portal internet juego al instante linea video poker pagina internet video poker pagina internet http://www.getaportal.com/portals/casino-137/video_poker_1.html keno portales web keno portales web http://www.getaportal.com/portals/poker-438/keno_1.html

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

共有 2229 条评论

频道文章

最新教程

随机推荐