自定义博客皮肤VIP专享

*博客头图:

格式为PNG、JPG,宽度*高度大于1920*100像素,不超过2MB,主视觉建议放在右侧,请参照线上博客头图

请上传大于1920*100像素的图片!

博客底图:

图片格式为PNG、JPG,不超过1MB,可上下左右平铺至整个背景

栏目图:

图片格式为PNG、JPG,图片宽度*高度为300*38像素,不超过0.5MB

主标题颜色:

RGB颜色,例如:#AFAFAF

Hover:

RGB颜色,例如:#AFAFAF

副标题颜色:

RGB颜色,例如:#AFAFAF

自定义博客皮肤

-+
  • 博客(81)
  • 收藏
  • 关注

原创 JavaBean学习三

 32.4 Java Event Model ReviewA bean may communicate with other beans. The Java event delegation model provides thefoundation for beans to send, receive, and handle events. Let us review the Ja...

2012-09-26 22:57:50 144

原创 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 componen...

2012-09-21 00:07:54 122

JavaBean 学习一

32.1 Introduction    Every Java user interface class is a JavaBeans component. Understanding JavaBeans will helpyou to learn GUI components. In Chapter 16, “Event-Driven Programming,” you learne...

2012-09-19 00:09:23 137

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。在ht...

2012-09-09 13:45:48 256

《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 recu...

2012-07-06 00:30:37 144

《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 tim...

2012-07-04 23:19:45 148

原创 《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...

2012-07-03 23:31:57 223

《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...

2012-06-13 22:59:58 91

《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 differentdatabase sessions?  Using a modified versio...

2012-05-24 00:41:39 105

《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...

2012-05-14 22:19:57 118

《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...

2012-05-02 22:46:07 160

《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 co...

2012-04-29 23:13:01 107

《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 ex...

2012-04-29 16:11:33 103

原创 《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 sc...

2012-04-22 19:57:27 112

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.8 Lookup Tables

Lookup Tables     查找表(page 290)    You can define a lookup table and refer to that lookup table in the rules section. Such a lookup table is sometimes termed a  reference table . Reference tab...

2012-04-21 14:18:51 112

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.7 Iteration

Iteration   迭代  (page 287)    Iteration provides another facility to implementing complex business requirements using a concise Model SQL statement.  A block of rules can be executed in a loop...

2012-04-21 13:53:27 108

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.6 Aggregation

Aggregation   聚合    (page 285)    Data aggregation is commonly used in the data warehouse queries. The Model clause provides the ability to aggregate the data using aggregate functions over th...

2012-04-19 01:47:30 126

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.5 Evaluation Order

Evaluation Order   求值顺序    (page 282)      Multiple rules can be specified in the rules section, and the rules can be specified with dependencies betweene them. The rule evaluation sequence can ...

2012-04-17 00:52:04 210

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.4Returning Updated Rows

Returning Updated Rows   返回更新的行      (page 280)    In Listing 9-7, just four rows were returned even though there are rows for other weeks. The clause RETURN UPDATED ROWS  controls this behavi...

2012-04-14 22:36:58 226

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.3 Positional and Symbolic Refere

Positional and Symbolic References     位置和符号引用   (page 277)    As discussed previously, the CV function provides the ability to refer to a single cell. It is also possible to refer to an ind...

2012-04-13 22:01:07 96

《Pro Oracle SQL》CHAPTER 9 -- 9.2 Inter-Row Referencing via the Model clause

Inter-Row Referencing via the Model clause 用Model子句行间引用  (page 274)    In a conventional SQL statement, emulating the spreadsheet described in Listing 9-1 is achieved by a multitude of self-...

2012-04-10 22:35:47 120

《Pro Oracle SQL》CHAPTER 9 The Model Clause -- 9.1 Spreadsheets

The Model Clause    Model子句   (page 273)Riyaj Shamsudeen     The Model clause introduced in the Oracle Database version 10g provides an elegant method to replace the spreadsheet. With the Mo...

2012-04-08 15:51:21 102

《Pro Oracle SQL》Chapter3 -- 3.3.5 Outer Joins

Outer Joins    外连接     (page 120)     An outer join returns all rows from one table and only those rows from the joined table where the join condition is met.  Oracle uses the  + character...

2012-04-02 11:41:30 158

《Pro Oracle SQL》Chapter 3 -- 3.3.4 Cartesian Joins

Cartesian Joins     笛卡尔连接     (page 118)    Cartesian joins occur when all the rows from one table are joined to all the rows of another table.  Therefore, the total number of rows resulting fro...

2012-04-01 02:14:01 81

《Pro Oracle SQL》Chapter 3 -- 3.3.3 Hash Joins

