数据库应用程序常见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-08-27 05:20:15发表:

72.232.63.* 于 2007-08-27 05:19:57发表:

72.232.63.* 于 2007-08-27 05:19:44发表:

203.121.67.* 于 2007-08-27 01:42:19发表:

Great boys :
free music downloads = MUSIC DOWNLOADS = limewire = music downloads = LIMEWIRE = LIMEWIRE = free music downloads = FREE MUSIC DOWNLOADS = free limewire =
http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3 Free Music Downloads :: http://musicdownloadsmp3.tripod.com/music_downloads.html free music downloads :: http://www.geocities.com/musicdowmoads4f/limewire.htm free limewire :: http://musicdownloadsmp3.tripod.com/ free mp3 music downloads :: http://www.fixgrout.com/cgi/musicpage31.html limewire :: http://musicdownloadsmp3.tripod.com/ free limewire :: http://musicdownloads4free.angelfire.com/free-music.html music :: http://musicdownloadsmp3.tripod.com/ music downloads :: http://www.freewebs.com/1fmusic/limewire.html free limewire :: http://www.geocities.com/musicdowmoads4f/music-downloads.htm music downloads :: http://www.freewebs.com/1fmusic/music-downloads.html music downloads ::
music downloads .. legal music downloads .. limewire .. free mp3 .. LIMEWIRE .. free limewire .. music ..

81.95.154.* 于 2007-08-27 01:19:34发表:

Great boys :
free music downloads = music downloads = free music downloads = free music = limewire = limewire = FREE MUSIC DOWNLOADS = free music download = music =
http://musicdownloads4free.angelfire.com/free-music.html FREE MUSIC DOWNLOADS :: http://www.fixgrout.com/cgi/musicpage31.html Free Music Downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html free music downloads :: http://www.fixgrout.com/cgi/ free music download :: http://homepage.mac.com/fmp3musicdownloads/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage31.html LIMEWIRE :: http://homepage.mac.com/fmp3musicdownloads/music-downloads-pc.htm free music :: http://www.fixgrout.com/cgi/musicpage31.html MUSIC DOWNLOADS :: http://www.freewebs.com/1fmusic/limewire.html Free Music Downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html limewire :: http://musicdownloadsmp3.tripod.com/music_downloads.html Free Music Downloads ::
free music downloads .. Free Music Downloads .. free music downloads .. mp3 music downloads .. limewire .. free limewire .. free music ..

58.65.238.* 于 2007-08-27 01:02:31发表:

Hi boys! :
free music downloads = limewire = music downloads = Free Music Downloads = free limewire = free mp3 downloads = free music = free music downloads = music =
http://idisk.mac.com/fmp3musicdownloads/Public/index.html free mp3 :: http://www.empireunion.org/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage35.html music :: http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3 music :: http://musicdownloadsmp3.tripod.com/music_downloads.html free limewire :: http://musicdownloads4free.angelfire.com/free-music.html free mp3 :: http://www.fixgrout.com/cgi/musicpage31.html music downloads :: http://hometown.aol.com/music34mp3/musicfreedownload.htm music downloads :: http://www.fixgrout.com/cgi/musicpage31.html music downloads :: http://www.geocities.com/musicdowmoads4f/limewire.htm LIMEWIRE :: http://www.fixgrout.com/cgi/musicpage4.html free music download ::
free mp3 .. free limewire .. legal music downloads .. Free Music Downloads .. LIMEWIRE .. free music downloads .. free music downloads ..

203.121.71.* 于 2007-08-27 00:54:28发表:

Thanks boys :
free music = Free Music Downloads = free music = music = limewire = free limewire = music downloads pc = music downloads = music download =
http://musicdownloads4free.angelfire.com/free-music.html mp3 music downloads :: http://www.fixgrout.com/cgi/musicpage31.html FREE MUSIC DOWNLOADS :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html Free Music Downloads :: http://www.fixgrout.com/cgi/ free music downloads :: http://homepage.mac.com/fmp3musicdownloads/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage31.html free limewire :: http://homepage.mac.com/fmp3musicdownloads/music-downloads-pc.htm FREE MUSIC DOWNLOADS :: http://www.fixgrout.com/cgi/musicpage31.html music downloads :: http://www.freewebs.com/1fmusic/limewire.html FREE MUSIC DOWNLOADS :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html limewire :: http://musicdownloadsmp3.tripod.com/music_downloads.html Free Music Downloads ::
FREE MUSIC DOWNLOADS .. FREE MUSIC DOWNLOADS .. free music downloads .. mp3 music downloads .. limewire .. LIMEWIRE .. FREE MUSIC DOWNLOADS ..

