数据库应用程序常见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.232.63.* 于 2007-07-09 16:27:08发表:

72.232.63.* 于 2007-07-09 16:26:52发表:

72.232.63.* 于 2007-07-09 16:25:53发表:

72.232.63.* 于 2007-07-09 16:25:22发表:

72.232.63.* 于 2007-07-09 16:25:06发表:

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

buy fioricet online buy fioricet http://www.freewebs.com/drugs-591/buy-fioricet-2.html cingular ringtones ringtones http://www.freewebs.com/ringtone-136/ringtones-10.html http://www.freewebs.com/cash-388/cash-advance-orange-county.html cash advance orange county cash advance orange county cheap vigrx http://www.freewebs.com/drugs-322/cheap-vigrx.html cheap vigrx casino roulette http://www.freewebs.com/casino-591/roulette-4.html online roulette poker

0.0.0.* 于 2007-07-09 15:25:47发表:

http://www.freewebs.com/cash-862/lawsuit-cash-advance.html lawsuit cash advance lawsuit cash advance world casino http://www.freewebs.com/casino-511/casino-8.html virtual casino cash advance pennsylvania cash advance pennsylvania http://www.freewebs.com/cash-920/cash-advance-pennsylvania.html free nextel ringtones free nextel ringtones http://www.freewebs.com/ringtone-518/free-ringtones-11.html buy vigrx buy vigrx http://www.freewebs.com/drugs-470/buy-vigrx.html

0.0.0.* 于 2007-07-09 15:24:19发表:

http://www.globalduk.com/_disc1/0000037d.htm hydrocodone online hydrocodone online levitra levitra http://www.gottagetgear.com/_disc1/00000175.htm http://www.freewebs.com/casino-496/slots-7.html online slot internet slot poker games http://www.freewebs.com/poker-656/poker-9.html poker games http://www.freewebs.com/drugs-473/buy-levitra.html buy levitra buy levitra

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

vigrx vigrx side effects http://www.freewebs.com/drugs-72/vigrx-2.html http://cahn.mnsu.edu/fall2001laugh/_disc3/000003f7.htm how penis enlargement works how penis enlargement works http://www.freewebs.com/cash-41/pay-day-cash-advance.html pay day cash advance pay day cash advance cash advance store cash advance store http://www.freewebs.com/cash-177/cash-advance-store.html order viagra online order viagra online http://www.irishsetterclub.org/_Katrina_Disc/000001ca.htm

0.0.0.* 于 2007-07-09 14:11:01发表:

drug rehab program drug rehab program http://www.bindt.ch/Forum/_disc1/00000034.htm http://www.freewebs.com/drugs-752/cheap-phentermine-2.html cheap phentermine cheap phentermine easy enlargement free penis surgery way easy enlargement free penis surgery way http://www.romstampa.it/_disc1/000001af.htm cash advance company loan cash advance company loan http://www.freewebs.com/cash-177/cash-advance-company-loan.html cheap viagra uk cheap viagra uk http://www.freewebs.com/drugs-705/cheap-viagra-2.html

97.84.199.* 于 2007-07-09 13:28:36发表:

http://www.freewebs.com/cash-256/cash-advance-usa.html cash advance usa cash advance usa allied cash advance http://www.freewebs.com/cash-388/allied-cash-advance.html allied cash advance vicodin http://www.tourdepub.com/_smack/0000128f.htm vicodin casino slot http://www.freewebs.com/casino-606/slots-6.html internet slot machine buy fioricet http://www.cskennedy.com/bhsclassof61/_BHSdisc1/000000a7.htm buy fioricet

0.0.0.* 于 2007-07-09 13:28:11发表:

buy tramadol online buy tramadol http://www.freewebs.com/drugs-705/buy-tramadol.html cash advance kansas city cash advance kansas city http://www.freewebs.com/cash-256/cash-advance-kansas-city.html stanze di gioco in linea libere gioco in linea http://www.freewebs.com/poker-989/gioco-9.html cash advance boston cash advance boston http://www.freewebs.com/cash-316/cash-advance-boston.html craps online http://www.freewebs.com/casino-418/craps-3.html regola crap

0.0.0.* 于 2007-07-09 13:23:54发表:

internet video poker play video poker http://www.freewebs.com/poker-110/video-poker-3.html cash advance nassau cash advance nassau http://www.freewebs.com/cash-920/cash-advance-nassau.html ringtones download free ringtone http://www.freewebs.com/ringtone-920/ringtones-14.html http://www.freewebs.com/casino-674/blackjack-8.html blackjack game online blackjack quick cash advance quick cash advance http://www.freewebs.com/cash-388/quick-cash-advance.html

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

