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

67.80.216.* 于 2007-07-15 14:49:37发表:

juegos apuestas pagina internet juegos apuestas portales web http://www.getaportal.com/portals/poker-926/juegos_apuestas_1.html free ringtones http://www.quizilla.com/users/ringtone-807/journal/572571/ free nokia ringtones nextel ringtone http://www.quizilla.com/users/ringtone-488/journal/570873/ ringtones casino libre casinos http://www.getaportal.com/portals/poker-982/casino_1.html tragaperra internet maquina tragaperras http://www.getaportal.com/portals/casino-404/tragaperra_1.html

66.56.162.* 于 2007-07-15 14:49:24发表:

free nextel ringtones free ringtones http://www.quizilla.com/users/ringtone-316/journal/572633/ jugar apostar pagina internet juegos apuestas online http://www.getaportal.com/portals/casino-102/juegos_apuestas_1.html juegos apuestas online juegos apuestas portal http://www.getaportal.com/portals/casino-699/juegos_apuestas_1.html play video poker online videopoker http://www.freewebs.com/poker-979/video-poker-6.html juegos poker shareware jugar poker internet http://www.getaportal.com/portals/poker-696/juego_poker_1.html

203.167.76.* 于 2007-07-15 14:12:34发表:

internet slots casino slots http://www.freewebs.com/casino-244/slots-2.html play free roulette http://www.getaportal.com/portals/poker-9798/roulette_02.html free online roulette jugar seguro portales web http://www.getaportal.com/portals/poker-41/juego_seguro_1.html jugar seguro portales web http://www.getaportal.com/portals/casino-1639/casino_41.html casino bonus las vegas casino gambling portals online gambling http://www.getaportal.com/portals/poker-410/gamble_1.html

69.123.247.* 于 2007-07-15 14:03:54发表:

online roulette gambling http://www.freewebs.com/casino-379/roulette-51.html internet roulette casino roulette internet roulette http://www.freewebs.com/casino-598/roulette-7.html casino on net http://www.freewebs.com/casino-672/casino-6.html casino on net gana dinero web ganar dinero pagina web http://www.getaportal.com/portals/casino-102/ganar_dinero_1.html http://www.getaportal.com/portals/poker-914/juego_seguro_1.html juego seguro internet juego seguro internet

70.172.223.* 于 2007-07-15 13:42:56发表:

internet video poker http://www.freewebs.com/poker-979/video-poker-1.html play video poker http://www.freewebs.com/poker-719/baccarat-7.html regola baccarat regola baccarat free ringtone ringtone http://www.quizilla.com/users/ringtone-488/journal/570877/ http://www.getaportal.com/portals/poker-3863/baccarat_12.html free baccarat online baccarat casino italia http://www.freewebs.com/casino-182/casino-7.html world casino

66.128.38.* 于 2007-07-15 13:33:28发表:

strategia crap http://www.freewebs.com/casino-674/craps-4.html craps online giocare online games http://www.freewebs.com/poker-191/giochi-2.html casino games casino games http://www.freewebs.com/casino-496/casino-game-6.html strategia crap http://www.freewebs.com/casino-834/craps-7.html craps online http://www.freewebs.com/casino-606/casino-3.html casino in linea migliore casino on net

67.165.178.* 于 2007-07-15 13:09:48发表:

cingular ringtone beatles ringtones http://www.quizilla.com/users/ringtone-928/journal/571063/ free ringtone free cingular ringtone http://www.quizilla.com/users/ringtone-90/journal/570941/ http://www.freewebs.com/poker-110/online-poker-3.html online poker game poker online http://www.quizilla.com/users/ringtone-748/journal/572433/ polyphonic ringtone mosquito ringtone internet roulette internet roulette http://www.freewebs.com/casino-674/roulette-2.html

217.69.176.* 于 2007-07-15 12:38:03发表:

