博客首页 → Pro Oracle SQL

最新文章列表

《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 recur ...
Pro Oracle SQLOracleSQLApressDBA
caohong286 评论(0) 有1370人浏览 2012-07-06 00:30

《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 ...
Pro Oracle SQLOracleSQLApressDBA
caohong286 评论(0) 有1385人浏览 2012-07-04 23:19

《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 ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有940人浏览 2012-07-03 23:31

《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 m ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有934人浏览 2012-06-13 22:59

《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 ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有913人浏览 2012-05-24 00:41

《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 ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1260人浏览 2012-05-14 22:19

《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 ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1079人浏览 2012-05-02 22:46

《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 com ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1114人浏览 2012-04-29 23:13

《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 ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1195人浏览 2012-04-29 16:11

《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 sce ...
Pro Oracle SQLOracleSQLApressDBA
caohong286 评论(0) 有878人浏览 2012-04-22 19:57

《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 tabl ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有911人浏览 2012-04-21 14:18

《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 ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1076人浏览 2012-04-21 13:53

《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 functi ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有898人浏览 2012-04-19 01:47

《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 a ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1176人浏览 2012-04-17 00:52

《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 behavio ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1226人浏览 2012-04-14 22:36

《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 indi ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有922人浏览 2012-04-13 22:01

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

I nter-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-j ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1008人浏览 2012-04-10 22:35

《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. ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有941人浏览 2012-04-08 15:51

《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 ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1233人浏览 2012-04-02 11:41

《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 from ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有992人浏览 2012-04-01 02:14

最近博客热门TAG

Java(141744) C(73651) C++(68608) SQL(64571) C#(59609) XML(59133) HTML(59043) JavaScript(54919) .net(54785) Web(54514) 工作(54118) Linux(50905) Oracle(49875) 应用服务器(43289) Spring(40812) 编程(39454) Windows(39381) JSP(37542) MySQL(37267) 数据结构(36424)

博客人气排行榜

    博客电子书下载排行

      >>浏览更多下载

      相关资讯

      相关讨论

      Global site tag (gtag.js) - Google Analytics