cheap viagra cheap viagra uk http://www.freewebs.com/drugs-780/cheap-viagra.html http://www.freewebs.com/ringtone-920/free-ringtones-8.html free nokia ringtones free ringtones online poker tournament partypoker http://www.freewebs.com/poker-419/poker-2.html http://www.freewebs.com/casino-496/casino-8.html casinos keno buy tramadol online http://www.patacake.com/Discussions/Kids/_disc29/00001c6b.htm buy tramadol online

0.0.0.* 于 2007-07-09 12:54:21发表:

payroll cash advance http://www.freewebs.com/cash-640/payroll-cash-advance.html payroll cash advance online cialis http://www.smsannafrank.it/_disc1/0000003b.htm online cialis online roulette roulette online http://www.freewebs.com/casino-182/roulette-5.html phentermine online http://www.alessiamore.it/file%20nascosti/_disc10/00000271.htm phentermine online adipex online adipex online http://www.heightstowers.com/_disc10/00001082.htm

0.0.0.* 于 2007-07-09 12:52:41发表:

order soma order soma http://thebluesband.com/webforum/_disc23/00003c69.htm tramadol prescription tramadol prescription http://www.thetalkingfrog.com/_disc1/00000483.htm cheap hydrocodone http://ss3054.k12.sd.us/_disc1/0000004d.htm cheap hydrocodone http://www.freewebs.com/cash-640/cash-advance-invest.html cash advance invest cash advance invest payday cash advance texas payday cash advance texas http://www.freewebs.com/cash-256/payday-cash-advance-texas.html

0.0.0.* 于 2007-07-09 12:46:42发表:

http://www.freewebs.com/drugs-90/cheap-viagra.html cheap viagra uk cheap viagra uk giochi carte online giochi giochi online http://www.freewebs.com/poker-313/giochi-5.html free ringtone ringtone http://www.freewebs.com/ringtone-595/ringtones-14.html cheap cialis http://www.freewebs.com/drugs-182/cialis.html viagra cialis internet roulette casino roulette http://www.freewebs.com/casino-398/roulette-4.html

75.136.131.* 于 2007-07-09 11:45:44发表:

http://www.freewebs.com/drugs-322/tramadol-2.html tramadol buy tramadol http://www.usechemicalssafely.com/_disc1/000000c9.htm buy hydrocodone online buy hydrocodone online download free cingular ringtones download free cingular ringtones http://www.freewebs.com/ringtone-251/free-ringtones-8.html giochi casino http://www.freewebs.com/casino-978/casino-game-2.html casino gioca http://www.marysvilleteachers.org/forum/_MUTAdiscussion/000006ab.htm buy carisoprodol buy carisoprodol

64.26.157.* 于 2007-07-09 11:26:31发表:

buy xenical http://www.2174avenger.com/Discussion/_disc1/0000082f.htm buy xenical http://www.freewebs.com/ringtone-745/ringtone-15.html ringtone dave hollister ringtone cash advance usa cash advance usa http://www.freewebs.com/cash-862/cash-advance-usa.html download free cingular ringtones http://www.freewebs.com/ringtone-837/free-ringtones-3.html free ringtones cheap cialis cheap cialis http://www.freewebs.com/drugs-989/cheap-cialis-2.html

0.0.0.* 于 2007-07-09 11:24:44发表:

http://www.freewebs.com/ringtone-888/free-ringtones-7.html free cingular cell phone ringtones free real ringtones cheap fioricet http://www.freewebs.com/drugs-79/cheap-fioricet-2.html cheap fioricet online videopoker http://www.freewebs.com/poker-82/video-poker-3.html internet video poker http://www.freewebs.com/poker-313/video-poker-7.html internet videopoker online videopoker cash advance minneapolis cash advance minneapolis http://www.freewebs.com/cash-862/cash-advance-minneapolis.html

0.0.0.* 于 2007-07-09 10:57:07发表:

drug war http://www.kawiswaradharma.org/forum/000000d1.htm drug war stanze di gioco migliori stanze di gioco in linea libere http://www.freewebs.com/poker-734/gioco-7.html http://www.kawiswaradharma.org/forum/000000ce.htm cialis cialis web casino casino italia http://www.freewebs.com/casino-244/casino-6.html http://www.mooseheadband.com/_disc3/000000ff.htm order soma order soma

0.0.0.* 于 2007-07-09 10:42:25发表:

internet videopoker online video poker http://www.freewebs.com/poker-419/video-poker-4.html fast cash advance fast cash advance http://www.freewebs.com/cash-892/fast-cash-advance.html buy soma online http://www.freewebs.com/drugs-322/buy-soma.html buy soma http://www.freewebs.com/drugs-259/tramadol.html tramadol tramadol ultram casino gaming casino games http://www.freewebs.com/casino-398/casino-game-8.html