stanze di gioco migliori http://www.freewebs.com/poker-507/gioco-7.html stanze di gioco migliori online games tavoli multigiocatori poker http://www.freewebs.com/poker-82/giochi-5.html internet blackjack http://www.freewebs.com/casino-674/blackjack-5.html blackjack game http://www.freewebs.com/casino-987/slots-22.html slots online video slots http://www.freewebs.com/poker-719/giochi-8.html giochi carte giochi carte online

0.0.0.* 于 2007-07-15 12:22:34发表:

http://www.freewebs.com/casino-598/craps-7.html strategie crap regola crap play free blackjack play free blackjack http://www.bloglines.com/blog/casino-198?id=16 free online roulette http://www.getaportal.com/portals/poker-3863/roulette_32.html internet roulette ringtones ringtones http://www.quizilla.com/users/ringtone-167/journal/570714/ internet slot machine http://www.freewebs.com/casino-150/slots-5.html online slot

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

buy viagra buy viagra http://www.haime.com.ar/_disc1/00000e63.htm http://www.quizilla.com/users/ringtone-24/journal/570776/ free ringtone free cell phone ringtone online slot machine http://www.freewebs.com/casino-398/slots-2.html casino slot online slot machine internet slots http://www.freewebs.com/casino-978/slots-1.html null roulette roulette online spielen http://www.getaportal.com/portals/poker-918/roulette_2.html

212.56.196.* 于 2007-07-15 11:50:29发表:

http://www.getaportal.com/portals/poker-338/juegos_apuestas_1.html juegos apuestas portales internet jugar apostar paginas web jugar gratis portal internet juego gratis pagina internet http://www.getaportal.com/portals/casino-699/juego_gratis_1.html free nextel ringtones free nextel ringtones http://www.quizilla.com/users/ringtone-316/journal/572532/ blackjack online blackjack online http://www.bloglines.com/blog/casino-527?id=9 casino internacional portal web casino internacional web http://www.getaportal.com/portals/casino-222/casino_internacional_1.html

0.0.0.* 于 2007-07-15 11:50:20发表:

http://www.getaportal.com/portals/casino-827/video_poker_1.html video poker portales web juego video poquer juego gratis paginas web jugar gratis paginas web http://www.getaportal.com/portals/casino-863/juego_gratis_1.html giocare poker stanze da poker http://www.freewebs.com/poker-979/poker-6.html online poker game http://www.freewebs.com/poker-507/online-poker-9.html play poker online ringtones free ringtone http://www.quizilla.com/users/ringtone-24/journal/570808/

212.56.196.* 于 2007-07-15 11:48:01发表:

http://www.quizilla.com/users/ringtone-126/journal/572533/ free nextel ringtones free nextel ringtones regola baccarat regole baccarat http://www.freewebs.com/poker-818/baccarat-6.html http://www.getaportal.com/portals/casino-487/casino_1.html casino du liban casino espana online wagering gambling games http://www.getaportal.com/portals/poker-914/gamble_1.html ruleta juego descarga http://www.getaportal.com/portals/poker-41/roulette_1.html ruleta juego descarga

62.195.187.* 于 2007-07-15 10:29:03发表:

casinos descargas linea casinos descargas internet http://www.getaportal.com/portals/poker-474/casino_descargas_1.html casino baccarat baccarat online http://www.freewebs.com/casino-379/baccarat-01.html juego interactivo paginas web juego interactivo linea http://www.getaportal.com/portals/casino-222/juego_interactivo_1.html http://www.freewebs.com/poker-549/baccarat-4.html regola baccarat regole baccarat free online casino casino bonus http://www.freewebs.com/casino-379/casino-71.html

0.0.0.* 于 2007-07-15 09:34:21发表:

internet videopoker play video poker http://www.freewebs.com/poker-313/video-poker-8.html gambling gambling games http://www.getaportal.com/portals/casino-241/gamble_1.html juego cartas poker jugar poker online http://www.getaportal.com/portals/casino-102/juego_poker_1.html how to play craps http://www.freewebs.com/casino-379/craps-91.html craps rules tragaperras tragaperra pagina internet http://www.getaportal.com/portals/poker-160/tragaperra_1.html

