数据库应用程序常见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之间的区别

68.56.102.* 于 2007-07-12 18:15:13发表:

juego paginas web juegos paginas web http://www.getaportal.com/portals/poker-880/juego_pagina_1.html download free verizon ringtone free mp3 ringtone http://www.quizilla.com/users/ringtone-90/journal/570905/ free nextel ringtone free nextel ringtone http://www.quizilla.com/users/ringtone-79/journal/572330/ premios dinero premio dinero paginas internet http://www.getaportal.com/portals/casino-759/premio_dinero_1.html jugar poker linea juego cartas http://www.getaportal.com/portals/casino-340/juego_poker_1.html

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

fast cash advance payday loan fast cash advance payday loan http://www.freewebs.com/cash-920/fast-cash-advance-payday-loan.html free ringtones free ringtones http://www.freewebs.com/ringtone-939/free-ringtones.html fioricet online fioricet online http://www.coloradotbf.net/Discussion/0000013d.htm internet slot machine online slots http://www.freewebs.com/casino-674/slots-8.html phentermine diet pill phentermine diet pill http://vikimason.com/_disc3/0000084d.htm

0.0.0.* 于 2007-07-12 18:05:40发表:

ringtones ringtones http://www.quizilla.com/users/ringtone-135/journal/572682/ http://www.getaportal.com/portals/poker-412/juego_al_instante_1.html juego al instante internet juego al instante paginas web dave hollister ringtone beatles ringtone http://www.quizilla.com/users/ringtone-807/journal/572408/ jugar video poquer web jugar video poquer web http://www.getaportal.com/portals/casino-633/video_poker_1.html pai gow poker linea http://www.getaportal.com/portals/poker-168/pai_gow_1.html pai gow poker portal web

0.0.0.* 于 2007-07-12 13:53:15发表:

casino blackjack http://www.getaportal.com/portals/casino-41/blackjack_1.html blackjack online http://www.quizilla.com/users/ringtone-748/journal/572768/ selena ringtones cingular ringtone baccarat online bacara online http://www.getaportal.com/portals/poker-94/baccarat_1.html casinos espana internet casinos espana online http://www.getaportal.com/portals/poker-926/casinos_espana_1.html jugar paginas internet http://www.getaportal.com/portals/casino-79/juego_pagina_1.html juego paginas web

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

http://www.getaportal.com/portals/poker-914/juegos_apuestas_1.html juegos apuestas portal internet jugar apostar pagina web free cell phone ringtone http://www.quizilla.com/users/ringtone-927/journal/572229/ free real music ringtone sprint probabilidades ruleta jugar ruleta online http://www.getaportal.com/portals/casino-863/roulette_1.html ringtone nextel ringtone http://www.quizilla.com/users/ringtone-79/journal/572537/ ringtones http://www.quizilla.com/users/ringtone-696/journal/572858/ free cingular ringtones

0.0.0.* 于 2007-07-12 11:51:23发表:

100 free ringtone free ringtone http://www.quizilla.com/users/ringtone-24/journal/570763/ dave hollister ringtone http://www.quizilla.com/users/ringtone-90/journal/570963/ marilyn manson ringtone free ringtones free nextel ringtones http://www.quizilla.com/users/ringtone-126/journal/572533/ http://www.quizilla.com/users/ringtone-135/journal/572741/ marilyn manson ringtones cingular ringtones free mobile phone ringtone http://www.quizilla.com/users/ringtone-79/journal/572207/ free mp3 ringtone

71.142.76.* 于 2007-07-12 11:49:23发表:

ringtones lil wayne ringtones http://www.quizilla.com/users/ringtone-695/journal/571076/ http://www.quizilla.com/users/ringtone-869/journal/572386/ verizon ringtone verizon ringtone http://www.getaportal.com/portals/casino-328/casino_internacional_1.html casino internacional linea casino internacional linea http://www.getaportal.com/portals/casino-102/video_poker_1.html jogar video poquer video poker pagina internet madonna ringtone madonna ringtone http://www.quizilla.com/users/ringtone-24/journal/570784/

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

