caohong286
- 浏览: 90767 次
- 性别:
- 来自: 深圳
-
最新评论
-
mojunbin：
这个不能不顶。
《Pro Oracle SQL》 Chapter2--2.1 Oracle Architecture Basics -
Branding：
谢谢，获益匪浅
《Pro Oracle SQL》--chapter 5--5.6 Building Logical Expressions -
Branding：
《Pro Oracle SQL》--Chapter 5--5.4 Questions about the Question -
Branding：
谢谢
《Pro Oracle SQL》 翻译序 -- 读书心得 -
jiaoshiguoke：
继续 加油
《Pro Oracle SQL》--Chapter 6--6.1 Explain Plans--之三
文章列表
天行健，君子以自强不息！
作为一名和Oracle数据库打交道很多的Java Web开发人员，接触数据库久了，深感数据库知识的匮乏。我由此萌发了精研Oracle的动力。另一方面，Oracle的开发人员的待遇通常都要比Java的好得多。 ...
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 mo ...
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 f ...
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-
But ...
最近学习《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：
与书中使用的英文描述不符，学习起来不方便。想把它设置回英 ...
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 f ...
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 sin ...
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 ...
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 ...
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 th ...
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 d ...
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 ...
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 unmanageabl ...
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 issue ...
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. I ...