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

72.36.211.* 于 2007-07-17 06:43:38发表:

72.36.211.* 于 2007-07-17 06:43:28发表:

0.0.0.* 于 2007-07-16 17:30:37发表:

casino roulette http://www.bloglines.com/blog/casino-198?id=26 roulette table casino gaming http://www.freewebs.com/casino-228/casino-game-5.html casino games caribbean poker internet http://www.getaportal.com/portals/casino-328/caribbean_poker_1.html caribbean poker portales http://www.quizilla.com/users/ringtone-869/journal/572250/ free ringtone free real music ringtone sprint http://www.getaportal.com/portals/casino-137/ganar_premio_1.html ganar premios pagina internet ganar premio portal internet

82.234.5.* 于 2007-07-16 17:29:17发表:

0.0.0.* 于 2007-07-16 17:24:52发表:

keno pagina web keno linea http://www.getaportal.com/portals/poker-94/keno_1.html free nokia ringtones download free ringtones http://www.quizilla.com/users/ringtone-869/journal/572707/ http://www.getaportal.com/portals/poker-412/casino_internacional_1.html casino internacional portal internet casinos internacionales linea roulette online roulette online http://www.freewebs.com/casino-591/roulette-1.html online video poker online video poker http://www.freewebs.com/poker-558/video-poker-9.html

0.0.0.* 于 2007-07-16 17:08:04发表:

play poker poker gratuito http://www.freewebs.com/poker-82/poker-8.html casino baccarat jugar bacara internet http://www.getaportal.com/portals/poker-982/baccarat_1.html simple three player poker game multiplayer poker game http://www.getaportal.com/portals/poker-113/poker_game_1.html casinos espana web casinos espana paginas web http://www.getaportal.com/portals/poker-168/casinos_espana_1.html casino virtual pagina web casino virtual pagina web http://www.getaportal.com/portals/casino-241/casino_pagina_1.html

0.0.0.* 于 2007-07-16 17:01:57发表:

regole baccarat regole baccarat http://www.freewebs.com/poker-82/baccarat-3.html ganar premio online ganar premio portales web http://www.getaportal.com/portals/casino-404/ganar_premio_1.html casinos games casinos games http://www.freewebs.com/casino-591/casino-game-2.html casinos in linea superiore http://www.freewebs.com/casino-150/casino-7.html casinos in linea superiore free alltel ringtones free polyphonic ringtones http://www.quizilla.com/users/ringtone-90/journal/571052/

217.69.176.* 于 2007-07-16 16:18:31发表:

casino games http://www.freewebs.com/casino-574/casino-7.html world casino ruleta cromatica ganar ruleta http://www.getaportal.com/portals/casino-816/roulette_1.html http://www.getaportal.com/portals/poker-412/juego_al_instante_1.html juego al instante linea juego al instante linea http://www.getaportal.com/portals/casino-2877/craps_11.html gambling craps how to play craps casino du liban http://www.getaportal.com/portals/poker-338/casino_1.html casinos

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

internet slot casino slot http://www.freewebs.com/casino-244/slots-7.html pokerparty pokerparty http://www.getaportal.com/portals/casino-699/poker_1.html casino gaming http://www.freewebs.com/casino-511/casino-game-4.html casinos games internet blackjack blackjack gambling http://www.freewebs.com/casino-379/blackjack-31.html selena ringtones black eyed pea ringtones http://www.quizilla.com/users/ringtone-488/journal/570868/

69.151.222.* 于 2007-07-16 15:50:59发表:

download free verizon ringtones http://www.quizilla.com/users/ringtone-928/journal/571054/ free sprint ringtones casinos games casino games http://www.freewebs.com/casino-511/casino-game-3.html free virgin mobile ringtones free cingular cell phone ringtones http://www.quizilla.com/users/ringtone-488/journal/570861/ http://www.getaportal.com/portals/poker-474/casinos_espana_1.html casinos espana web casinos espana internet gambling portals on line gambling http://www.getaportal.com/portals/casino-704/gamble_1.html

0.0.0.* 于 2007-07-16 15:33:38发表:

play blackjack black jack http://www.freewebs.com/casino-387/blackjack-8.html http://www.quizilla.com/users/ringtone-79/journal/572262/ free mobile phone ringtone free nokia ringtone http://www.quizilla.com/users/ringtone-24/journal/570772/ free ringtone free ringtone casino slot casino slot http://www.freewebs.com/casino-606/slots-7.html http://www.getaportal.com/portals/poker-75/juegos_azar_1.html juegos azar internet juegos azar linea

