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

203.121.69.* 于 2007-07-31 01:57:24发表:

Great! Best free mp3 music downloads site: :
free music downloads = free music = music downloads = music = free mp3 downloads = music download = free music download = download music free = download music for free =
http://www.fixgrout.com/cgi/ free music downloads :: http://www.fixgrout.com/cgi/musicpage1.html free music :: http://www.fixgrout.com/cgi/musicpage2.html music downloads :: http://www.fixgrout.com/cgi/musicpage3.html music :: http://www.fixgrout.com/cgi/musicpage4.html free mp3 downloads :: http://www.fixgrout.com/cgi/musicpage5.html music download :: http://www.fixgrout.com/cgi/musicpage6.html free music download :: http://www.fixgrout.com/cgi/musicpage7.html download music free :: http://www.fixgrout.com/cgi/musicpage8.html download music for free :: http://www.fixgrout.com/cgi/musicpage9.html free download music :: http://www.fixgrout.com/cgi/musicpage10.html download music video ::
free music downloads .. free music .. music downloads .. music .. free mp3 downloads .. music download .. free music download ..

72.36.211.* 于 2007-07-29 21:54:08发表:

72.36.211.* 于 2007-07-29 21:53:36发表:

72.36.211.* 于 2007-07-29 21:52:36发表:

72.36.211.* 于 2007-07-29 21:52:13发表:

72.36.211.* 于 2007-07-29 21:52:06发表:

72.36.211.* 于 2007-07-28 08:26:44发表:

72.36.211.* 于 2007-07-28 08:26:19发表:

72.36.211.* 于 2007-07-28 08:25:14发表:

72.36.211.* 于 2007-07-28 08:24:55发表:

72.36.211.* 于 2007-07-28 08:24:44发表:

86.132.83.* 于 2007-07-27 23:40:37发表:

baby girl gift baby girl gift http://www.weihnachtsgeschenk-1.info/5/1164.html florida medical malpractice attorney florida medical malpractice attorney http://www.it-legge.info/post/florida-medical-malpractice-attorney regalo cane pointer regalo cane pointer http://www.1regalo-bambino.info/cat/1307 gestion des document technique gestion des document technique http://www.loifr.info/1/gestion-des-document-technique minnesota mesothelioma attorney minnesota mesothelioma attorney http://www.1ley-testigo.info/1916 forme juridique d4une forme juridique d4une http://www.french-law-attorney.info/4/1287 regalo cachorro perro agua sevilla regalo cachorro perro agua sevilla http://www.regalo-it.info/1647.html ca court norwalk superior ca court norwalk superior http://www.1commonlaw.info/2007/ca-court-norwalk-superior abogado especialidad extranjeria granada abogado especialidad extranjeria granada http://www.es-law-lawyer.info/1527.asp documento no mercantil documento no mercantil http://www.law-judgement-es.info/today/1587.html

84.229.128.* 于 2007-07-27 21:59:03发表:

sistema sanzionatorio penale giudice pace sistema sanzionatorio penale giudice pace http://www.law-judgement-italy.info/1097 plante system plante system http://www.fr-flower-1.info/plante-system.html rechtsanwalt saarbruecken rechtsanwalt saarbruecken http://www.gesetz-deutsch.info/9/rechtsanwalt-saarbruecken lock x box hard drive lock x box hard drive http://www.giftshop-1.info/post/1726.php immigration attorney houston immigration attorney houston http://www.12law-advocat.info/1951.asp geschenkidee blume geschenkidee blume http://www.babygeschenk.info/online/1238.asp hanford criminal lawyer hanford criminal lawyer http://www.de-law-lawyer.info/book/1390.php investigacion planta medicinal odontologia investigacion planta medicinal odontologia http://www.es-flor-artificial.info/5/investigacion-planta-medicinal-odontologia.asp illinois native plant illinois native plant http://www.sendflowers1.info/articles/illinois-native-plant.php recette salade avocat pamplemousse recette salade avocat pamplemousse http://www.loi-avocat-fr.info/3/recette-salade-avocat-pamplemousse.php

