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

74.75.52.* 于 2007-07-06 16:42:51发表:

adipex p http://discuss.mid.tec.sc.us/socdiscuss/_disc12/00000de4.htm adipex p free cingular ringtone http://www.freewebs.com/ringtone-888/free-ringtone-10.html free alltel ringtone http://www.freewebs.com/casino-172/online-casino-5.html casino internet casino ligne free ringtone free cingular ringtone http://www.freewebs.com/ringtone-939/free-ringtone-6.html bonus casino de paris http://www.freewebs.com/casino-351/casino-9.html

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

jeu de carte http://www.freewebs.com/poker-857/jeu-poker-20.html jeu drug online drug online http://24-7christianministries.com/_24-7Ministriesdisc1/0000006a.htm http://www.trueranger.com/_disc1/0000430c.htm levitra levitra la fran?ise des jeux http://www.freewebs.com/poker-148/jeu-10.html jeu flash http://www.freewebs.com/casino-919/casino-11.html meilleur casino en ligne top casinos promotions

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

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

http://www.tourdepub.com/_smack/0000123d.htm drug online drug online http://www.freewebs.com/poker-816/poker-15.html poker en ligne meilleures salles de poker buy soma buy soma http://www.dfs-fuchsia.dk/_disc1/00004fcb.htm casinos en ligne casinos en ligne http://www.freewebs.com/casino-988/online-casino-14.html drug addiction drug addiction http://destinychristianministries.org/_disc7/000004de.htm

12.180.115.* 于 2007-07-06 16:36:27发表:

free online roulette http://www.freewebs.com/casino-60/roulette-4.html free online roulette blackjack odds blackjack odds http://www.freewebs.com/casino-60/blackjack-5.html casinos http://www.freewebs.com/casino-781/casino-1.html top casino en ligne no fax payday loan http://www.tebidine.com/twm-enterprises/_disc1/0000128d.htm no fax payday loan casino slots play free slots http://www.freewebs.com/casino-60/slots-3.html

216.197.204.* 于 2007-07-06 16:33:45发表:

jeu en ligne jeu online http://www.freewebs.com/poker-308/jeu-20.html casino jeu jeu casino ligne http://www.freewebs.com/casino-758/jeu-casino-15.html free ringtone http://www.freewebs.com/ringtone-465/free-ringtone-14.html free verizon ringtone ringtone marilyn manson ringtone http://www.freewebs.com/ringtone-939/ringtone.html http://www.freewebs.com/poker-824/jeu-5.html jeu pc gamme net jeu

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

http://www.freewebs.com/casino-172/casino-5.html gambling bonus buy viagra http://www.citizensmatrix.com/_disc1/000000ef.htm buy viagra jouer casino jeu casino ligne http://www.freewebs.com/casino-781/jeu-casino-20.html http://www.freewebs.com/poker-816/jeu-poker-16.html jeu pc jeu flash casino online http://www.freewebs.com/casino-758/online-casino-4.html casino en ligne

210.51.51.* 于 2007-07-06 14:46:46发表:

jeu casino ligne http://www.freewebs.com/casino-706/jeu-casino-8.html casino jeu meilleures promotions en ligne http://www.freewebs.com/casino-781/casino-7.html bonus http://www.freewebs.com/poker-774/jeu-poker-15.html jeu jeu eckerd drug eckerd drug http://www.cahunger.com/_disc1/000007fd.htm casino net http://www.freewebs.com/casino-300/online-casino-13.html casino net

0.0.0.* 于 2007-07-06 14:08:32发表:

gambling casino de paris http://www.freewebs.com/casino-170/casino-5.html http://www.freewebs.com/poker-915/jeu-17.html jeu online jeu en ligne jeu online gamme net jeu http://www.freewebs.com/poker-816/jeu-18.html free verizon ringtone free polyphonic ringtone http://www.freewebs.com/ringtone-287/free-ringtone-13.html cheap tramadol cheap tramadol http://www.rebbook.com/_disc1/0000040f.htm

0.0.0.* 于 2007-07-06 14:00:06发表:

