博客首页 → Apress

最新文章列表

《Pro Oracle SQL》Chapter7 --7.6Eliminate NULLs with the GROUPING() Function

7.6 Eliminate NULLs with the GROUPING() Function  用GROUPING()函数消除NULL值  (page 207)     There seems to be a problem with the output from the new query seen in Listing 7-12.  While the numbers mat ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1044人浏览 2011-11-23 23:13

《Pro Oracle SQL》Chapter7 Advanced Grouping -- 7.5Putting CUBE To Work

 7.5 Putting CUBE to work      CUBE实战     (page 201)        When teaching us a new word in fourth grade English class, Mrs. Draper would say, “Now use it in a sentence.”   ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有997人浏览 2011-11-19 09:31

《Pro Oracle SQL》Chapter7 -- 7.3--7.4CUBE Extension to GROUP BY

7.3“New” GROUP BY Functionality “新”GROUP BY 功能              (page 197)     At times, it’s necessary to write SQL that appears as unruly as the convoluted example in Listing 7-5 so that the desire ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1070人浏览 2011-11-17 22:59

《Pro Oracle SQL》Chapter7 Advanced Grouping -- 7.2HAVING Clause

7.2 HAVING Clause     HAVING 子句   (page 195)     Results generated by GROUP BY may be restricted by the criteria found in the HAVING clause.  The HAVING clause is quite versatile, resembling the WHE ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有965人浏览 2011-11-15 23:23

《Pro Oracle SQL》 翻译序 -- 读书心得

      天行健，君子以自强不息！ 作为一名和Oracle数据库打交道很多的Java Web开发人员，接触数据库久了，深感数据库知识的匮乏。我由此萌发了精 ...
Pro Oracle SQLORACLESQLApressDBA 
caohong286 评论(1) 有2811人浏览 2011-11-12 22:35

《Pro Oracle SQL》Chapter7 Advanced Grouping -- 7.1Basic GROUP BY Usage

Chapter 7 Advanced Grouping  第七章 高级分组    Jared Still    (page 213)     The GROUP BY clause is a venerable member of the SQL statement family.  After learning basic SELECT statements, it is one of ...
Pro Oracle SQLOracleSQLApressDBA 
caohong286 评论(0) 有1325人浏览 2011-11-09 23:31

《Pro Oracle SQL》 读书笔记--Chapter 6--6.2 Execution Plans--之五

Using Plan Information for Solving Problems 使用计划信息解决问题 （Page 180）      Now that you know how to access the various bits of information, what do you do with them?  The plan information, particularly ...
Pro Oracle SQLOracleSQLApress 
caohong286 评论(0) 有1140人浏览 2011-11-06 14:11

《Pro Oracle SQL》 读书笔记--Chapter 6--6.2 Execution Plans--之四

Understanding DBMS_XPLAN in Detail 深入理解DBMS_XPLAN   (Page 174)     The DBMS_XPLAN package is supplied by Oracle and can be used to simplify the retrieval and display of plan output, as I have demons ...
Pro Oracle SQLOracleSQLApress 
caohong286 评论(0) 有1132人浏览 2011-10-31 23:34

《Pro Oracle SQL》--Chapter 6--6.2 Execute Plans--之三

Identifying SQL Statements for Later Plan Retrieval    标示SQL语句便于之后计划检索 (page 171)     If you want to retrieve a statement that was executed in the past, you can retrieve the SQL_ID and CHILD_NUMBER ...
Pro Oracle SQLOraclesqlApress 
caohong286 评论(0) 有885人浏览 2011-10-26 22:42

《Pro Oracle SQL》--Chapter 6--6.2 Execution Plans--之二

Collecting the Plan Statistics  收集计划的统计(信息) (page 168)     The plan operations shown when no plan statistics are available is essentially the same as the output from EXPLAIN PLAN.  To get to the h ...
Pro Oracle SQLOracleSQLApress 
caohong286 评论(0) 有999人浏览 2011-10-25 07:11

《Pro Oracle SQL》--Chapter 6 SQL Execution Plans --6.2 Execution Plans--之一

Execution Plans   执行计划 (page 166)      The actual execution plan for a SQL statement is produced when a statement is executed.  After the statement is hard parsed, the plan that is chosen is stored i ...
Pro Oracle SQLOracleSQLApress 
caohong286 评论(0) 有1015人浏览 2011-10-22 10:17

《Pro Oracle SQL》--Chapter 6--6.1 Explain Plans--之三

Reading the Plan   解读计划  (page163)     Before I dive further into capturing actual execution plan data, I want to make sure you are comfortable with reading a plan.  I’ve already discussed the impor ...
Pro Oralce SQLORACLESQLApress 
caohong286 评论(1) 有1253人浏览 2011-10-21 06:35

《Pro Oracle SQL》--Chapter 6--6.1 Explain Plans--之二

Understanding How EXPLAIN PLAN can Miss the Mark 理解解释计划怎么会错误标记     One of the most frustrating things about EXPLAIN PLAN output is that it may not always match the plan that is used when the stateme ...
Pro Oracle SQLORACLESQLApress 
caohong286 评论(0) 有1100人浏览 2011-10-17 23:06

《Pro Oracle SQL》--Chapter 6--6.1 Explain Plans--之一

Chapter 6--SQL Execution Plans    SQL执行计划 6.1 Explain Plan 解释计划 Karen Morton You’ve seen quite a few execution plans in the first chapters of this book, but in this chapter I ...
Pro Oracle SQLOracleSQLApress 
caohong286 评论(0) 有1084人浏览 2011-10-17 15:14

《Pro Oracle SQL》--chapter 5--5.6 Building Logical Expressions

5.6 Building Logical Expresions 构建逻辑表达式 (page 140)     Once you understand the question that the statement you are writing needs to answer, you have to be able to build the SQL to pro ...
Pro Oracle SQLORACLESQLApress 
caohong286 评论(1) 有1394人浏览 2011-10-16 01:04

《Pro Oracle SQL》--Chapter 5--5.5 Questions about Data

Questions about Data  关于数据的问题 (page 134)     I hope at this point you agree that you do need to concern yourself with how data is stored and how it should be accessed.  Where do you find this inform ...
Pro Oracle SQLORACLESQLApress 
caohong286 评论(0) 有759人浏览 2011-10-15 00:42

《Pro Oracle SQL》--Chapter 5--5.4 Questions about the Question

5.4 Questions about the Question   关于问题的问题 (page 132)      Developing new queries is usually easier than trying to modify a query that someone else has already written.  This is because when you ...
Pro Oracle SQLORACLESQLApress 
caohong286 评论(1) 有1241人浏览 2011-10-12 00:36

最近博客热门TAG

Java(141747) C(73651) C++(68608) SQL(64571) C#(59609) XML(59133) HTML(59043) JavaScript(54918) .net(54785) Web(54513) 工作(54116) Linux(50906) Oracle(49876) 应用服务器(43288) Spring(40812) 编程(39454) Windows(39381) JSP(37542) MySQL(37268) 数据结构(36423)

博客人气排行榜

    博客电子书下载排行

      >>浏览更多下载

      相关资讯

      相关讨论

      Global site tag (gtag.js) - Google Analytics