86.216.245.* 于 2007-07-27 21:39:40发表:

hermann rechtsanwalt frankfurt hermann rechtsanwalt frankfurt http://www.de-gesetz-gericht.info/hermann-rechtsanwalt-frankfurt.asp ombrelloni legno giardino ombrelloni legno giardino http://www.1-flower-it.info/info/1664.php forme juridique pharmacie forme juridique pharmacie http://www.1law-judge-fr.info/1876.html wedding gift registry wedding gift registry http://www.regalos-navidad.info/pdf/1169.html tartaruga oggetto regalo tartaruga oggetto regalo http://www.baby-gift-ita.info/phorum/tartaruga-oggetto-regalo.asp candy flower bouquet candy flower bouquet http://www.flowers-online-es.info/news/1886 estate firm law real estate firm law real http://www.123law-advocat.info/10/1961.html idee cadeaux anniversaire 50 ans idee cadeaux anniversaire 50 ans http://www.fr-gift-baskets.info/articles/idee-cadeaux-anniversaire-50-ans.php regalo original centro golosina regalo original centro golosina http://www.es-gifts-1.info/comment/regalo-original-centro-golosina planta generadoras de energia electrica planta generadoras de energia electrica http://www.flowers-online-es.info/planta-generadoras-de-energia-electrica.html

81.49.234.* 于 2007-07-27 21:17:47发表:

second mortgage financing second mortgage financing http://www.1student-loan.info/post/second-mortgage-financing avocat en divorce a arlon avocat en divorce a arlon http://www.1-loi-avocat.info/new/avocat-en-divorce-a-arlon.html visa gift card locations visa gift card locations http://www.gift-baskets-es.info/online/1778.asp regalo chico regalar novio regalo chico regalar novio http://www.123regalo.info/new/1431.asp mini armario invernadero planta carnivora mini armario invernadero planta carnivora http://www.1-flor-artificial.info/mini-armario-invernadero-planta-carnivora.html uso planta medicinal uso planta medicinal http://www.1comprar-flores.info/1168.php advocate brand advocate brand http://www.law-advocat-1.info/cat/advocate-brand.html thorsten pflueger rechtsanwalt koeln thorsten pflueger rechtsanwalt koeln http://www.gesetz-deutsch.info/1827.asp blume bad essen blume bad essen http://www.german-silk-flowers.info/1000.php klein geschenk geschenkidee besondere klein geschenk geschenkidee besondere http://www.1geschenkkorb.info/klein-geschenk-geschenkidee-besondere.html

81.187.177.* 于 2007-07-27 20:08:47发表:

wholesale silk flower company wholesale silk flower company http://www.1-fresh-flowers.info/wholesale-silk-flower-company.php documento requerido documento requerido http://www.spanish-law-attorney.info/news/1899.asp medical malpractice attorney nyc medical malpractice attorney nyc http://www.it-law-lawyer.info/medical-malpractice-attorney-nyc.php versand rose versand rose http://www.origami-blume-de.info/1780.asp free starbucks gift card free starbucks gift card http://www.1gift-it.info/comment/free-starbucks-gift-card.asp benefits of document management benefits of document management http://www.es-ley-corte.info/2006/1091 geschenk zur taufe geschenk zur taufe http://www.gift-de.info/2006/geschenk-zur-taufe.asp tattoo flower design tattoo flower design http://www.envio-de-flores.info/forum/1411.html steroidsozme.net flower basket steroidsozme.net flower basket http://www.fr-wedding-flowers.info/online/steroidsozme.net-flower-basket.asp consiglio regalo battesimo consiglio regalo battesimo http://www.gift-ita.info/today/1283.php

76.20.62.* 于 2007-07-27 14:03:44发表:

giardini della landriana giardini della landriana http://www.1-foto-fiori.info/giardini-della-landriana.php flower garden in plant flower garden in plant http://www.send-flowers1.info/docs/1006.asp grad gifts grad gifts http://www.1idee-cadeaux.info/grad-gifts.asp make silk flower arrangement make silk flower arrangement http://www.bouquet-de-fleurs.info/1114.html flower orchid picture flower orchid picture http://www.1silk-flowers.info/5/1181.asp regalo peluche personalizado regalo peluche personalizado http://www.1gift-baskets-es.info/8/1870 360 box computer controller x 360 box computer controller x http://www.gift1.info/tools/360-box-computer-controller-x.html carolina lawyer north traffic carolina lawyer north traffic http://www.1law-school.info/carolina-lawyer-north-traffic.asp missouri attorney general jay nixon missouri attorney general jay nixon http://www.1common-law.info/9/missouri-attorney-general-jay-nixon.html ordine avvocato verona ordine avvocato verona http://www.1legge.info/7/ordine-avvocato-verona

209.234.173.* 于 2007-07-27 09:30:31发表:

medical malpractice attorney medical malpractice attorney http://www.1law-witness-fr.info/6/1304.php avocat conseil toulouse avocat conseil toulouse http://www.1-fr-law.info/ads/1450 entretien de plante carnivore entretien de plante carnivore http://www.fr-send-flowers.info/blog/1178.html send a get well basket send a get well basket http://www.1-gift-shop.info/1066 box drive hard x box drive hard x http://www.gifts-123.info/7/1738 coffret cadeaux musee coffret cadeaux musee http://www.frgift.info/forum/1390 gift basket for mom gift basket for mom http://www.it-baby-gift.info/posts/gift-basket-for-mom site www.golem.de dokument site www.golem.de dokument http://www.deutsch-gesetz.info/site-www.golem.de-dokument planta de flor rojas planta de flor rojas http://www.1silk-flowers-es.info/latest/1627.asp regalo regalo personalizado calendario mesa regalo regalo personalizado calendario mesa http://www.regalo1.info/5/1801.php

72.36.211.* 于 2007-07-27 06:55:48发表:

72.36.211.* 于 2007-07-27 06:54:56发表:

72.36.211.* 于 2007-07-27 06:54:23发表:

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

72.36.211.* 于 2007-07-27 06:53:57发表:

69.121.184.* 于 2007-07-27 06:38:54发表:

proces fleurs mal nouvelle forme censure proces fleurs mal nouvelle forme censure http://www.fr-send-flowers.info/proces-fleurs-mal-nouvelle-forme-censure.asp avocat droit travail salarie paris avocat droit travail salarie paris http://www.1law-fr.info/blog/avocat-droit-travail-salarie-paris.html corporate promotional gift corporate promotional gift http://www.christmas-gift-it.info/articles/corporate-promotional-gift.php clipart blumen clipart blumen http://www.blume-basteln-de.info/phorum/1117.html avocat and conseil avocat and conseil http://www.fr-law-justice.info/1/1913.php colorado lemon law colorado lemon law http://www.spanish-law-judgement.info/colorado-lemon-law.php loi and sur and l eau loi and sur and l eau http://www.fr-law-lawyer.info/tag/loi-and-sur-and-l-eau.html emc mortgage career emc mortgage career http://www.1onlineloan.info/5/1338 box moving supply box moving supply http://www.giftwrap1.info/ads/box-moving-supply.asp nota corte 2006 madrid nota corte 2006 madrid http://www.1ley-testigo.info/post/1508.html

75.108.72.* 于 2007-07-27 03:47:41发表:

literature and the writing process 7th edition literature and the writing process 7th edition http://www.law-judgement.info/tools/literature-and-the-writing-process-7th-edition.asp document vente vehicule document vente vehicule http://www.french-law-lawyer.info/articles/1021.php blumen hamburg stellingen gaertnerei blumen hamburg stellingen gaertnerei http://www.wedding-flowers-de.info/info/1586.php wicker picnic basket wicker picnic basket http://www.1gift-boxes.info/wicker-picnic-basket.html self locking mail box self locking mail box http://www.1gift-cards.info/5/self-locking-mail-box.php designer dress flower girl designer dress flower girl http://www.1-flowersonline.info/9/designer-dress-flower-girl court oklahoma record court oklahoma record http://www.law-advocat-1.info/1480.php wine and cigar gift basket wine and cigar gift basket http://www.1giftbaskets.info/ads/wine-and-cigar-gift-basket dgme conservation document administration dgme conservation document administration http://www.1french-law.info/1677.html employment law test employment law test http://www.law-lawyer-ita.info/comment/1011