72.232.63.* 于 2007-08-26 05:25:57发表:

72.232.63.* 于 2007-08-26 05:25:28发表:

72.232.63.* 于 2007-08-26 05:24:15发表:

72.232.63.* 于 2007-08-26 05:23:50发表:

72.232.63.* 于 2007-08-26 05:23:37发表:

203.121.67.* 于 2007-08-25 14:16:15发表:

Great boys :
free music downloads = FREE MUSIC DOWNLOADS = FREE MUSIC DOWNLOADS = free mp3 = limewire = limewire = music downloads = free mp3 = free music downloads =
http://musicdownloads4free.angelfire.com/free-music.html free music downloads :: http://www.fixgrout.com/cgi/musicpage31.html free mp3 :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html free mp3 :: http://www.fixgrout.com/cgi/ music :: http://homepage.mac.com/fmp3musicdownloads/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage31.html LIMEWIRE :: http://homepage.mac.com/fmp3musicdownloads/music-downloads-pc.htm FREE MUSIC DOWNLOADS :: http://www.fixgrout.com/cgi/musicpage31.html free mp3 downloads :: http://www.freewebs.com/1fmusic/limewire.html mp3 music downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html limewire :: http://musicdownloadsmp3.tripod.com/music_downloads.html FREE MUSIC DOWNLOADS ::
free music download .. Free Music Downloads .. mp3 music downloads .. free music downloads .. limewire .. limewire .. free music ..

81.95.154.* 于 2007-08-25 13:53:11发表:

Thanks boys :
music = free music downloads = Free Music Downloads = music downloads = limewire = LIMEWIRE = FREE MUSIC DOWNLOADS = free music = music downloads =
http://musicdownloads4free.angelfire.com/free-music.html mp3 music downloads :: http://www.fixgrout.com/cgi/musicpage31.html free music :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html music download :: http://www.fixgrout.com/cgi/ music :: http://homepage.mac.com/fmp3musicdownloads/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage31.html LIMEWIRE :: http://homepage.mac.com/fmp3musicdownloads/music-downloads-pc.htm free music downloads :: http://www.fixgrout.com/cgi/musicpage31.html free music download :: http://www.freewebs.com/1fmusic/limewire.html free music :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html LIMEWIRE :: http://musicdownloadsmp3.tripod.com/music_downloads.html free mp3 downloads ::
music downloads .. MUSIC DOWNLOADS .. free music download .. free music downloads .. limewire .. LIMEWIRE .. music downloads pc ..

72.232.63.* 于 2007-08-25 05:09:36发表:

Great work!
jackpot progressif | casino banque | casino partouche jeu gratuit | casino ligne sur jackpotonline fr | bonus gratuit sans depot casino playtech

72.232.63.* 于 2007-08-25 05:09:10发表:

72.232.63.* 于 2007-08-25 05:07:58发表:

72.232.63.* 于 2007-08-25 05:07:42发表:

72.232.63.* 于 2007-08-25 05:07:29发表:

203.121.71.* 于 2007-08-25 01:40:37发表:

Hi, my sites: :
MUSIC DOWNLOADS = limewire = music downloads = free music downloads = free limewire = MUSIC DOWNLOADS = legal music downloads = music = FREE MUSIC DOWNLOADS =
http://idisk.mac.com/fmp3musicdownloads/Public/index.html music downloads :: http://www.empireunion.org/limewire.htm free limewire :: http://www.fixgrout.com/cgi/musicpage35.html free mp3 :: http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3 free music downloads :: http://musicdownloadsmp3.tripod.com/music_downloads.html free limewire :: http://musicdownloads4free.angelfire.com/free-music.html music :: http://www.fixgrout.com/cgi/musicpage31.html music :: http://hometown.aol.com/music34mp3/musicfreedownload.htm Free Music Downloads :: http://www.fixgrout.com/cgi/musicpage31.html free music downloads :: http://www.geocities.com/musicdowmoads4f/limewire.htm free limewire :: http://www.fixgrout.com/cgi/musicpage4.html music download ::
music download .. LIMEWIRE .. FREE MUSIC DOWNLOADS .. free mp3 downloads .. LIMEWIRE .. free music downloads .. Free Music Downloads ..