le top des casinos en ligne http://www.freewebs.com/casino-703/online-casino-7.html casino virtuel tramadol prescription tramadol prescription http://rlstaton.com/mymessageboard/_disc2/00001d33.htm http://home.cfl.rr.com/jbesaw/_disc1/0000005f.htm drug war drug war jeu casino gratuit jeu casino gratuit http://www.freewebs.com/casino-729/jeu-casino-6.html jeu de carte jeu http://www.freewebs.com/poker-304/jeu-poker-1.html

201.17.62.* 于 2007-07-06 13:37:35发表:

free ringtone http://www.freewebs.com/ringtone-251/free-ringtone-7.html free motorola ringtone meilleurs casinos en ligne top des casinos en ligne http://www.freewebs.com/casino-274/casino-11.html http://www.freewebs.com/casino-319/casino-5.html meilleures promotions en ligne bonus gratuits buy viagra online http://detroit.originalchurchofgod.net/_prayer_req/000004f8.htm buy viagra online http://www.freewebs.com/poker-304/jeu-poker-6.html jeu de carte jeu java

24.11.206.* 于 2007-07-06 13:20:30发表:

casino online internet casino http://www.freewebs.com/casino-919/online-casino-3.html casino jeu jouer casino http://www.freewebs.com/casino-526/jeu-casino-20.html http://www.freewebs.com/ringtone-888/free-ringtone-7.html 100 free ringtone free ringtone http://www.faxnet1.org/_gridbi12/00001b13.htm buy hydrocodone online buy hydrocodone online buy tramadol online http://www.thelazaruslives.com/Racism%20Discussion%20Forum/Racism/00000042.htm buy tramadol online

69.244.48.* 于 2007-07-06 12:13:03发表:

http://www.mamm-mariag.it/_disc12/00000103.htm eckerd drug eckerd drug ambien online http://www.rockwood.k12.mo.us/lafayette/languagearts/Blog/training/_disc1/00006539.htm ambien online casino en ligne http://www.freewebs.com/casino-821/online-casino-10.html casinos en ligne http://www.gaitedhorsebooks.com/_disc50/00000819.htm buy ambien buy ambien jeu flash gratuit gamme net jeu http://www.freewebs.com/poker-102/jeu-13.html

0.0.0.* 于 2007-07-06 11:51:54发表:

hydrocodone hydrocodone http://www.post3legion.com/_disc1/00000090.htm top casino en ligne top casino en ligne http://www.freewebs.com/casino-758/casino-19.html drug addiction http://district19.us/AskDistrict19/_disc9/000003e9.htm drug addiction http://www.freewebs.com/poker-593/jeu-16.html jeu pc jeu en ligne le meilleur poker en ligne online poker http://www.freewebs.com/poker-849/poker-11.html

0.0.0.* 于 2007-07-06 11:47:17发表:

casinos gratuits casinos gratuits http://www.freewebs.com/casino-640/casino-5.html http://www.vagleleiren.sandnes.no/odisk/_olopdisk/000003f0.htm celexa celexa penis enlargement penis enlargement http://www.gotobaker.com/_job1disc/000000a3.htm weight loss drug http://www.iaap-satellite.org/_disc1/00001176.htm weight loss drug http://www.freewebs.com/poker-226/poker-15.html le meilleur poker en ligne salles virtuelles de poker gratuit

218.54.139.* 于 2007-07-06 11:46:05发表:

casino en line casino net http://www.freewebs.com/casino-279/online-casino-3.html fran?ise des jeux jeu flash gratuit http://www.freewebs.com/poker-857/jeu-11.html vicodin vicodin http://www.globalinkonline.com/_disc3/000001ef.htm casino en ligne http://www.freewebs.com/casino-919/online-casino-1.html casino en line renova renova http://www.bhmvending.com/BVC_Forum/_forum/00000221.htm

0.0.0.* 于 2007-07-06 11:45:32发表:

jouer casino jeu casino gratuit http://www.freewebs.com/casino-421/jeu-casino-15.html http://www.freewebs.com/casino-706/jeu-casino-4.html jeu casino ligne jouer casino http://www.yachtxperts.com/_bocam/00000994.htm food and drug administration food and drug administration http://www.freewebs.com/ringtone-728/ringtone-6.html selena ringtone selena ringtone jeu casino ligne casino jeu http://www.freewebs.com/casino-640/jeu-casino-9.html

69.22.85.* 于 2007-07-06 11:42:15发表:

jeu flash gratuit jeu flash gratuit http://www.freewebs.com/poker-32/jeu-7.html 100 free ringtone http://www.freewebs.com/ringtone-540/free-ringtone-7.html free real ringtone download free verizon ringtone download free verizon ringtone http://www.freewebs.com/ringtone-287/free-ringtone-6.html hydrocodone online hydrocodone online http://jobinsurance.com/ble624/_div624bb/000005cc.htm jeu de poker gratuit http://www.freewebs.com/poker-824/poker-15.html online poker

0.0.0.* 于 2007-07-06 11:38:56发表:

hydrocodone online hydrocodone online http://www.powerofhistory.com/_NorthKorea/00000075.htm penis enlargement penis enlargement http://www.hometic.com/_disc10/00000063.htm http://www.freewebs.com/casino-351/online-casino-12.html casino internet le top des casinos en ligne world poker tour world poker tour http://www.freewebs.com/poker-303/poker-20.html casino de paris casinos gratuits http://www.freewebs.com/casino-470/casino-16.html

218.38.214.* 于 2007-07-06 11:17:12发表:

drug war drug war http://www.3kingsdomain.com/Immortalcars/_disc12/00000056.htm tramadol prescription tramadol prescription http://timeforaction.org/_disc2/00000f5e.htm http://members.tripod.com/stjoe1967/_disc1/0000001a.htm drug treatment center drug treatment center http://www.freewebs.com/casino-781/online-casino-11.html casino virtuel casino online free cingular cell phone ringtone http://www.freewebs.com/ringtone-837/free-ringtone-8.html download free verizon ringtone

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

jeu casino gratuit jeu casino gratuit http://www.freewebs.com/casino-414/jeu-casino-19.html http://www.cocoanutheads.com/_discussion-group/0000009f.htm discount drug discount drug les meilleurs casinos en ligne http://www.freewebs.com/casino-988/online-casino-4.html casino on net casino gratuit http://www.freewebs.com/casino-300/casino-7.html casino gratuit casino de paris http://www.freewebs.com/casino-706/casino-13.html meilleures promotions en ligne

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

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

72.232.63.* 于 2007-07-06 07:08:17发表:

72.232.63.* 于 2007-07-06 07:07:46发表:

72.232.63.* 于 2007-07-06 07:07:33发表:

74.135.247.* 于 2007-07-06 01:02:00发表:

top casinos promotions http://www.freewebs.com/casino-414/casino-7.html meilleures promotions en ligne buy vicodin buy vicodin http://diaperswing.com/post/_dc1/00000074.htm les meilleurs casinos en ligne http://www.freewebs.com/casino-80/online-casino-4.html casino net viagra alternative viagra alternative http://www.otegolittleleague.org/discussion/_disc1/00000e44.htm viagra pill viagra pill http://www.bernhardnordh.nu/_disk6/000018b3.htm

0.0.0.* 于 2007-07-05 23:30:41发表:

hoodia and phentermine hoodia and phentermine http://www.patriotpacksinc.org/discussions/_disc1/0000599a.htm black eyed pea ringtone black eyed pea ringtone http://www.freewebs.com/ringtone-551/ringtone-7.html pacific poker pacific poker http://www.freewebs.com/poker-630/poker-11.html http://www.iveco-kundendienst.de/diskussion/stralis/_disc12/000009e5.htm drug treatment drug treatment jeu de carte http://www.freewebs.com/poker-849/jeu-poker-17.html jeu

75.14.35.* 于 2007-07-05 23:17:27发表:

Hi , my sites: :
free music download sites = mp3 downloads = free mp3 music downloads = free ipod music downloads = free music = free limewire = FREE MUSIC DOWNLOADS = download music video = FREE MUSIC DOWNLOADS =
http://musicdownloadsmp3.tripod.com music download free :: http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3#freemusicdownloads free music ipods :: http://www.sopadre.com/gallery/louies/music.html FREE MUSIC DOWNLOADS :: http://mywebpage.netscape.com/music10free/music-download/ download music video :: http://hometown.aol.com/mp33music/legal_music_downloads.html free music downloads :: http://musicdownloadsmp3.tripod.com/music_downloads.html limewire :: http://hometown.aol.com/mp33music/legal_music_downloads.html Free Music Downloads :: http://mywebpage.netscape.com/bwwfst/Download-Free-Music.htm mp3 downloads :: http://mywebpage.netscape.com/free5mp3/mp3music.html mp3 downloads :: http://musicdownloads4free.angelfire.com/free-music.html free ipod music downloads sites :: http://nmstandards.org/portal_memberdata/portraits/vsemoe#musicdownloads free music downloads ::
music download free .. free music for ipod .. legal music downloads .. classical music downloads .. free mp3 downloads .. free music download sites .. free music downloads ..

64.22.121.* 于 2007-07-05 22:42:07发表:

Hi , my sites: :
Free Music Downloads = download free music = mp3 downloads = music download free = free mp3 downloads = free music for ipod = free music downloads = free mp3 = mp3 downloads =
http://musicdownloadsmp3.tripod.com free country music downloads :: http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3#freemusicdownloads free music downloading :: http://www.sopadre.com/gallery/louies/music.html music download free :: http://mywebpage.netscape.com/music10free/music-download/ mp3 downloads :: http://hometown.aol.com/mp33music/legal_music_downloads.html music :: http://musicdownloadsmp3.tripod.com/music_downloads.html FREE MUSIC DOWNLOADS :: http://hometown.aol.com/mp33music/legal_music_downloads.html Free Music Downloads :: http://mywebpage.netscape.com/bwwfst/Download-Free-Music.htm Free Music Downloads :: http://mywebpage.netscape.com/free5mp3/mp3music.html download music for free :: http://musicdownloads4free.angelfire.com/free-music.html FREE MUSIC DOWNLOADS :: http://nmstandards.org/portal_memberdata/portraits/vsemoe#musicdownloads free country music downloads ::
download music free .. free mp3 music downloads .. free music downloading .. download music free .. music .. free music .. Free Music Downloads ..

67.15.179.* 于 2007-07-05 22:39:25发表:

jeu casino gratuit jeu casino ligne http://www.freewebs.com/casino-172/jeu-casino-8.html casino net http://www.freewebs.com/casino-414/online-casino-18.html casino virtuel jouez au casino en ligne jouez au casino en ligne http://www.freewebs.com/casino-919/casino-8.html jeu en ligne jeu http://www.freewebs.com/poker-32/jeu-poker-16.html http://www.freewebs.com/casino-470/online-casino-7.html casino internet le top des casinos en ligne

71.200.14.* 于 2007-07-05 22:32:45发表:

les meilleurs casinos en ligne les meilleurs casinos en ligne http://www.freewebs.com/casino-781/online-casino-6.html

89.149.226.* 于 2007-07-05 22:17:48发表:

Hi , my sites: :
free mp3 downloads = download free music = music downloads = music downloads pc = music = download music free = Free Music Downloads = music download free = free music =
http://musicdownloadsmp3.tripod.com FREE MUSIC DOWNLOADS :: http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3#freemusicdownloads Free Music Downloads :: http://www.sopadre.com/gallery/louies/music.html free music ipods :: http://mywebpage.netscape.com/music10free/music-download/ classical music downloads :: http://hometown.aol.com/mp33music/legal_music_downloads.html free music downloads :: http://musicdownloadsmp3.tripod.com/music_downloads.html free music downloads :: http://hometown.aol.com/mp33music/legal_music_downloads.html free music downloads :: http://mywebpage.netscape.com/bwwfst/Download-Free-Music.htm free music to download :: http://mywebpage.netscape.com/free5mp3/mp3music.html download music free :: http://musicdownloads4free.angelfire.com/free-music.html free mp3 music downloads :: http://nmstandards.org/portal_memberdata/portraits/vsemoe#musicdownloads free music downloads ::
free music downloads .. download free music .. Free Music Downloads .. classical music downloads .. FREE MUSIC DOWNLOADS .. free music .. Free Music Downloads ..

