ITeye博客

博观而约取,厚积而薄发。

caohong286 · 共 81 篇文章

[置顶] 《Pro Oracle SQL》 翻译序 -- 读书心得

天行健,君子以自强不息! 作为一名和Oracle数据库打交道很多的Java Web开发人员,接触数据库久了,深感数据库知识的匮乏。我由此萌发了精研Oracle的动力。另一方面,Oracle的开发人员的待遇通常都要比Java的好得多。从最开始遇到问题就抱佛脚--去查《SQL Cookbook》,到《Oracle 9i&10g编程艺术》,切身体会最核心的东西还是数据库的语言SQL。SQL语言入门容易,但是要把它的功能发挥的淋漓尽致不结合特定的数据库环境是不可能的。掌握最先进的SQL语法,写出有杀伤力的SQL语句,几乎成了我的“心病”。 An ideal book is the key to on…

2011-11-12T22:35:29Z · 非技术 · 评论(1)

JavaBean学习三

32.4 Java Event Model Review A bean may communicate with other beans. The Java event delegation model provides the foundation for beans to send, receive, and handle events. Let us review the Java event model that was introduced in Chapter 16, “Event-Driven Programming.” The Java event model consist…

2012-09-26T22:57:50Z · 编程语言 · 评论(0)

JavaBean 学习二

32.3 Bean Properties Properties are discrete, named attributes of a Java bean that can affect its appearance or behavior. They are often data fields of a bean. For example, the JButton component has a property named text that represents the text to be displayed on the button. Private data fields ar…

2012-09-21T00:07:54Z · 编程语言 · 评论(0)

JavaBean 学习一

32.1 Introduction Every Java user interface class is a JavaBeans component. Understanding JavaBeans will help you to learn GUI components. In Chapter 16, “Event-Driven Programming,” you learned how to handle events fired from source components such as JButton, JTextField, JRadio- Button, and JCombo…

2012-09-19T00:09:23Z · 编程语言 · 评论(0)

NetBeans设置英文界面和字体大小

最近学习《Java.How.to.Program》 (ed2k://|file|Java.How.to.Program,.Paul.Deitel,.Harvey.Deitel,.9ed,.Prentice.Hall,.2012.pdf|25259544|4CE03C570B775C56BC135A2E487222D8|/) 中的Web Service一章,用的开发工具是NetBeans。在http://netbeans.org/下载(注意不是netbean.org,就少了个s,很肯跌)默认安装后,默认打开的却是中文界面。如图1: 与书中使用的英文描述不符,学习起来不方便。想把它设置回英文,搜…

2012-09-09T13:45:48Z · 开源软件 · 评论(0)

《Pro Oracle SQL》10.3 Recursive Subqueries

Recursive Subqueries 递归子查询 New to Oracle 11.2 is recursive subquery factoring (RSF for the remainder of this chapter). As you can probably guess, the ANSI name for this feature is recursive common table expression. Regardless of what you call it, Oracle has had a similar feature for a very long tim…

2012-07-06T00:30:37Z · 数据库 · 评论(0)

《Pro Oracle SQL》Chapter 10.2.5 Applying Subquery Factoring to PL/SQL

Applying Subquery Factoring to PL/SQL 在PL/SQL中运用子查询分解 Even PL/SQL can present golden opportunities for optimization using subquery factoring. Something that most of us have done at one time or another is to write a PL/SQL routine when we cannot figure out how to do what we want in a single SQL quer…

2012-07-04T23:19:45Z · 数据库 · 评论(0)

《Pro Oracle SQL》 10.2.4 Seizing Other Optimization Opportunities

10.2.4 Seizing Other Optimization Opportunities 掌握其他的优化机会 There are other opportunities where subquery factoring may be used to your advantage. If you are working on applications that were originally written several years ago, you may find that some of SQL could use a bit of improvement based on th…

2012-07-03T23:31:57Z · 数据库 · 评论(0)

《Pro Oracle SQL》Chapter10.2.3 Testing the Effects of Query Changes

Testing the Effects of Query Changes 测试查询改变的效果 (page 315) Even as data does not remain static, SQL is not always static. Sometimes requirements change, so code must be modified. What if the requirements changed for the examples in Listings 10-3 and 10-4? Would minor changes invalidate the use of th…

2012-06-13T22:59:58Z · 数据库 · 评论(0)

《Pro Oracle SQL》Chapter 10.2.2 Testing Over Multiple Executions

Testing Over Multiple Executions 测试多个执行 (page 312) What would happen if each query were run multiple times simultaneously from several different database sessions? Using a modified version of Tom Kyte’s run_stats6 queries, each query was run in twenty sessions, each session running the query twenty…

2012-05-24T00:41:39Z · 数据库 · 评论(0)

《Pro Oracle SQL》Chapter10 -- 10.2 Optimizing SQL -10.2.1Testing Execution Plans

10.2 Optimizing SQL 优化SQL (page 308) When a SQL query is designed or modified to take advantage of subquery factoring, there are some not-so-subtle changes that may take place when the optimizer creates an execution plan for the query. The following quote comes from the Oracle 11gR2 documentation i…

2012-05-14T22:19:57Z · 数据库 · 评论(0)

《Pro Oracle SQL》Chapter 10 Subquery Factoring --10.1 Standard Usage

Subquery Factoring 子查询分解 (page 305) Jared Still You may not be familiar with the term subquery factoring . Prior to the release of Oracle 11gR2, the official Oracle documentation barely mentions it, providing just a brief synopsis of its use, a couple of restrictions, and a single example. If I ins…

2012-05-02T22:46:07Z · 数据库 · 评论(0)

《Pro Oracle SQL》Chapter 9 -- 9.11 Subquery Factoring

Subquery Factoring 子查询分解 (page 303) In a business setting, requirements are complex and multiple levels of aggregation are often needed. When writing complex queries, you can often combine subquery factoring with the Model clause to prevent a SQL statement from becoming unmanageably complex. 在实际的业务…

2012-04-29T23:13:01Z · 数据库 · 评论(0)

《Pro Oracle SQL》CHAPTER 9 -- 9.10Performance Tuning with the Model Clause

Performance Tuning with the Model Clause Model子句的性能调优 (page 293) As with all SQL, sometimes you need to tune statements using the Model clause. To that end, it helps to know how to read execution plans involving the clause. It also helps to know about some of the issues you’ll encounter—such as pre…

2012-04-29T16:11:33Z · 数据库 · 评论(0)

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.9 NULLs

NULLs (page 291) In SQL statements using Model SQL, values can be null for two reasons: null values in the existing cells and references to non-existent cells. I will discuss the later scenario in this section. By default, the reference to non-existent cells will return null values. In Listing 9-21…

2012-04-22T19:57:27Z · 数据库 · 评论(0)