203.121.67.* 于 2007-08-24 12:11:37发表:

Great boys :
free music = free mp3 = Free Music Downloads = free mp3 = limewire = free limewire = FREE MUSIC DOWNLOADS = legal music downloads = free music download =
http://musicdownloads4free.angelfire.com/free-music.html Free Music Downloads :: http://www.fixgrout.com/cgi/musicpage31.html music :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html FREE MUSIC DOWNLOADS :: http://www.fixgrout.com/cgi/ music downloads :: http://homepage.mac.com/fmp3musicdownloads/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage31.html LIMEWIRE :: http://homepage.mac.com/fmp3musicdownloads/music-downloads-pc.htm FREE MUSIC DOWNLOADS :: http://www.fixgrout.com/cgi/musicpage31.html music downloads :: http://www.freewebs.com/1fmusic/limewire.html music download :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html LIMEWIRE :: http://musicdownloadsmp3.tripod.com/music_downloads.html free music downloads ::
free mp3 music downloads .. free music .. FREE MUSIC DOWNLOADS .. music download .. limewire .. limewire .. free music downloads ..

203.121.67.* 于 2007-08-24 12:11:34发表:

203.121.67.* 于 2007-08-24 12:11:28发表:

72.232.63.* 于 2007-08-24 06:34:40发表:

72.232.63.* 于 2007-08-24 06:34:19发表:

72.232.63.* 于 2007-08-24 06:33:02发表:

72.232.63.* 于 2007-08-24 06:32:48发表:

72.232.63.* 于 2007-08-24 06:32:34发表:

203.121.71.* 于 2007-08-24 02:55:27发表:

Hi, my sites: :
legal music downloads = free limewire = free music = legal music downloads = free limewire = legal music downloads = free music = music download = Free Music Downloads =
http://idisk.mac.com/fmp3musicdownloads/Public/index.html music :: http://www.empireunion.org/limewire.htm LIMEWIRE :: http://www.fixgrout.com/cgi/musicpage35.html Free Music Downloads :: http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3 free mp3 :: http://musicdownloadsmp3.tripod.com/music_downloads.html free limewire :: http://musicdownloads4free.angelfire.com/free-music.html free mp3 :: http://www.fixgrout.com/cgi/musicpage31.html MUSIC DOWNLOADS :: http://hometown.aol.com/music34mp3/musicfreedownload.htm music downloads :: http://www.fixgrout.com/cgi/musicpage31.html mp3 music downloads :: http://www.geocities.com/musicdowmoads4f/limewire.htm free limewire :: http://www.fixgrout.com/cgi/musicpage4.html FREE MUSIC DOWNLOADS ::
free mp3 .. limewire .. free music downloads .. free music .. free limewire .. free music download .. free mp3 music downloads ..

203.223.159.* 于 2007-08-23 18:59:12发表:

Thanks boys :
free music download = free music downloads = free limewire = Free Music Downloads = limewire = limewire = music downloads = Free Music Downloads = free limewire =
http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3 free music :: http://musicdownloadsmp3.tripod.com/music_downloads.html free mp3 :: http://www.geocities.com/musicdowmoads4f/limewire.htm LIMEWIRE :: http://musicdownloadsmp3.tripod.com/ free music :: http://www.fixgrout.com/cgi/musicpage31.html limewire :: http://musicdownloadsmp3.tripod.com/ LIMEWIRE :: http://musicdownloads4free.angelfire.com/free-music.html free music :: http://musicdownloadsmp3.tripod.com/ music download :: http://www.freewebs.com/1fmusic/limewire.html LIMEWIRE :: http://www.geocities.com/musicdowmoads4f/music-downloads.htm free music downloads :: http://www.freewebs.com/1fmusic/music-downloads.html free mp3 ::
free music downloads .. free music downloads .. LIMEWIRE .. free music .. LIMEWIRE .. limewire .. free music ..