222.124.197.* 于 2007-07-16 15:22:34发表:

ringtone download free ringtone http://www.quizilla.com/users/ringtone-126/journal/572483/ casinos descargas portales internet casinos descargas portales internet http://www.getaportal.com/portals/casino-487/casino_descargas_1.html casino slot http://www.getaportal.com/portals/poker-334/casino_1.html casino slot http://www.getaportal.com/portals/casino-827/keno_1.html keno portales web keno pagina internet http://www.freewebs.com/casino-978/roulette-6.html internet roulette roulette internet

222.124.197.* 于 2007-07-16 15:13:25发表:

http://www.freewebs.com/casino-162/casino-1.html promozioni in linea superiori promozioni in linea superiori simple three player poker game computer poker game http://www.getaportal.com/portals/casino-41/poker_game_1.html ringtones http://www.quizilla.com/users/ringtone-316/journal/572837/ nextel ringtone strategia crap craps online http://www.freewebs.com/casino-985/craps-3.html gioco online download giochi http://www.freewebs.com/poker-419/giochi-9.html

68.44.8.* 于 2007-07-16 15:11:49发表:

online poker game play poker online http://www.freewebs.com/poker-191/online-poker-7.html online wagering http://www.getaportal.com/portals/casino-392/gamble_1.html gamble online probabilidades ruleta ruleta linea http://www.getaportal.com/portals/casino-863/roulette_1.html nextel ringtone http://www.quizilla.com/users/ringtone-126/journal/572712/ free cingular ringtones free motorola ringtone http://www.quizilla.com/users/ringtone-696/journal/572219/ free ringtone

0.0.0.* 于 2007-07-16 15:06:01发表:

http://www.freewebs.com/poker-428/video-poker-9.html online videopoker play video poker http://www.getaportal.com/portals/poker-338/casinos_espana_1.html casinos espana paginas internet casinos espanol giochi online tavoli da gioco poker http://www.freewebs.com/poker-989/giochi-5.html http://www.getaportal.com/portals/poker-168/juego_poker_1.html juegos cartas poker juegos cartas poker http://www.freewebs.com/poker-734/baccarat-3.html regole baccarat regola baccarat

0.0.0.* 于 2007-07-16 15:05:03发表:

http://www.quizilla.com/users/ringtone-696/journal/572504/ mosquito ringtone polyphonic ringtone poker games stanza poker http://www.freewebs.com/poker-979/poker-8.html casino gaming http://www.freewebs.com/casino-591/casino-game-5.html casino gioca http://www.getaportal.com/portals/poker-914/juego_gratis_1.html jugar gratis pagina web juego gratis portales internet keno casino keno online http://www.freewebs.com/casino-379/keno-91.html

213.139.26.* 于 2007-07-16 14:37:52发表:

roulette spielen http://www.getaportal.com/portals/poker-918/roulette_7.html nullroulette cheap tramadol http://www.troyh.com/Troysblog/0000006c.htm cheap tramadol internet roulette roulette online http://www.freewebs.com/casino-837/roulette-6.html stanza poker online casino poker http://www.freewebs.com/poker-428/poker-7.html http://www.getaportal.com/portals/poker-926/ganar_dinero_1.html ganar dinero verdadero online ganar dinero verdadero portal web

24.45.250.* 于 2007-07-16 14:18:40发表:

juego gratis portal juego gratis portal http://www.getaportal.com/portals/casino-487/juego_gratis_1.html jugar gratis pagina web http://www.getaportal.com/portals/casino-833/juego_gratis_1.html jugar gratis pagina web http://www.getaportal.com/portals/casino-633/video_poker_1.html juegar video poker jugar video poquer web poker online http://www.freewebs.com/poker-603/online-poker-4.html play poker online poker games http://www.freewebs.com/poker-549/poker-4.html poker games

66.128.38.* 于 2007-07-16 14:10:14发表:

http://www.freewebs.com/poker-656/online-poker-9.html poker online online poker game http://www.freewebs.com/casino-379/slots-71.html free casino slots free slots no download online poker game poker on line http://www.freewebs.com/poker-507/online-poker-1.html casino gioca http://www.freewebs.com/casino-834/casino-game-3.html casino games tragamonedas linea tragaperra linea http://www.getaportal.com/portals/poker-94/tragaperra_1.html

74.70.114.* 于 2007-07-16 09:39:59发表:

http://www.freewebs.com/poker-207/online-poker-2.html poker on line online poker game http://www.getaportal.com/portals/casino-404/maquinas_tragaperras_1.html maquina tragaperras internet maquina tragaperras internet jack black blackjack gambling http://www.freewebs.com/casino-379/blackjack-11.html internet roulette online roulette poker http://www.freewebs.com/casino-574/roulette-6.html gioco gratuito http://www.freewebs.com/poker-110/gioco-8.html stanze di gioco migliori

24.214.128.* 于 2007-07-16 09:03:46发表:

http://www.freewebs.com/casino-398/craps-5.html regole crap craps online regole baccarat http://www.freewebs.com/poker-549/baccarat-8.html regola baccarat juego linea juegos gratis http://www.getaportal.com/portals/casino-340/juego_1.html free ringtone free virgin mobile ringtone http://www.quizilla.com/users/ringtone-67/journal/572243/ http://www.getaportal.com/portals/casino-392/roulette_1.html roulette online jugar ruleta linea

68.91.151.* 于 2007-07-16 08:34:34发表:

tragaperras portales web http://www.getaportal.com/portals/poker-998/tragaperra_1.html tragamonedas web casinos descargas http://www.getaportal.com/portals/casino-137/casino_descargas_1.html casinos descargas portal web casino games casino gaming http://www.freewebs.com/casino-978/casino-game-8.html free cingular cell phone ringtones free cingular ringtones http://www.quizilla.com/users/ringtone-582/journal/571029/ http://www.bloglines.com/blog/casino-527?id=17 online slots machine free slots machine game

70.172.223.* 于 2007-07-16 08:31:14发表:

http://www.freewebs.com/poker-734/video-poker-4.html online videopoker internet videopoker regola baccarat regole baccarat http://www.freewebs.com/poker-207/baccarat-5.html play poker online http://www.freewebs.com/poker-734/online-poker-6.html online poker game free sprint ringtone http://www.quizilla.com/users/ringtone-807/journal/572454/ ringtone cell phone ringtone cell phone ringtone http://www.quizilla.com/users/ringtone-928/journal/571000/

0.0.0.* 于 2007-07-16 08:21:44发表:

dave hollister ringtone nextel ringtone http://www.quizilla.com/users/ringtone-24/journal/570779/ play blackjack online blackjack http://www.freewebs.com/casino-574/blackjack-3.html regole baccarat regole baccarat http://www.freewebs.com/poker-313/baccarat-4.html regole baccarat http://www.freewebs.com/poker-191/baccarat-7.html regole baccarat blackjack game play blackjack http://www.freewebs.com/casino-162/blackjack-6.html

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

free cingular cell phone ringtone http://www.quizilla.com/users/ringtone-106/journal/572189/ free alltel ringtone casinos espana paginas internet casinos espana portal http://www.getaportal.com/portals/poker-696/casinos_espana_1.html http://www.freewebs.com/poker-313/poker-9.html online poker tournament internet poker celtic frost ringtone http://www.quizilla.com/users/ringtone-582/journal/570956/ ringtone juego cartas poker juego de cartas http://www.getaportal.com/portals/poker-982/juego_poker_1.html

24.22.180.* 于 2007-07-16 07:22:46发表:

http://www.getaportal.com/portals/casino-392/juego_al_instante_1.html juego al instante linea juego al instante portales internet blackjack online blackjack http://www.freewebs.com/casino-418/blackjack-3.html internet slots http://www.freewebs.com/casino-598/slots-2.html online slot machine http://www.freewebs.com/casino-228/casino-game-1.html giochi casino casino gioca online videopoker online video poker http://www.freewebs.com/poker-207/video-poker-1.html

24.44.39.* 于 2007-07-16 07:21:56发表:

regole crap http://www.freewebs.com/casino-985/craps-2.html regola crap regola baccarat regole baccarat http://www.freewebs.com/poker-989/baccarat-7.html blackjack game http://www.freewebs.com/casino-978/blackjack-4.html play blackjack http://www.freewebs.com/poker-979/online-poker-6.html poker on line online poker game free roulette game online roulette game http://www.freewebs.com/casino-379/roulette-11.html

0.0.0.* 于 2007-07-16 07:21:32发表:

internet slots http://www.freewebs.com/casino-387/slots-7.html casino slots play poker online http://www.freewebs.com/poker-428/online-poker-3.html poker online regole baccarat http://www.freewebs.com/poker-818/baccarat-8.html regola baccarat online casino roulette play roulette http://www.getaportal.com/portals/casino-2877/roulette_11.html poker online play poker online http://www.freewebs.com/poker-979/online-poker-5.html