Hash Joins    哈希连接      (page 116)     Hash joins, like sort-merge joins, first reads the two tables to be joined independently and applies the criteria in the WHERE clause.  Based on table an...

2012-03-30 02:15:16 85

《Pro Oracle SQL》Chapter 3 -- 3.3.2 Sort-Merge Joins

Sort-Merge Joins    排序-合并连接      (page 114)   Sort-merge joins read the two tables to be joined independently, sorts the rows from each table (but only those rows that meet the conditions for th...

2012-03-27 22:07:27 131

《Pro Oracle SQL》Chapter 3 -- 3.3.1 Nested Loops Joins

Nested Loops Joins  嵌套循环连接       (page 111)    Nested loops joins use each row of the query result reached through one access operation to drive into another table.  These joins are typically ...

2012-03-25 18:12:09 107

《Pro Oracle SQL》Chapter 3 -- 3.3 Join Methods

Join Methods  连接方法  (page 110)    If there are multiple tables in your query, after the optimizer determines the access methods most appropriate for each of the tables, the next step is to det...

2012-03-24 15:51:00 90

《Pro Oracle SQL》Chapter3--3.2.7 Index Fast Full Scan

Index Fast Full Scan  索引快速全扫描   (page 109)    An index fast full scan is more like a full table scan than like other index scan types.  When an index fast full scan operation is chosen, all th...

2012-03-24 01:09:09 85

《Pro Oracle SQL》Chapter3--3.2.6 Index Skip Scan

Index Skip Scan    索引跳跃扫描    (page 107)    An index skip scan is chosen when the predicate contains a condition on a non-leading column in an index and the leading columns are fairly disti...

2012-03-23 00:57:57 102

《Pro Oracle SQL》Chapter 3--3.2.5 Index Full Scan

Index Full Scan  索引全扫描  (page 103)    An index full scan is chosen under several conditions including: when there is no predicate but the column list can be satisfied through an index on a col...

2012-03-22 05:08:44 102

《Pro Oracle SQL》Chapter3--3.2.4 Index range scan

Index range scan    索引范围扫描   (page 101)    An index range scan is chosen when a predicate contains a condition that will return a range of data.  The index can be unique or non-unique as it ...

2012-03-20 00:10:36 92

《Pro Oracle SQL》Chapter3--3.2.3 Index Unique Scan

Index Unique Scan    索引唯一扫描    (page 78)    An index unique scan is chosen when a predicate contains a condition using a column defined with a UNIQUE or  PRIMARY KEY  index.  These types of in...

2012-03-19 05:26:29 95

《Pro Oracle SQL》Chapter3--3.2.2 Index Scan Types

Index Scan Types  索引扫描类型     (page 97)    There are several different types of index scans but each share some common ground in how they must traverse the index structure to access the leaf bloc...

2012-03-17 23:34:22 106

《Pro Oracle SQL》Chapter3--3.2 Index Scan Access Methods--3.2.1 Index Structure

Index Scan Access Methods      索引扫描访问方法  (page 95)    If you have a book about U.S. Presidents and want to find information on Jimmy Carter, you could start on the first page and visually ...

2012-03-15 20:04:39 92

《Pro Oracle SQL》Chapter3--3.1.4 Full Scans and the Highwater Mark

Full Scans and the Highwater Mark    全扫描和高水标识    A final point of note regarding full table scans is that as the multiblock read calls for the scan are made, Oracle will read blocks up to the ...

2012-03-14 20:49:22 125

《Pro Oracle SQL》Chapter3--3.1 Full Scan Access Methods 之二

Full Scans and Throwaway  全扫描和“抛弃”    Always remember that whether or not a full scan will be an effective choice depends on the number of blocks that will need to be read as much as on how ma...

2012-03-11 23:14:04 84

《Pro Oracle SQL》Chapter3--3.1Full Scan Access Methods之一

Chapter3  Access and Join Methods 访问和连接方法Karen Morton     (page 83)    The optimizer must determine how to access the data your SQL statements require. You formulate your statement and the opt...

2012-03-10 18:01:14 117

《Pro Oracle SQL》Chapter8--8.9 Advanced topics

Advanced topics     高级主题     (page 268)    A few advanced topics about the analytic functions are worthy of discussion. I will discuss topics such as dynamic analytic statements, nesting of anal...

2012-03-05 21:41:25 106

《Pro Oracle SQL》Chapter8--8.8 Performance Tuning

Performance Tuning     性能调优     (page 266)    Analytic functions are very useful in tuning complex SQL statements. Inter-row referencing, aggregation at multiple levels, and nth-row access are a...

2012-03-02 23:11:09 87

空空如也

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

提示
确定要删除当前文章?
取消 删除