红联Linux门户
Linux帮助
当前位置: 红联Linux门户 > Linux数据库应用

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

发布时间:2006-11-05 00:45:47来源:红联作者:flycocoon
　　许多软件公司都理解开发不依赖于特定数据库类型(例如，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之间的区别
文章评论

共有 2229 条评论

  1. 72.232.63.* 于 2007-08-22 05:49:38发表:

    Great work!
    bet on sports online | sportsbook odd | rugby world cup 2007 | racing betting | football league bet | betting online | free nfl football picks | free bet horse racing | sports book betting | nfl spreads

  2. 72.232.63.* 于 2007-08-22 05:49:23发表:

    Good design!
    nfl playoffs | greyhound handicapping racing | nascar odds | bet on basketball | sport betting online | nba odds to win | handicapping nba | wnba betting | baseball coaching | internet betting

  3. 72.232.63.* 于 2007-08-22 05:49:10发表:

    Well done!
    on line sports book | golf betting tips | mlb world series 2007 | bet 365 | nfl football bet | bet on major league baseball | canadian football spreads | baseball betting odds | england cricket bet | bet fair

  4. 72.232.63.* 于 2007-08-21 06:35:00发表:

    Nice site!
    free phone downloads | free real music ringtones | free sanyo ringtones | wav ringtones | free midi ringtones | suonerie per cellulari | free ringtones for tracfones | free motorola ringtones | ringtone free | ctu ringtone

  5. 72.232.63.* 于 2007-08-21 06:34:03发表:

    Nice site!
    ringtones free | real music ringtones | cingular wireless ringtones | free nextel ringtones | cep telefonuna melodi | motorola mp3 | mp3 to ringtone | real tone ringtones | us cellular ringtones | suncom ringtones

  6. 72.232.63.* 于 2007-08-21 06:33:32发表:

    Good design!
    lg free ringtones | ringtones para celular | ringtone ctu | ringtones download | nokia free ringtones | free downloadable ringtones | nelly furtado ringtones | boost ringtones | caller ringtones | online ringtone converter

  7. 72.232.63.* 于 2007-08-21 06:33:18发表:

    Nice site!
    free ringtones us cellular | free cellular one ringtones | free sprint ringtones | free alltel ringtones | cellular south | mp3 klingelton | mobil hry | sonnerie 24 | ringtones gratis siemens | dzwonki na siemensa

  8. 72.232.63.* 于 2007-08-21 06:33:05发表:

    Well done!
    melodie zdarma | motorola ring tones | composer ringtones | free cellphone ringtones | dzwonki telefon | tmobile ringtones | ringtones motorola | free country music ringtones | christian music ringtones | verizon free ringtones

  9. 72.36.211.* 于 2007-08-20 05:18:55发表:

    Well done!
    wwe ringtones | funny ringtones free | sprint ringtones | free monophonic ringtones | christian ringtones | 24 ctu ringtones | free sprint ringtones | free ringtones for u s cellular | free anime | sonnerie portable

  10. 72.36.211.* 于 2007-08-20 05:18:29发表:

    Nice site!
    ringtones verizon | free ringtone download | klingelton download | ringtones mp3 | cellular south | ringtones free | free sms ringtones | shakira ringtones | download free nokia ringtone | free wwe ringtones

  11. 72.36.211.* 于 2007-08-20 05:17:21发表:

    Thank you!
    free real ringtones | free mp3 download | free cricket ringtones | ingyen mp3 | ringtones for nokia | ctu ringtone mp3 | us cellular free ringtones | free mp3 ringtones | tracfone ringtones | boost ringtones

  12. 72.36.211.* 于 2007-08-20 05:16:54发表:

    Nice site!
    24 klingelton | melodie mobil | ringtone midi | cingular ringtones | toques telemoveis | download ringtones free | free motorola ringtones | 24 ringtones | free us cellular ring tones | tonos para celular

  13. 72.36.211.* 于 2007-08-20 05:16:46发表:

    Well done!
    christina aguilera ringtones | gratis mobilspel | cingular wireless ringtones | free suncom ringtones | free ringtones for verizon | free ringtones alltel | toques polifonicos | free blackberry ringtones | free ringtones for alltel | lg free ringtones

  14. 72.36.211.* 于 2007-08-19 07:35:48发表:

    Nice site!
    free polyphonic ringtones | suonerie polifoniche | melodias gratis para movil | ingyen mp3 | darmowe dzwonki | 24 klingelton | free mp3 ringtones | cheap ringtones | akon ringtones | us cellular free ringtones

  15. 72.36.211.* 于 2007-08-19 07:35:19发表:

    Nice site!
    ringtones for motorola | downloaden ringtones | ringtones for nextel | u s cellular ringtones | free cellphone ringtones | cellular south ringtones | free ringtones for suncom | free mp3 ringtones download | free real ringtones | toques telemoveis

  16. 72.36.211.* 于 2007-08-19 07:34:16发表:

    Nice site!
    free cingular ringtones | free ringtone converter | us cellular ring tones | sms ringtones | sanyo ringtones | ring tones | real music ringtones | ringtones verizon | ringtone jukebox | simpsons ringtone

  17. 72.36.211.* 于 2007-08-19 07:33:59发表:

    Nice site!
    free lg ringtones | motorola free ringtones | beyonce ringtones | hindi ringtone | free music ringtones | dzwonki na siemensa | logo sonnerie | ringtones composer | ringtones for alltel | free ringtones for sprint

  18. 72.36.211.* 于 2007-08-19 07:33:51发表:

    Nice site!
    anime ringtones | real klingelton | free country ringtones | ringtones for tracfone | mobil telefon | cep telefonuna melodi | free real tone ringtones | lg ringtones | free sprint pcs ringtones | real ringtones

  19. 203.223.159.* 于 2007-08-18 15:27:12发表:

    Hi, my sites: :
    free mp3 = download free music = limewire music downloads = free music to download = how to download music = limewire music downloads = music downloads pc = FREE MUSIC DOWNLOADS = music downloads pc =
    http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html free music video :: http://mywebpage.netscape.com/music5site/download-music.htm free mp3 :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds FREE MUSIC DOWNLOADS :: http://musicdownloads4free.angelfire.com/free-music.html free music :: http://www.fixgrout.com/cgi/musicpage35.html free limewire :: http://www.fixgrout.com/cgi/musicpage31.html free music :: http://mywebpage.netscape.com/music5site/download-music.htm free mp3 downloads :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free music :: http://mywebpage.netscape.com/free5mp3/mp3music.html free mp3 downloads ::
    free mp3 .. FREE MUSIC DOWNLOADS .. music downloads pc .. free mp3 music downloads .. music download free .. download free music .. free ipod music downloads sites ..

  20. 203.121.67.* 于 2007-08-18 11:47:34发表:

    Thanks boys :
    free mp3 = free music download sites = free music downloads = classical music downloads = music downloads pc = download music for free = download music video = limewire = music downloads pc =
    http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html Free Music Downloads :: http://mywebpage.netscape.com/music5site/download-music.htm free country music downloads :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds free music :: http://musicdownloads4free.angelfire.com/free-music.html free music :: http://www.fixgrout.com/cgi/musicpage35.html music download free :: http://www.fixgrout.com/cgi/musicpage31.html free music :: http://mywebpage.netscape.com/music5site/download-music.htm limewire :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free music :: http://mywebpage.netscape.com/free5mp3/mp3music.html download music for free ::
    free mp3 .. free ipod music downloads sites .. free music download sites .. music download free .. classical music downloads .. free limewire .. Free Music Downloads ..

  21. 72.36.211.* 于 2007-08-18 06:26:35发表:

    Good design!
    klingelton download | ingyen sms | free ringtones sprint | ringtone ctu | nokia free downloads | free suncom ringtones | free country ringtones | free ringtones for nextel | alltel ringtones | tmobile free ringtones

  22. 72.36.211.* 于 2007-08-18 06:26:09发表:

    Thank you!
    hindi ringtone | ringtones motorola | cingular free ringtones | dzwonki true tone | us cellular free ringtones | anime ringtones | tapety zdarma | toques polifonicos | cricket free ringtones | verizon ring tones

  23. 72.36.211.* 于 2007-08-18 06:25:00发表:

    Well done!
    free cingular ringtones | ringtone free | samsung free ringtones | free ringtones for sprint | sonidos reales gratis | free mobile ringtones | free alltel ringtones | free mp3 ringtone download | sonnerie 24 | ringtones mp3

  24. 72.36.211.* 于 2007-08-18 06:24:41发表:

    Good design!
    ringtones free | mosquito ringtone | motorola ringtones | motorola razr v3 ringtones | monophonic ringtones | 50 cent ringtones | ctu ringtone verizon | caller ringtones | free music ringtones | free cingular real ring tone

  25. 72.36.211.* 于 2007-08-18 06:24:30发表:

    Great work!
    ringtones para celular | sonnerie mp3 | ringtones lg | ringtones composer | 24 ctu ringtones | samsung ringtones | centennial wireless | sonneries mobile | free polyphonic | mobiele ringtones

  26. 203.121.67.* 于 2007-08-17 13:29:04发表:

    Yhanks you :
    free mp3 = free download music = free music ipods = free legal music downloads = music download free = free music = free ipod music downloads sites = FREE MUSIC DOWNLOADS = music downloads pc =
    http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html music downloads :: http://mywebpage.netscape.com/music5site/download-music.htm music downloads :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds free mp3 :: http://musicdownloads4free.angelfire.com/free-music.html mp3 downloads :: http://www.fixgrout.com/cgi/musicpage35.html download music free :: http://www.fixgrout.com/cgi/musicpage31.html free ipod music downloads sites :: http://mywebpage.netscape.com/music5site/download-music.htm free country music downloads :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html Free Music Downloads :: http://mywebpage.netscape.com/free5mp3/mp3music.html free download music ::
    free mp3 .. free download music .. free music .. limewire music downloads .. Free Music Downloads .. download music video .. free music ..

  27. 72.36.211.* 于 2007-08-17 06:29:15发表:

    Thank you!
    free music ringtones | free ringtones for t mobile | sonnerie mp3 | 24 klingelton | hudba zdarma | ringtone downloads | free cellphone ringtones | free mp3 ringtone downloads | mobiele ringtones | lg ringtones

  28. 72.36.211.* 于 2007-08-17 06:28:48发表:

    Well done!
    cingular ringtones | motorola ringtones | free ringtones for nokia | free phone ringtones | mp3 ringtone download | dzwonki do nokii | midi ringtones | lg free ringtones | toques samsung | sonneries gratuites

  29. 72.36.211.* 于 2007-08-17 06:27:41发表:

    Nice site!
    free cingular real ring tone | free ringtone creator | free christian ringtones | dzwonki telefon | free cellular ringtones | alltel ringtones | free mp3 tones | arabic ringtones | real music ringtones | verizon ctu ringtone

  30. 72.36.211.* 于 2007-08-17 06:27:20发表:

    Great work!
    ringtones wav | free cellular south ringtones | logo sonnerie | toques reais | logos para movil | free cell phone ring tones | ringtone composer | mobiel ringtone | polyphonic ringtones | free sms ringtones

  31. 72.36.211.* 于 2007-08-17 06:27:08发表:

    Well done!
    ingyen mp3 | funny ringtones free | ringtones verizon | online ringtone converter | ringtones mp3 | free real ringtones | nokia free ringtones | ringtones for alltel | free real ringtones for cingular | star wars ringtones

  32. 203.121.67.* 于 2007-08-16 15:47:05发表:

    Thanks boys :
    free mp3 = free legal music downloads = music = free ipod music downloads sites = music download = limewire = free mp3 music downloads = free music downloading = music downloads pc =
    http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html FREE MUSIC DOWNLOADS :: http://mywebpage.netscape.com/music5site/download-music.htm music downloads :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds free music ipods :: http://musicdownloads4free.angelfire.com/free-music.html music download :: http://www.fixgrout.com/cgi/musicpage35.html free music video :: http://www.fixgrout.com/cgi/musicpage31.html download music video :: http://mywebpage.netscape.com/music5site/download-music.htm free music download :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html FREE MUSIC DOWNLOADS :: http://mywebpage.netscape.com/free5mp3/mp3music.html download music for free ::
    free mp3 .. music downloads .. limewire .. how to download music .. free mp3 music downloads .. music .. limewire music downloads ..

  33. 203.121.67.* 于 2007-08-16 14:49:48发表:

    Great boys :
    free mp3 = music downloads pc = free country music downloads = free ipod music downloads = music = music downloads = limewire = free limewire = music downloads pc =
    http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html free mp3 music downloads :: http://mywebpage.netscape.com/music5site/download-music.htm free music download sites :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds free limewire :: http://musicdownloads4free.angelfire.com/free-music.html music downloads pc :: http://www.fixgrout.com/cgi/musicpage35.html limewire music downloads :: http://www.fixgrout.com/cgi/musicpage31.html free ipod music downloads sites :: http://mywebpage.netscape.com/music5site/download-music.htm free mp3 music downloads :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free music :: http://mywebpage.netscape.com/free5mp3/mp3music.html limewire ::
    free mp3 .. free legal music downloads .. limewire .. download music for free .. music downloads .. free mp3 music downloads .. free music downloading ..

  34. 72.36.211.* 于 2007-08-16 06:16:48发表:

    Well done!
    christian music ringtones | gospel ringtones | melodie zdarma | free ringtones mp3 | free ringtones for cingular | midi ringtones | 24 ringtone free | razr v3 ringtones | ringtones for alltel | centennial wireless ringtones

  35. 72.36.211.* 于 2007-08-16 06:16:15发表:

    Thank you!
    download ringtones free | dzwonki na nokie | free ringtones for boost mobile | free ringtone download | sprint pcs ringtones | free cingular ringtones | ringtone jukebox | sonneries siemens | ringtones for suncom | free ringtones samsung

  36. 72.36.211.* 于 2007-08-16 06:15:09发表:

    Great work!
    dzwonki telefon | free cell phone ring tones | free sms ringtones | samsung ringtones | mp3 klingelton | free us cellular ringtones | tracfone ringtones | free wav ringtones | download free mp3 ringtones | mp3 to ringtone converter

  37. 72.36.211.* 于 2007-08-16 06:14:50发表:

    Good design!
    klingeltoene samsung | free cellular ringtones | razr ringtones | gwen stefani ringtones | ctu ringtone | free alltel ringtones | free anime | free verizon ringtones | nelly furtado ringtones | free nextel ringtone downloads

  38. 72.36.211.* 于 2007-08-16 06:14:39发表:

    Thank you!
    tmobile free ringtones | ringtones composer | rihanna ringtones | polifonik melodi | real tone ringtones | bedava melodi | motorola mp3 | sonnerie 24 | ringtones para celular | cellular south

  39. 203.223.159.* 于 2007-08-15 18:22:50发表:

    Great boys :
    free mp3 = music download = music download = music downloads pc = download music for free = free limewire = free mp3 music downloads = free music ipods = music downloads pc =
    http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html free music downloads :: http://mywebpage.netscape.com/music5site/download-music.htm free music :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds music download :: http://musicdownloads4free.angelfire.com/free-music.html free legal music downloads :: http://www.fixgrout.com/cgi/musicpage35.html limewire music downloads :: http://www.fixgrout.com/cgi/musicpage31.html how to download music :: http://mywebpage.netscape.com/music5site/download-music.htm limewire :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free mp3 downloads :: http://mywebpage.netscape.com/free5mp3/mp3music.html free music ::
    free mp3 .. how to download music .. classical music downloads .. free music .. music download .. music download .. limewire music downloads ..

  40. 203.121.67.* 于 2007-08-15 15:26:25发表:

    Great boys :
    free mp3 = free country music downloads = free mp3 = music download free = mp3 downloads = free music to download = free music for ipod = free mp3 music downloads = music downloads pc =
    http://www.fixgrout.com/cgi/musicpage15.html free mp3 :: http://www.fixgrout.com/cgi/musicpage47.html free limewire :: http://mywebpage.netscape.com/music5site/download-music.htm free music for ipod :: http://www.viktorschreckengost.org/portal_memberdata/portraits/bergds free ipod music downloads :: http://musicdownloads4free.angelfire.com/free-music.html free ipod music downloads :: http://www.fixgrout.com/cgi/musicpage35.html music downloads pc :: http://www.fixgrout.com/cgi/musicpage31.html free mp3 downloads :: http://mywebpage.netscape.com/music5site/download-music.htm limewire music downloads :: http://www.fixgrout.com/cgi/musicpage17.html music downloads pc :: http://idisk.mac.com/fmp3musicdownloads/Public/music.html free music downloads :: http://mywebpage.netscape.com/free5mp3/mp3music.html free mp3 downloads ::
    free mp3 .. music .. how to download music .. free mp3 .. free music for ipod .. mp3 downloads .. music download ..

  1. 首页上一页 2 3 4 5 6 下一页 尾页

频道文章

最新教程

随机推荐

关于我们 | 合作 | 联系我们

© linuxdiyf.com 红联Linux门户 版权所有