[收藏本方案]

Oracle 和 MIcrosoft SQL 的不同[1]

[入库：2005年8月18日] [更新：2007年3月24日]

本文简介：选择自 montaque 的 blog
首页 下页 尾页 [1] [2] [3] [4] [5] [6] [7] [8]

还是有很多的不同,转贴如下:http://www.bristle.com/tips/sql.htm#oracle%20tips

 

table of contents:

  1. oracle tips
    1. sql tips
      1. select * and more
      2. materialized view
    2. pl/sql tips
    3. sql navigator tips
    4. see also
  2. ms sql server tips
    1. sql tips
      1. dynamic sql in a stored procedure
    2. sql enterprise manager tips
      1. keyboard shortcuts
      2. sql generating sql
    3. see also
  3. differences between oracle and ms sql server
    1. concepts and terminology
    2. data types
    3. limits
    4. operators
    5. built-in functions
    6. differences in sql syntax
    7. differences in sql semantics
    8. differences in managing databases
    9. differences in managing database objects
    10. differences in managing users
    11. differences in integration with ms ado, rdo, etc.
    12. miscellaneous differences
    13. see also

details of tips:

  1. oracle tips

    1. sql tips

      this section contains tips on standard sql (structured query language) statements in oracle.

      1. select * and more

        last updated: 6/6/1999
        applies to:  oracle 7.3, 8 (and probably earlier versions)

        to select all columns of a table:

        	select * from table

        however, to select all real columns, plus a pseudo-column like "user":

        	select table.*, user from table

        the following does not work:

        	select *, user from table

        --fred

      2. materialized view

        last updated: 1/7/2002

首页 下页 尾页 [1] [2] [3] [4] [5] [6] [7] [8]
本文关键：Oracle 和 MIcrosoft SQL 的不同
　　相关方案
Google
 

本站最佳浏览方式为 分辨率 1024x768 IE 6.0（或更高版本的 IE浏览器）

go top