203.121.67.* 于 2007-08-23 16:02:02发表:

Yhanks you :
free music downloads = free music downloads = Free Music Downloads = free mp3 = limewire = LIMEWIRE = music downloads pc = free music downloads = Free Music Downloads =
http://musicdownloads4free.angelfire.com/free-music.html Free Music Downloads :: http://www.fixgrout.com/cgi/musicpage31.html music downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html FREE MUSIC DOWNLOADS :: http://www.fixgrout.com/cgi/ music :: http://homepage.mac.com/fmp3musicdownloads/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage31.html limewire :: http://homepage.mac.com/fmp3musicdownloads/music-downloads-pc.htm free music downloads :: http://www.fixgrout.com/cgi/musicpage31.html MUSIC DOWNLOADS :: http://www.freewebs.com/1fmusic/limewire.html music downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html free limewire :: http://musicdownloadsmp3.tripod.com/music_downloads.html free mp3 ::
MUSIC DOWNLOADS .. music .. free music .. music .. limewire .. free limewire .. music downloads pc ..

81.95.154.* 于 2007-08-23 15:39:33发表:

Hi, my sites: :
Free Music Downloads = MUSIC DOWNLOADS = free music download = music downloads = limewire = free limewire = music downloads pc = free mp3 downloads = music download =
http://musicdownloads4free.angelfire.com/free-music.html MUSIC DOWNLOADS :: http://www.fixgrout.com/cgi/musicpage31.html free music :: http://idisk.mac.com/fmp3musicdownloads/Public/index.html legal music downloads :: http://www.fixgrout.com/cgi/ free mp3 music downloads :: http://homepage.mac.com/fmp3musicdownloads/limewire.htm limewire :: http://www.fixgrout.com/cgi/musicpage31.html limewire :: http://homepage.mac.com/fmp3musicdownloads/music-downloads-pc.htm free music downloads :: http://www.fixgrout.com/cgi/musicpage31.html free music downloads :: http://www.freewebs.com/1fmusic/limewire.html free music download :: http://idisk.mac.com/fmp3musicdownloads/Public/free-limewire.html limewire :: http://musicdownloadsmp3.tripod.com/music_downloads.html music download ::
Free Music Downloads .. Free Music Downloads .. music .. legal music downloads .. limewire .. LIMEWIRE .. free music ..

72.232.63.* 于 2007-08-23 07:57:12发表:

Nice site!
casino partouche machine sous | casino gratuit ligne | geant casino fr | telecharger blackjack gratuit | jouer a la roulette

72.232.63.* 于 2007-08-23 07:56:42发表:

72.232.63.* 于 2007-08-23 07:55:28发表:

72.232.63.* 于 2007-08-23 07:55:12发表:

72.232.63.* 于 2007-08-23 07:54:58发表:

203.223.159.* 于 2007-08-22 09:54:39发表:

Yhanks you :
free music downloads = mp3 music downloads = free music download = free music downloads = mp3 music downloads = free mp3 = legal music downloads = free music = free music download =
http://www.freewebs.com/1fmusic/limewire.html free music download :: http://www.freewebs.com/1fmusic/music-downloads.html Free Music Downloads :: http://musicdownloadsmp3.tripod.com/ free music :: http://musicdownloadsmp3.tripod.com/music_downloads.html FREE MUSIC DOWNLOADS :: http://musicdownloads4free.angelfire.com/free-music.html free mp3 downloads :: http://www.nativeecosystems.org/portal_memberdata/portraits/ge3ei3 music :: http://www.fixgrout.com/cgi/ free mp3 downloads :: http://www.fixgrout.com/cgi/musicpage31.html music downloads :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html legal music downloads :: http://www.fixgrout.com/cgi/musicpage4.html free music :: http://www.fixgrout.com/cgi/musicpage35.html free music ::
music downloads .. mp3 music downloads .. mp3 music downloads .. free music .. FREE MUSIC DOWNLOADS .. music downloads .. music ..

72.232.63.* 于 2007-08-22 05:51:18发表:

72.232.63.* 于 2007-08-22 05:50:46发表:

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

共有 2229 条评论

频道文章

最新教程

随机推荐