67.181.241.* 于 2007-07-16 07:09:09发表:

http://www.freewebs.com/casino-162/craps-1.html regola crap strategie crap online roulette poker internet roulette http://www.freewebs.com/casino-387/roulette-7.html maquinas tragaperras pagina web maquina tragaperras portal web http://www.getaportal.com/portals/poker-412/maquinas_tragaperras_1.html jugar bacara casino baccarat http://www.getaportal.com/portals/poker-998/baccarat_1.html poker game online http://www.getaportal.com/portals/poker-229/poker_game_1.html simple three player poker game

198.30.120.* 于 2007-07-16 07:02:14发表:

premios dinero premio dinero portal http://www.getaportal.com/portals/poker-94/premio_dinero_1.html http://www.getaportal.com/portals/poker-229/juegos_apuestas_1.html jugar apostar internet juegos apuestas paginas web free verizon ringtone free ringtone http://www.quizilla.com/users/ringtone-316/journal/572225/ free online roulette casino roulette http://www.bloglines.com/blog/casino-527?id=5 http://www.getaportal.com/portals/poker-3863/keno_22.html play keno online free keno games

72.36.211.* 于 2007-07-16 06:55:22发表:

0.0.0.* 于 2007-07-16 06:55:06发表:

free ringtones http://www.quizilla.com/users/ringtone-90/journal/571011/ free mobile phone ringtones keno online free keno http://www.bloglines.com/blog/casino-198?id=49 black eyed pea ringtone polyphonic ringtone http://www.quizilla.com/users/ringtone-67/journal/572430/ juego al instante portal http://www.getaportal.com/portals/casino-699/juego_al_instante_1.html juego al instante pagina internet internet video poker internet videopoker http://www.freewebs.com/poker-989/video-poker-8.html

72.36.211.* 于 2007-07-16 06:54:29发表:

72.36.211.* 于 2007-07-16 06:53:59发表:

72.36.211.* 于 2007-07-16 06:53:42发表:

72.36.211.* 于 2007-07-16 06:53:34发表:

125.197.185.* 于 2007-07-16 05:50:50发表:

poker games http://www.freewebs.com/poker-419/poker-4.html giocare poker tavoli multigiocatori poker tavoli multigiocatori poker http://www.freewebs.com/poker-979/giochi-7.html http://www.freewebs.com/casino-379/keno-41.html keno online video keno strategia crap http://www.freewebs.com/casino-387/craps-4.html craps online free craps game craps table http://www.freewebs.com/casino-987/craps-12.html

0.0.0.* 于 2007-07-16 05:40:11发表:

http://www.freewebs.com/casino-574/craps-6.html regola crap regole crap 100 free ringtones 100 free ringtones http://www.quizilla.com/users/ringtone-167/journal/570695/ http://www.quizilla.com/users/ringtone-67/journal/572626/ free ringtones free alltel ringtones jugar poquer online poquer linea http://www.getaportal.com/portals/poker-168/poquer_1.html poker games game poker http://www.freewebs.com/poker-82/poker-9.html

71.60.30.* 于 2007-07-16 05:38:36发表:

caribbean poker portal web http://www.getaportal.com/portals/poker-338/caribbean_poker_1.html caribbean poker paginas internet ringtone ringtone http://www.quizilla.com/users/ringtone-582/journal/570964/ nextel ringtone free cingular ringtone http://www.quizilla.com/users/ringtone-695/journal/570954/ juego al instante pagina web juego al instante paginas internet http://www.getaportal.com/portals/poker-438/juego_al_instante_1.html online blackjack blackjack game http://www.freewebs.com/casino-398/blackjack-8.html

0.0.0.* 于 2007-07-16 05:09:54发表:

http://www.quizilla.com/users/ringtone-24/journal/570788/ free cingular ringtone beatles ringtone http://www.quizilla.com/users/ringtone-488/journal/570851/ madonna ringtone ringtone free mp3 ringtone free mp3 ringtone http://www.quizilla.com/users/ringtone-695/journal/570930/ jugar poquer internet jugar poquer online http://www.getaportal.com/portals/casino-492/poquer_1.html free roulette http://www.bloglines.com/blog/casino-527?id=68 free online roulette

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

共有 2229 条评论

频道文章

最新教程

随机推荐