0.0.0.* 于 2007-07-09 10:39:25发表:

cash advance chicago cash advance chicago http://www.freewebs.com/cash-862/cash-advance-chicago.html soma cheap soma http://www.freewebs.com/drugs-870/soma-2.html casino slot casino slot http://www.freewebs.com/casino-834/slots-2.html cash advance philadelphia cash advance philadelphia http://www.freewebs.com/cash-177/cash-advance-philadelphia.html buy vigrx http://www.freewebs.com/drugs-591/buy-vigrx-2.html buy vigrx

76.186.171.* 于 2007-07-09 10:39:05发表:

buy viagra online buy viagra http://www.freewebs.com/drugs-399/buy-viagra-2.html http://www.freewebs.com/drugs-705/buy-fioricet.html buy fioricet buy fioricet play blackjack black jack http://www.freewebs.com/casino-418/blackjack-2.html gioco gratuito stanze di gioco http://www.freewebs.com/poker-82/gioco-6.html cialis http://www.booksbyrule.com/discb1/_disc3/00000295.htm cialis

75.71.130.* 于 2007-07-09 10:38:51发表:

cash advance pittsburgh cash advance pittsburgh http://www.freewebs.com/cash-256/cash-advance-pittsburgh.html cheap fioricet cheap fioricet http://www.freewebs.com/drugs-470/cheap-fioricet-2.html http://www.freewebs.com/drugs-591/carisoprodol-2.html buy carisoprodol online carisoprodol online roulette poker roulette internet http://www.freewebs.com/casino-672/roulette-5.html internet videopoker http://www.freewebs.com/poker-989/video-poker-9.html internet video poker

62.231.243.* 于 2007-07-09 10:11:17发表:

free penis enlargement penis enlargement surgery http://www.freewebs.com/drugs-705/penis-enlargement-2.html internet video poker online video poker http://www.freewebs.com/poker-734/video-poker-1.html cash advance oklahoma city http://www.freewebs.com/cash-127/cash-advance-oklahoma-city.html cash advance oklahoma city cash advance invest cash advance invest http://www.freewebs.com/cash-183/cash-advance-invest.html cheap levitra cheap levitra http://www.freewebs.com/drugs-470/cheap-levitra-2.html

198.30.120.* 于 2007-07-09 10:09:10发表:

cash advance riverside cash advance riverside http://www.freewebs.com/cash-838/cash-advance-riverside.html buy soma http://www.bilbyorganics.com.au/_disc3/000001d0.htm buy soma casino gaming casino games http://www.freewebs.com/casino-978/casino-game-4.html http://www.freewebs.com/cash-316/quick-cash-advance-loan.html quick cash advance loan quick cash advance loan cash advance america cash advance america http://www.freewebs.com/cash-256/cash-advance-america.html

201.211.226.* 于 2007-07-09 10:07:52发表:

http://www.freewebs.com/cash-640/no-fax-payday-cash-advance.html no fax payday cash advance no fax payday cash advance http://www.freewebs.com/ringtone-551/free-ringtones-12.html free mp3 ringtones free real music ringtones sprint http://www.freewebs.com/poker-549/giochi-9.html giochi on line giochi internet regola baccarat regole baccarat http://www.freewebs.com/poker-428/baccarat-2.html roulette game http://www.freewebs.com/casino-598/roulette-1.html online roulette poker

0.0.0.* 于 2007-07-09 10:06:13发表:

online poker game http://www.freewebs.com/poker-979/online-poker-2.html online poker game cheap phentermine cheap phentermine http://www.freewebs.com/drugs-705/cheap-phentermine.html buy tadalafil cialis cialis http://www.freewebs.com/drugs-79/cialis-2.html black jack black jack http://www.freewebs.com/casino-834/blackjack-4.html http://www.freewebs.com/poker-989/giochi-7.html tavoli multigiocatori poker tavoli multigiocatori poker

24.155.116.* 于 2007-07-09 10:05:03发表:

cheap tramadol http://www.freewebs.com/drugs-72/cheap-tramadol.html cheap tramadol cash advance austin cash advance austin http://www.freewebs.com/cash-640/cash-advance-austin.html cash advance austin http://www.freewebs.com/cash-496/cash-advance-austin.html cash advance austin free sprint ringtones http://www.freewebs.com/ringtone-510/ringtones-4.html free ringtone 500 cash advance 500 cash advance http://www.freewebs.com/cash-316/500-cash-advance.html

0.0.0.* 于 2007-07-09 10:01:52发表:

ameriloan cash advance ameriloan cash advance http://www.freewebs.com/cash-183/ameriloan-cash-advance.html payroll cash advance payroll cash advance http://www.freewebs.com/cash-41/payroll-cash-advance.html vioxx lawyer vioxx lawyer http://www.usechemicalssafely.com/_disc1/000000cc.htm http://rover.vetmed.lsu.edu/SCAVMA/_disc2011/0000032e.htm carisoprodol carisoprodol fioricet http://www.freewebs.com/drugs-399/fioricet-2.html buy fioricet

0.0.0.* 于 2007-07-09 10:01:37发表:

buy tramadol online buy tramadol online http://www.mamm-mariag.it/_disc12/00000106.htm viagra alternative viagra alternative http://thebluesband.com/webforum/_disc23/00003c66.htm hydrocodone hydrocodone http://www.kentpullen.com/_disc1KentPullen/0000021a.htm no fax payday cash advance no fax payday cash advance http://www.freewebs.com/cash-256/no-fax-payday-cash-advance.html drug treatment center drug treatment center http://www.springgreen.com/_bboard/0000292a.htm

0.0.0.* 于 2007-07-09 09:59:26发表:

hydrocodone online hydrocodone online http://www.aunttee.com/Entries/0000004c.htm black eyed pea ringtones download free ringtones http://www.freewebs.com/ringtone-837/ringtones-10.html tavoli da gioco poker tavoli da gioco poker http://www.freewebs.com/poker-191/giochi-9.html free ringtone ringtones http://www.freewebs.com/ringtone-510/ringtones-7.html internet blackjack http://www.freewebs.com/casino-837/blackjack-2.html online blackjack

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

http://www.freewebs.com/drugs-473/buy-soma-2.html buy soma buy soma quick cash advance http://www.freewebs.com/cash-892/quick-cash-advance.html quick cash advance casino games casino games http://www.freewebs.com/casino-387/casino-game-7.html cash advance austin cash advance austin http://www.freewebs.com/cash-892/cash-advance-austin.html http://www.freewebs.com/drugs-399/buy-soma.html buy soma buy soma online

219.141.223.* 于 2007-07-09 09:53:38发表:

http://www.freewebs.com/drugs-182/buy-vigrx.html buy vigrx buy vigrx poker online online poker game http://www.freewebs.com/poker-603/online-poker-3.html http://www.freewebs.com/poker-979/video-poker-4.html online video poker online videopoker chips di poker http://www.freewebs.com/poker-313/poker-1.html chips di poker national cash advance national cash advance http://www.freewebs.com/cash-177/national-cash-advance.html

200.74.133.* 于 2007-07-09 09:52:48发表:

http://www.freewebs.com/poker-806/poker-8.html partypoker poker games http://www.freewebs.com/drugs-90/penis-enlargement-2.html penis enlargement technique penis enlargement pill verizon ringtones http://www.freewebs.com/ringtone-745/ringtones-4.html verizon ringtones cheap viagra uk http://www.freewebs.com/drugs-112/cheap-viagra-2.html cheap viagra http://www.freewebs.com/ringtone-728/free-ringtones-12.html free nokia ringtones free ringtones

0.0.0.* 于 2007-07-09 09:52:32发表:

http://www.freewebs.com/drugs-989/phentermine.html phentermine discount phentermine buy phentermine online buy phentermine online http://www.painareas.com/_disc1/00000134.htm natural penis enlargement http://www.freewebs.com/drugs-72/penis-enlargement-2.html penis enlargement http://www.freewebs.com/cash-388/cash-advance-universal.html cash advance universal cash advance universal online poker game poker online http://www.freewebs.com/poker-549/online-poker-1.html

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

72.181.231.* 于 2007-07-09 09:51:04发表:

regole crap http://www.freewebs.com/casino-837/craps-3.html craps online 1000 cash advance http://www.freewebs.com/cash-640/1000-cash-advance.html 1000 cash advance buy soma buy soma http://ss3054.k12.sd.us/_disc1/0000004b.htm online roulette online roulette http://www.freewebs.com/casino-228/roulette-8.html cash advance las vegas cash advance las vegas http://www.freewebs.com/cash-413/cash-advance-las-vegas.html

0.0.0.* 于 2007-07-09 09:50:46发表:

regole baccarat regole baccarat http://www.freewebs.com/poker-818/baccarat-7.html cash advance america cash advance america http://www.freewebs.com/cash-496/cash-advance-america.html http://www.vereinsring-liederbach.de/_disc1/0000008c.htm prescription drug prescription drug stanze di gioco migliori http://www.freewebs.com/poker-719/gioco-7.html stanze di gioco http://www.freewebs.com/cash-127/cash-advance-columbus-ohio.html cash advance columbus ohio cash advance columbus ohio

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

共有 2229 条评论

频道文章

最新教程

随机推荐