24.32.203.* 于 2007-07-27 03:18:03发表:

sistema irrigazione giardino sistema irrigazione giardino http://www.foto-fiori-ita.info/docs/sistema-irrigazione-giardino gadget vista tnt gadget vista tnt http://www.fr-baby-gift.info/1497.php organizzare vivaio pianta fiore organizzare vivaio pianta fiore http://www.12fiori.info/9/1284 customer gmac login mortgage customer gmac login mortgage http://www.1carloan.info/online/1596.php regime juridique assurance deces regime juridique assurance deces http://www.1-loi-avocat.info/1301.asp dibujo animados gifts dibujo animados gifts http://www.1spanish-gifts.info/1734 esame di stato avvocato esame di stato avvocato http://www.law-attorney-ita.info/2007/esame-di-stato-avvocato.php colegio de abogado de alicante colegio de abogado de alicante http://www.spanish-law-judgement.info/post/1518 rechtsanwalt verkehrsrecht 50668 rechtsanwalt verkehrsrecht 50668 http://www.1gesetz-gericht-de.info/rechtsanwalt-verkehrsrecht-50668.php index of mp3 seed ding index of mp3 seed ding http://www.1-deutsch-blume.info/index-of-mp3-seed-ding.html

207.42.135.* 于 2007-07-27 00:34:13发表:

new york law school new york law school http://www.1-gesetz.info/docs/1779.html cadeaux naissance composition aubeberoi cadeaux naissance composition aubeberoi http://www.1cadeau-anniversaire.info/6/cadeaux-naissance-composition-aubeberoi baby cool gift shower baby cool gift shower http://www.babygeschenk.info/1058.php foto rose tattoo foto rose tattoo http://www.de-blume.info/info/foto-rose-tattoo planta medicinales de guatemala planta medicinales de guatemala http://www.flor-artificial-es.info/today/1825 progressive insurance phone number progressive insurance phone number http://www.1-home-insurance.info/1332.html baptism gift ideas baptism gift ideas http://www.idea-regalo-1.info/tag/baptism-gift-ideas.html birthday flower gift birthday flower gift http://www.1flowers-online-es.info/1754.html rose online download rose online download http://www.1origami-blume.info/1826 vivero planta sta maria mallorca vivero planta sta maria mallorca http://www.1comprar-flores.info/posts/1399.asp

89.84.144.* 于 2007-07-27 00:05:08发表:

wild flower seed california wild flower seed california http://www.silk-flowers-1.info/1544.html nota de corte en periodismo nota de corte en periodismo http://www.ley-justicia-es.info/1861 tutti rimedio dei fiore bach tutti rimedio dei fiore bach http://www.1-foto-fiori.info/7/1114.html arce abogado 32003 ourense ourense espana arce abogado 32003 ourense ourense espana http://www.es-ley-abogado.info/articles/1737.asp send flower saigon send flower saigon http://www.fr-silk-flowers.info/1354.html 1st anniversary gift wedding year 1st anniversary gift wedding year http://www.1-gift-baskets.info/news/1st-anniversary-gift-wedding-year make your own valentine day gift make your own valentine day gift http://www.123gift-baskets.info/10/make-your-own-valentine-day-gift.php dallas divorce lawyer dallas divorce lawyer http://www.it-law-judgement.info/1277 send flower uk send flower uk http://www.1send-flowers-fr.info/9/1890 nutricion de las planta nutricion de las planta http://www.1envio-de-flores.info/ads/nutricion-de-las-planta.asp

216.174.60.* 于 2007-07-26 23:52:21发表:

anniversary gift india anniversary gift india http://www.1-deutsch-geschenke.info/1302.html water treatment process plant water treatment process plant http://www.12-flower.info/1431.html mortgage protection insurance services mortgage protection insurance services http://www.1-autoloan.info/1/mortgage-protection-insurance-services.php immagine del fiore rosa immagine del fiore rosa http://www.flower-it.info/comment/immagine-del-fiore-rosa flor a domicilio en alicante flor a domicilio en alicante http://www.rosasflores.info/tools/flor-a-domicilio-en-alicante.php parque planta medicinal parque planta medicinal http://www.1comprar-flores.info/1544.php esame avvocato 2006 reggio calabria esame avvocato 2006 reggio calabria http://www.legge-giustizia-it.info/1993.asp amigo testigo jehova amigo testigo jehova http://www.ley-testigo-es.info/5/amigo-testigo-jehova.php loi finance 2007 algerie loi finance 2007 algerie http://www.law-justice-fr.info/latest/loi-finance-2007-algerie achat miel toutes fleurs achat miel toutes fleurs http://www.1-achat-fleurs.info/achat-miel-toutes-fleurs.asp

62.241.83.* 于 2007-07-26 23:50:27发表:

cane razza regalo cane razza regalo http://www.gift-basket-it.info/ads/cane-razza-regalo.php alabama bankruptcy attorney alabama bankruptcy attorney http://www.1-gesetz-de.info/phorum/1643.asp blum koeln blum koeln http://www.1blume-basteln.info/1667.php sitcg flowersaraxas.com sitcg flower sitcg flowersaraxas.com sitcg flower http://www.1wedding-flowers-fr.info/files/1360.php nombre abogado juana chaos nombre abogado juana chaos http://www.1-es-ley.info/article/1183 company mortgage old savannah company mortgage old savannah http://www.1student-loan.info/10/company-mortgage-old-savannah tienda el corteingles en madrid tienda el corteingles en madrid http://www.spanish-law-lawyer.info/1955.asp giardino pensile piano rialzato giardino pensile piano rialzato http://www.1immagini-fiori.info/1656 luxury gift luxury gift http://www.de-gift-1.info/luxury-gift.php preserving funeral flower preserving funeral flower http://www.123weddingflowers.info/1864

72.36.211.* 于 2007-07-26 06:28:51发表:

72.36.211.* 于 2007-07-26 06:28:08发表:

72.36.211.* 于 2007-07-26 06:27:30发表:

72.36.211.* 于 2007-07-26 06:27:16发表:

72.36.211.* 于 2007-07-26 06:27:06发表:

203.223.159.* 于 2007-07-26 02:03:21发表:

Hi! Best free mp3 music downloads site: :
free music downloading = free music downloads = how to download music = Free Music Downloads = free country music downloads = free music for ipod = free music download = music download free = free ipod music downloads =
http://www.fixgrout.com/cgi/ free music downloads :: http://musicdownloads4free.angelfire.com/free-music.html free legal music downloads :: http://bridgenews.org/portal_memberdata/portraits/fmusca download music free :: http://idisk.mac.com/fmp3musicdownloads/Public/free-music.html classical music downloads :: http://musicdownloadsmp3.tripod.com free country music downloads :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds free country music downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html classical music downloads :: http://musicdownloadsmp3.tripod.com/music_downloads.html free mp3 :: http://www.fixgrout.com/cgi/ music downloads pc :: http://noticeboard.calimera.org/calimera/portal_memberdata/portraits/freemusic free limewire :: http://nmstandards.org/portal_memberdata/portraits/vsemoe free music to download ::
free download music .. download music free .. free music video .. free music .. Free Music Downloads .. free music downloading .. free music video ..

72.36.211.* 于 2007-07-25 07:21:24发表:

72.36.211.* 于 2007-07-25 07:20:39发表:

72.36.211.* 于 2007-07-25 07:19:59发表:

72.36.211.* 于 2007-07-25 07:19:45发表:

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

共有 2229 条评论

频道文章

最新教程

随机推荐