还是有很多的不同,转贴如下:http://www.bristle_程序开发编程(Oracle 和 MIcrosoft SQL 的不同)

开发技术指南» 文章正文

引言：还是有很多的不同,转贴如下:http://www.bristle

摘要：jdbc的学习笔记 (四) thinkersky[yanghuangming@rongji.com] 昨天晚上，又梦到了我那可怜的堂姐，那个我可亲可敬又可恨的姐姐。不知道为什么，直到现在仍觉得那只是一个梦。如果真是梦，希望姐能够在那梦里永远开心快乐。听说，人到了天堂就再也没有痛苦了。我相信。 …… 恩，接昨天的东东。二、通过preparedstatement对象访问数据库前面，我们讨论了用连接对象c......

·数学建模实录（3） »显示摘要«

摘要：1。函数名：crtpower(a) 作用：计算矩阵中的向量权优点：直接由原始数据可以换算出矩阵中的向量权源代码： function rstpower=crtpower(a)%**********************************************************% this is help information about power() function.% find the min number in th......

Oracle 和 MIcrosoft SQL 的不同

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

table of contents: 【相关文章:XML 属性顺序】

【扩展阅读:CSDN 一路走好之Wiki与Blog】

oracle tips 【扩展信息:网络实现技术--IBM专有网络SNA／A】

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

details of tips:

sql tips

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

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

materialized view

last updated: 1/7/2002

applies to: oracle 8+

oracle 8i introduced a new feature called a "materialized view". you define it just like any other view, except that you add the keyword materialized:

create materialized view view_name

a materialized view is like a combination of a table and a view. like a view, it is defined as a logical view into the data of one or more tables. when you update the tables, subsequent queries of the view see the updated data. however, like a table, its data is stored in the database. also, like a table, it is faster if you define indexes for it.

a regular view is stored as a mapping of data from tables. when you modify the data in the tables, the view is completely ignored. when you access the view, it joins the data currently in the tables, and returns the data you requested. a materialized view is stored as such a mapping along with a copy of the actual data from the tables. when you modify the data in the tables, the view´s copy of the data is also updated. when you access the view, the data is drawn directly from the copy.

thus a materialized view makes table updates a little slower, but makes view queries much faster. it also consumes additional space in the database.

... 下一页

·struts中的异常处理机制 »显示摘要«

摘要：struts中的异常处理机制 struts中的异常处理，必须利用struts内置的机制（只针对action的execute）和标准的servlet机制相结合，才能完美的实现。 1. 首先通过在配置文件中定义全局异常处理或者特定于action的异常处理句柄 2. 然后在process中执行action的excute时遇到异常就读取其异常处理配置，并生成相应的exceptionconfig对象。若exceptionconfig为null......

» 本期热门文章：

· 热门栏目：

» 相关精选文章

» 其它相关：