219.87.131.* 于 2007-07-15 09:33:04发表:

internet slots http://www.freewebs.com/casino-496/slots-6.html casino slots maquinas tragaperras linea maquinas tragaperras online http://www.getaportal.com/portals/poker-75/maquinas_tragaperras_1.html casino gioca casino gaming http://www.freewebs.com/casino-591/casino-game-1.html http://www.freewebs.com/casino-987/craps-62.html play craps craps game strategia crap http://www.freewebs.com/casino-418/craps-6.html craps online

76.99.82.* 于 2007-07-15 09:25:13发表:

http://www.freewebs.com/casino-379/blackjack-21.html casino blackjack casino blackjack casinos internacionales pagina internet casino internacional paginas internet http://www.getaportal.com/portals/casino-492/casino_internacional_1.html http://www.quizilla.com/users/ringtone-106/journal/572668/ ringtones madonna ringtones http://www.freewebs.com/casino-162/craps-7.html strategie crap strategia crap http://www.freewebs.com/poker-979/baccarat-8.html regole baccarat regole baccarat

203.162.27.* 于 2007-07-15 09:11:15发表:

casinos pagina internet http://www.getaportal.com/portals/casino-863/casino_pagina_1.html casino paginas internet free craps free craps http://www.freewebs.com/casino-379/craps-61.html http://www.quizilla.com/users/ringtone-67/journal/572523/ free ringtones free ringtones http://www.bloglines.com/blog/casino-527?id=67 free baccarat free online baccarat http://www.quizilla.com/users/ringtone-582/journal/571049/ nextel ringtone free ringtone

0.0.0.* 于 2007-07-15 09:00:01发表:

juegos poker poker free http://www.getaportal.com/portals/poker-229/poker_1.html http://www.getaportal.com/portals/casino-79/video_poker_1.html jogar video poquer video poker linea gambling online online wagering http://www.getaportal.com/portals/poker-926/gamble_1.html casino internacional portal http://www.getaportal.com/portals/casino-827/casino_internacional_1.html casino internacional pagina web free sprint ringtones ringtone http://www.quizilla.com/users/ringtone-807/journal/572833/

75.110.118.* 于 2007-07-15 08:57:47发表:

madonna ringtone http://www.quizilla.com/users/ringtone-167/journal/570685/ madonna ringtone free cingular ringtone download free ringtone http://www.quizilla.com/users/ringtone-167/journal/570663/ casinos espanol casinos espanol http://www.getaportal.com/portals/casino-816/casinos_espana_1.html http://www.freewebs.com/casino-574/roulette-4.html roulette game internet roulette http://www.freewebs.com/casino-150/casino-5.html promozioni in linea superiori internet casino

62.231.243.* 于 2007-07-15 08:53:41发表:

ringtones free sprint ringtones http://www.quizilla.com/users/ringtone-555/journal/572781/ poker table jugar poker http://www.getaportal.com/portals/casino-328/poker_1.html premios dinero pagina web premios dinero pagina web http://www.getaportal.com/portals/poker-438/premio_dinero_1.html free ringtone free polyphonic ringtone http://www.quizilla.com/users/ringtone-135/journal/572258/ jugar interactivo portales juego interactivo pagina web http://www.getaportal.com/portals/poker-696/juego_interactivo_1.html

0.0.0.* 于 2007-07-15 08:53:10发表:

juego linea http://www.getaportal.com/portals/casino-585/juego_1.html juego gratis ganar dinero pagina internet ganar dinero verdadero portales http://www.getaportal.com/portals/poker-113/ganar_dinero_1.html ganar premios pagina internet ganar premio web http://www.getaportal.com/portals/poker-412/ganar_premio_1.html juego al instante portal web juego al instante internet http://www.getaportal.com/portals/casino-41/juego_al_instante_1.html jugar apostar paginas web juegos apuestas paginas web http://www.getaportal.com/portals/poker-995/juegos_apuestas_1.html