internet videopoker internet video poker http://www.freewebs.com/poker-806/video-poker-6.html http://www.freewebs.com/drugs-591/phentermine-2.html phentermine pill cheapest phentermine online videopoker internet video poker http://www.freewebs.com/poker-818/video-poker-4.html free cingular ringtones free nokia ringtones http://www.freewebs.com/ringtone-136/free-ringtones-7.html buy cialis cialis http://www.freewebs.com/drugs-591/cialis.html

68.13.227.* 于 2007-07-12 10:58:03发表:

selena ringtones http://www.quizilla.com/users/ringtone-316/journal/572788/ cingular ringtone tragaperras portales internet http://www.getaportal.com/portals/casino-102/tragaperra_1.html tragaperras ganar dinero verdadero portales gana dinero web http://www.getaportal.com/portals/casino-102/ganar_dinero_1.html http://www.getaportal.com/portals/poker-800/poker_1.html holdempoker play poker http://www.quizilla.com/users/ringtone-927/journal/572832/ free ringtones madonna ringtones

67.15.92.* 于 2007-07-12 10:41:09发表:

cingular ringtone selena ringtone http://www.quizilla.com/users/ringtone-582/journal/570996/ juego gratis portales internet jugar gratis paginas internet http://www.getaportal.com/portals/casino-404/juego_gratis_1.html http://www.getaportal.com/portals/casino-816/premio_dinero_1.html premios dinero online premio dinero portales http://www.quizilla.com/users/ringtone-582/journal/571029/ free ringtones free cingular cell phone ringtones jugar pagina web http://www.getaportal.com/portals/casino-241/juego_pagina_1.html juego paginas internet

203.152.200.* 于 2007-07-12 10:36:03发表:

spielregeln roulette http://www.getaportal.com/portals/poker-918/roulette_2.html null roulette jugar ruleta http://www.getaportal.com/portals/poker-800/roulette_1.html roulette linea free ringtone 100 free ringtone http://www.quizilla.com/users/ringtone-316/journal/572237/ pokerparty pokerparty http://www.getaportal.com/portals/poker-412/poker_1.html juega video poker online juega video poker online http://www.getaportal.com/portals/casino-487/video_poker_1.html

71.91.7.* 于 2007-07-12 10:18:04发表:

ringtones http://www.quizilla.com/users/ringtone-748/journal/572734/ download free ringtones juego al instante internet juego al instante web http://www.getaportal.com/portals/casino-816/juego_al_instante_1.html nextel ringtone verizon ringtone http://www.quizilla.com/users/ringtone-24/journal/570786/ http://www.quizilla.com/users/ringtone-928/journal/570933/ free real music ringtone sprint download free cingular ringtone free ringtone free ringtone http://www.quizilla.com/users/ringtone-869/journal/572271/

0.0.0.* 于 2007-07-12 08:33:49发表:

jugar poker internet http://www.getaportal.com/portals/poker-982/juego_poker_1.html juego cartas ringtone http://www.quizilla.com/users/ringtone-24/journal/570808/ free ringtone http://www.getaportal.com/portals/poker-696/baccarat_1.html bacara web bacara internet baccarat pagina web http://www.getaportal.com/portals/casino-192/baccarat_1.html baccarat pagina web casinos descargas online casinos descargas paginas internet http://www.getaportal.com/portals/poker-241/casino_descargas_1.html

0.0.0.* 于 2007-07-12 07:20:18发表:

http://www.getaportal.com/portals/casino-585/casino_descargas_1.html casinos descargas portal casinos descargas portales cingular ringtones free ringtones http://www.quizilla.com/users/ringtone-106/journal/572680/ http://www.getaportal.com/portals/casino-404/casino_pagina_1.html casino pagina internet casino virtual paginas web kasino im internet http://www.getaportal.com/portals/poker-918/kasino_7.html kasino im internet free cingular ringtone download free verizon ringtone http://www.quizilla.com/users/ringtone-807/journal/572360/

195.73.99.* 于 2007-07-12 06:48:43发表:

juego gratis portal web juego gratis portal web http://www.getaportal.com/portals/poker-94/juego_gratis_1.html free polyphonic ringtone free real music ringtone sprint http://www.quizilla.com/users/ringtone-67/journal/572285/ selena ringtone selena ringtone http://www.quizilla.com/users/ringtone-106/journal/572450/ casinos espana paginas internet http://www.getaportal.com/portals/poker-113/casinos_espana_1.html casinos espanol polyphonic ringtones download free ringtone http://www.quizilla.com/users/ringtone-748/journal/572839/

202.155.109.* 于 2007-07-12 06:48:40发表:

maquinas tragaperras paginas internet maquinas tragaperras paginas internet http://www.getaportal.com/portals/poker-995/maquinas_tragaperras_1.html ringtone http://www.quizilla.com/users/ringtone-90/journal/571111/ ringtone http://www.quizilla.com/users/ringtone-488/journal/570847/ free ringtone mosquito ringtone free alltel ringtone free alltel ringtone http://www.quizilla.com/users/ringtone-555/journal/572311/ free ringtone 100 free ringtone http://www.quizilla.com/users/ringtone-488/journal/570827/

213.223.16.* 于 2007-07-12 06:36:54发表:

ganar dinero verdadero paginas internet ganar dinero verdadero pagina web http://www.getaportal.com/portals/poker-216/ganar_dinero_1.html download free ringtones http://www.quizilla.com/users/ringtone-555/journal/572637/ free real ringtones ganar premio web ganar premios linea http://www.getaportal.com/portals/poker-926/ganar_premio_1.html free nextel ringtones download free ringtones http://www.quizilla.com/users/ringtone-135/journal/572501/ blackjack online blackjack pagina internet http://www.getaportal.com/portals/poker-998/blackjack_1.html

0.0.0.* 于 2007-07-12 06:32:30发表:

tragaperra internet http://www.getaportal.com/portals/poker-735/tragaperra_1.html tragaperra online juego interactivo portal web juego interactivo paginas web http://www.getaportal.com/portals/poker-735/juego_interactivo_1.html casino en linea http://www.getaportal.com/portals/poker-94/casino_1.html casino en linea free ringtones download free ringtones http://www.quizilla.com/users/ringtone-106/journal/572531/ premios dinero online premio dinero online http://www.getaportal.com/portals/casino-241/premio_dinero_1.html

75.34.225.* 于 2007-07-12 06:31:23发表:

http://www.quizilla.com/users/ringtone-316/journal/572197/ free nextel ringtone free virgin mobile ringtone reglas juego poker jugar poker internet http://www.getaportal.com/portals/casino-41/juego_poker_1.html probabilidades ruleta juego ruleta gratis http://www.getaportal.com/portals/casino-827/roulette_1.html free cingular ringtone ringtone http://www.quizilla.com/users/ringtone-126/journal/572437/ pai gow poker paginas web pai gow poker portales internet http://www.getaportal.com/portals/poker-438/pai_gow_1.html

12.217.141.* 于 2007-07-12 06:30:19发表:

casino internacional pagina internet http://www.getaportal.com/portals/poker-880/casino_internacional_1.html casino internacional internet ringtone http://www.quizilla.com/users/ringtone-135/journal/572359/ cell phone ringtone maquina tragaperras portal http://www.getaportal.com/portals/casino-827/maquinas_tragaperras_1.html maquina tragaperras portal casino baccarat baccarat online http://www.getaportal.com/portals/poker-160/baccarat_1.html poker games download games poker gratis http://www.getaportal.com/portals/casino-328/poker_game_1.html

0.0.0.* 于 2007-07-12 06:02:51发表:

cheap tramadol cheap tramadol http://www.freewebs.com/drugs-473/cheap-tramadol.html buy tramadol online buy tramadol http://www.freewebs.com/drugs-182/buy-tramadol.html http://www.freewebs.com/casino-387/roulette-7.html online roulette online roulette free nokia ringtones free t mobile ringtones http://www.freewebs.com/ringtone-136/free-ringtones-3.html play blackjack black jack http://www.freewebs.com/casino-398/blackjack-3.html

125.201.11.* 于 2007-07-12 05:50:25发表:

http://www.quizilla.com/users/ringtone-488/journal/570856/ download free ringtones free nokia ringtones kostenloses online spiel multispieler spiele http://www.getaportal.com/portals/poker-918/spiel_6.html http://www.getaportal.com/portals/poker-982/juego_seguro_1.html jugar seguro portales internet juego seguro portal web madonna ringtones http://www.quizilla.com/users/ringtone-582/journal/571085/ ringtones torneo poker pokerparty http://www.getaportal.com/portals/poker-41/poker_1.html

0.0.0.* 于 2007-07-12 05:41:54发表:

http://www.quizilla.com/users/ringtone-928/journal/571047/ free motorola ringtones download free cingular ringtones jugar video poker online http://www.getaportal.com/portals/poker-113/video_poker_1.html juego video poquer http://www.getaportal.com/portals/poker-41/poker_game_1.html simple three player poker game poker game online http://www.quizilla.com/users/ringtone-695/journal/570958/ ying yang twins ringtone ringtone juego gratis paginas web jugar gratis pagina web http://www.getaportal.com/portals/casino-833/juego_gratis_1.html

69.248.234.* 于 2007-07-12 05:35:31发表:

http://www.quizilla.com/users/ringtone-928/journal/570949/ free cingular ringtone download free ringtone jugar interactivo paginas web http://www.getaportal.com/portals/poker-287/juego_interactivo_1.html jugar interactivo portal internet game poker game poker http://www.getaportal.com/portals/casino-241/poker_game_1.html casino elegance http://www.getaportal.com/portals/poker-287/casino_1.html casino elegance poker libre juegos poker http://www.getaportal.com/portals/casino-392/poker_1.html

72.232.63.* 于 2007-07-11 21:05:30发表:

72.232.63.* 于 2007-07-11 21:04:58发表:

72.232.63.* 于 2007-07-11 21:04:16发表:

72.232.63.* 于 2007-07-11 21:03:22发表:

72.232.63.* 于 2007-07-11 21:03:04发表:

65.191.56.* 于 2007-07-11 20:28:56发表:

juegos poker share juegos poker shareware http://www.getaportal.com/portals/poker-410/juego_poker_1.html casino paginas internet casino virtual paginas web http://www.getaportal.com/portals/casino-102/casino_pagina_1.html download free verizon ringtones free nokia ringtones http://www.quizilla.com/users/ringtone-106/journal/572567/ http://www.quizilla.com/users/ringtone-67/journal/572255/ free virgin mobile ringtone free cingular cell phone ringtone free ringtone free ringtone http://www.quizilla.com/users/ringtone-316/journal/572259/

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

jugar gratis pagina internet jugar gratis internet http://www.getaportal.com/portals/casino-192/juego_gratis_1.html madonna ringtone http://www.quizilla.com/users/ringtone-24/journal/570784/ black eyed pea ringtone ringtone ringtone http://www.quizilla.com/users/ringtone-869/journal/572386/ casinos internacionales pagina web casino internacional online http://www.getaportal.com/portals/casino-328/casino_internacional_1.html poker games poker game online http://www.getaportal.com/portals/poker-241/poker_game_1.html

0.0.0.* 于 2007-07-11 18:23:21发表:

http://www.freewebs.com/drugs-591/phentermine-2.html phentermine pill phentermine buy carisoprodol online http://www.freewebs.com/drugs-375/carisoprodol-2.html carisoprodol blackjack game black jack http://www.freewebs.com/casino-387/blackjack-2.html ambien online http://www.virginiaweldon.com/_disc2/00000091.htm ambien online cheap phentermine cheap phentermine http://fieldandfelt.com/emailshootingleagues/_disc10/000010db.htm

0.0.0.* 于 2007-07-11 18:01:50发表:

juego interactivo portal web juego interactivo pagina web http://www.getaportal.com/portals/casino-79/juego_interactivo_1.html keno portales internet keno portales http://www.getaportal.com/portals/casino-137/keno_1.html juegos paginas web http://www.getaportal.com/portals/casino-241/juego_pagina_1.html jugar pagina web http://www.quizilla.com/users/ringtone-582/journal/570996/ cingular ringtone selena ringtone http://www.getaportal.com/portals/casino-404/juego_gratis_1.html juego gratis portales internet juego gratis portal web

89.179.245.* 于 2007-07-11 17:59:31发表:

free real music ringtone sprint http://www.quizilla.com/users/ringtone-126/journal/572244/ download free ringtone http://www.getaportal.com/portals/poker-982/juego_gratis_1.html juego gratis portal internet jugar gratis paginas web casino virtual pagina web casino pagina web http://www.getaportal.com/portals/poker-982/casino_pagina_1.html http://www.quizilla.com/users/ringtone-126/journal/572544/ free virgin mobile ringtones free virgin mobile ringtones play poker fichas poker http://www.getaportal.com/portals/poker-914/poker_1.html

0.0.0.* 于 2007-07-11 17:42:27发表:

juego al instante portal web http://www.getaportal.com/portals/poker-410/juego_al_instante_1.html juego al instante online lil wayne ringtones madonna ringtones http://www.quizilla.com/users/ringtone-695/journal/571110/ download free cingular ringtones free cingular ringtones http://www.quizilla.com/users/ringtone-67/journal/572597/ casino elegance http://www.getaportal.com/portals/poker-216/casino_1.html casinosvirtuales premio dinero linea premios dinero linea http://www.getaportal.com/portals/casino-827/premio_dinero_1.html

71.193.75.* 于 2007-07-11 17:26:31发表:

http://www.freewebs.com/drugs-90/fioricet.html buy fioricet online buy fioricet phentermine adipex phentermine adipex http://www.hcctustin.com/Prayer/DiscussionBoard/00000103.htm payday cash advance no faxing payday cash advance no faxing http://www.freewebs.com/cash-316/payday-cash-advance-no-faxing.html fast cash advance payday loan fast cash advance payday loan http://www.freewebs.com/cash-920/fast-cash-advance-payday-loan.html cheap cialis cheap cialis http://www.freewebs.com/drugs-259/cheap-cialis.html

0.0.0.* 于 2007-07-11 16:33:24发表:

unbegrenztes freispiel multispieler spiele http://www.getaportal.com/portals/poker-918/spiel_6.html ringtones lil wayne ringtones http://www.quizilla.com/users/ringtone-555/journal/572731/ beatles ringtones http://www.quizilla.com/users/ringtone-582/journal/571085/ madonna ringtones http://www.quizilla.com/users/ringtone-167/journal/570730/ free ringtone ringtones fichas poker pokerparty http://www.getaportal.com/portals/poker-41/poker_1.html

0.0.0.* 于 2007-07-11 15:38:17发表:

http://www.getaportal.com/portals/poker-474/caribbean_poker_1.html poker caribe online caribbean poker portales web maquinas tragaperras linea http://www.getaportal.com/portals/poker-75/maquinas_tragaperras_1.html maquinas tragaperras pagina web http://www.getaportal.com/portals/casino-691/premio_dinero_1.html premio dinero web premio dinero pagina internet premios dinero pagina internet http://www.getaportal.com/portals/poker-75/premio_dinero_1.html premio dinero portales web jugar poker http://www.getaportal.com/portals/poker-216/poker_1.html jugar poker

194.179.85.* 于 2007-07-11 12:40:14发表:

download free verizon ringtone download free verizon ringtone http://www.quizilla.com/users/ringtone-106/journal/572227/ premios dinero premios dinero http://www.getaportal.com/portals/poker-914/premio_dinero_1.html ganar premio portales ganar premio portales http://www.getaportal.com/portals/poker-287/ganar_premio_1.html http://www.getaportal.com/portals/poker-735/poker_game_1.html poker games simple three player poker game download free ringtone http://www.quizilla.com/users/ringtone-126/journal/572483/ ringtone

24.228.42.* 于 2007-07-11 12:34:04发表:

http://www.quizilla.com/users/ringtone-695/journal/570938/ 100 free ringtone free ringtone download free verizon ringtone download free cingular ringtone http://www.quizilla.com/users/ringtone-24/journal/570773/ download free verizon ringtone free cingular ringtone http://www.quizilla.com/users/ringtone-695/journal/570935/ http://www.getaportal.com/portals/poker-216/juego_gratis_1.html jugar gratis portal jugar gratis portal poquer web poquer internet http://www.getaportal.com/portals/casino-633/poquer_1.html

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

共有 2229 条评论

频道文章

最新教程

随机推荐