210.255.192.* 于 2007-07-05 21:30:53发表:

blogspot.com fax loan no payday site blogspot.com fax loan no payday site http://www.mescoelectricalsupply.com/_disc3/00002995.htm no faxing payday loan http://www.dharmamemphis.com/_discussion002/00000665.htm no faxing payday loan casino roulette http://www.freewebs.com/casino-49/roulette-5.html internet roulette casino slots internet casino http://www.freewebs.com/casino-41/casino-5.html http://www.freewebs.com/casino-49/roulette-7.html online roulette game free roulette

124.51.21.* 于 2007-07-05 21:30:12发表:

payday loan canada payday loan canada http://www.pelicanpointe.net/_disc1/00001c87.htm free online baccarat baccarat online http://www.freewebs.com/casino-49/baccarat-1.html payday loan store payday loan store http://www.thetalkingfrog.com/_disc1/0000028c.htm fast payday loan http://www.dharmamemphis.com/_discussion002/00000668.htm fast payday loan free casino game internet casino http://www.freewebs.com/casino-45/casino-7.html

220.217.50.* 于 2007-07-05 21:18:57发表:

http://www.freewebs.com/casino-279/casino-2.html jouez au casino jouez au casino http://www.freewebs.com/casino-60/baccarat-7.html casino baccarat play baccarat online casino roulette free roulette game http://www.freewebs.com/casino-60/roulette-7.html free baccarat free baccarat http://www.freewebs.com/casino-60/baccarat-3.html http://www.freewebs.com/casino-60/baccarat-6.html online baccarat baccarat game

0.0.0.* 于 2007-07-05 13:23:17发表:

loan til payday http://www.bigtalldirect.com/pages/_disc2/00004936.htm loan til payday http://www.freewebs.com/casino-41/craps-3.html casino craps craps table http://www.freewebs.com/casino-41/keno-7.html keno casino keno casino slots machine game play free slots machine http://www.freewebs.com/casino-41/slots-4.html free online baccarat casino baccarat http://www.freewebs.com/casino-49/baccarat-7.html

62.231.243.* 于 2007-07-05 13:05:39发表:

http://www.freewebs.com/casino-466/casino-1.html jouez au casino meilleur casino en ligne http://www.freewebs.com/casino-60/keno-5.html internet keno free online keno bonus gratuits bonus http://www.freewebs.com/casino-863/casino-2.html las vegas casino http://www.freewebs.com/casino-49/casino-7.html best online casino gambling casino france http://www.freewebs.com/casino-703/casino-1.html bonus de casino en ligne

24.11.6.* 于 2007-07-05 12:42:32发表:

jouez au casino bonus de casino en ligne http://www.freewebs.com/casino-919/casino-3.html roulette tip roulette tip http://www.freewebs.com/casino-60/roulette-3.html casino fran?is casinos http://www.freewebs.com/casino-758/casino-2.html http://www.freewebs.com/casino-60/craps-7.html rules of craps casino craps free keno games http://www.freewebs.com/casino-60/keno-6.html free keno games

85.194.127.* 于 2007-07-05 12:07:27发表:

jack black play blackjack online free http://www.freewebs.com/casino-60/blackjack-6.html keno casino free online keno http://www.freewebs.com/casino-60/keno-3.html http://www.freewebs.com/casino-60/card-stud-6.html 7 card stud 7 card stud http://www.freewebs.com/casino-863/casino-3.html jouez au casino bonus gratuits military payday loan military payday loan http://www.bernhardnordh.nu/_disk6/000018a0.htm

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

共有 2229 条评论

频道文章

最新教程

随机推荐