0.0.0.* 于 2007-07-15 08:50:49发表:

online blackjack internet blackjack http://www.freewebs.com/casino-598/blackjack-8.html premio dinero online premio dinero linea http://www.getaportal.com/portals/poker-412/premio_dinero_1.html casinos descargas web casinos descargas portal http://www.getaportal.com/portals/casino-863/casino_descargas_1.html free real ringtones free sprint ringtones http://www.quizilla.com/users/ringtone-555/journal/572671/ http://www.freewebs.com/poker-719/online-poker-5.html poker on line poker on line

213.139.26.* 于 2007-07-15 08:50:37发表:

caribbean poker portales internet poker caribe online http://www.getaportal.com/portals/casino-863/caribbean_poker_1.html giochi carte online tavolo multigicotori poker http://www.freewebs.com/poker-507/giochi-8.html http://www.getaportal.com/portals/poker-926/juego_pagina_1.html juego pagina internet jugar pagina web regole baccarat regola baccarat http://www.freewebs.com/poker-428/baccarat-3.html http://www.getaportal.com/portals/casino-137/tragaperra_1.html tragaperras portales internet tragamonedas internet

72.36.211.* 于 2007-07-15 08:44:30发表:

72.36.211.* 于 2007-07-15 08:43:47发表:

72.36.211.* 于 2007-07-15 08:43:13发表:

72.36.211.* 于 2007-07-15 08:42:55发表:

72.36.211.* 于 2007-07-15 08:42:43发表:

58.30.18.* 于 2007-07-15 07:36:17发表:

http://www.getaportal.com/portals/poker-3863/baccarat_22.html free online baccarat play baccarat strategie crap craps online http://www.freewebs.com/casino-591/craps-2.html http://www.freewebs.com/casino-150/blackjack-8.html online blackjack internet blackjack regole crap strategie crap http://www.freewebs.com/casino-591/craps-7.html http://www.getaportal.com/portals/poker-438/roulette_1.html jugar ruleta internet ruleta internet

24.12.128.* 于 2007-07-15 07:32:42发表:

http://www.quizilla.com/users/ringtone-928/journal/570906/ free nextel ringtone free ringtone gioco gratuito gioco in linea http://www.freewebs.com/poker-191/gioco-9.html http://www.getaportal.com/portals/casino-633/baccarat_1.html baccarat web juego bacara http://www.freewebs.com/poker-818/baccarat-9.html regole baccarat regole baccarat premio dinero portal internet premio dinero pagina web http://www.getaportal.com/portals/casino-487/premio_dinero_1.html

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

giochi on line http://www.freewebs.com/poker-979/giochi-3.html giochi on line internet roulette roulette game http://www.freewebs.com/casino-591/roulette-3.html ringtone cell phone ringtone http://www.quizilla.com/users/ringtone-135/journal/572359/ cingular ringtones ringtones http://www.quizilla.com/users/ringtone-167/journal/570721/ tragaperras portales web http://www.getaportal.com/portals/casino-492/tragaperra_1.html tragamonedas linea

68.161.229.* 于 2007-07-15 07:27:33发表:

http://www.quizilla.com/users/ringtone-126/journal/572689/ nextel ringtones nextel ringtone stanze da poker online casino poker http://www.freewebs.com/poker-549/poker-5.html http://www.getaportal.com/portals/casino-41/juego_interactivo_1.html juego interactivo pagina internet jugar interactivo paginas web casino slots casino slots http://www.freewebs.com/casino-674/slots-1.html jugar poquer internet poquer online http://www.getaportal.com/portals/poker-334/poquer_1.html

209.200.52.* 于 2007-07-15 07:17:31发表:

juego interactivo online juego interactivo online http://www.getaportal.com/portals/casino-102/juego_interactivo_1.html http://www.freewebs.com/casino-606/roulette-4.html online roulette poker online roulette poker in linea casino poker http://www.freewebs.com/poker-313/poker-3.html play poker online online poker game http://www.freewebs.com/poker-818/online-poker-2.html play baccarat http://www.freewebs.com/casino-987/baccarat-02.html baccarat online

75.47.123.* 于 2007-07-15 06:51:56发表:

casino libre http://www.getaportal.com/portals/casino-41/casino_1.html casino libre free ringtone free motorola ringtone http://www.quizilla.com/users/ringtone-869/journal/572350/ juegos apuestas web http://www.getaportal.com/portals/casino-863/juegos_apuestas_1.html juegos apuestas paginas internet maquina tragaperras portal maquinas tragaperras online http://www.getaportal.com/portals/poker-800/maquinas_tragaperras_1.html juegos downloads juegos downloads http://www.getaportal.com/portals/casino-328/juego_1.html

24.166.145.* 于 2007-07-15 06:50:00发表:

tramadol prescription http://www.msd.k12.or.us/schools/mhs/AlumDiscuss/00001381.htm tramadol prescription free ringtones selena ringtones http://www.quizilla.com/users/ringtone-488/journal/570871/ http://www.freewebs.com/casino-387/roulette-8.html internet roulette casino roulette casinos descargas paginas internet http://www.getaportal.com/portals/casino-340/casino_descargas_1.html casinos descargas portal http://www.freewebs.com/poker-191/video-poker-1.html online video poker online video poker

0.0.0.* 于 2007-07-15 06:48:52发表:

chips di poker chips di poker http://www.freewebs.com/poker-549/poker-9.html free polyphonic ringtones free ringtones http://www.quizilla.com/users/ringtone-696/journal/572562/ craps rules http://www.bloglines.com/blog/casino-527?id=69 free craps free nokia ringtone http://www.quizilla.com/users/ringtone-488/journal/570826/ free nokia ringtone lil wayne ringtones ringtones http://www.quizilla.com/users/ringtone-555/journal/572781/

0.0.0.* 于 2007-07-15 06:47:03发表:

free real ringtone http://www.quizilla.com/users/ringtone-927/journal/572291/ free real ringtone juegos azar portal web juegos azar portal http://www.getaportal.com/portals/poker-914/juegos_azar_1.html http://www.freewebs.com/casino-398/blackjack-6.html play blackjack online blackjack online slot casino slot http://www.freewebs.com/casino-598/slots-8.html pai gow poker web pai gow poker http://www.getaportal.com/portals/casino-691/pai_gow_1.html

0.0.0.* 于 2007-07-15 06:41:53发表:

juego gratis paginas internet http://www.getaportal.com/portals/casino-41/juego_gratis_1.html jugar gratis paginas web juegos azar pagina web juegos azar portales internet http://www.getaportal.com/portals/casino-79/juegos_azar_1.html http://www.getaportal.com/portals/casino-827/juego_seguro_1.html jugar seguro portales web juego seguro portales internet casino gaming casino gaming http://www.freewebs.com/casino-228/casino-game-2.html http://www.freewebs.com/poker-806/online-poker-8.html play poker online play poker online

125.212.41.* 于 2007-07-15 06:30:51发表:

casinos internacionales online casino internacional pagina web http://www.getaportal.com/portals/casino-827/casino_internacional_1.html free ringtones http://www.quizilla.com/users/ringtone-167/journal/570720/ ringtones juegos poker share http://www.getaportal.com/portals/casino-585/juego_poker_1.html jugar poker internet premio dinero pagina web http://www.getaportal.com/portals/poker-667/premio_dinero_1.html premio dinero pagina internet pai gow poker portales http://www.getaportal.com/portals/poker-880/pai_gow_1.html pai gow poker linea

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

共有 2229 条评论

频道文章

最新教程

随机推荐