找回密码
 To register

QQ登录

只需一步,快速开始

扫一扫,访问微社区

Titlebook: Oracle SQL Revealed; Executing Business L Alex Reprintsev Book 2018 Alex Reprintsev 2018 PL/SQL.MODEL clause.CONNECT BY.Query Transformatio

[复制链接]
查看: 47569|回复: 52
发表于 2025-3-21 16:31:10 | 显示全部楼层 |阅读模式
书目名称Oracle SQL Revealed
副标题Executing Business L
编辑Alex Reprintsev
视频video
概述Guides you in using analytic functions, the model clause, row pattern matching, and other powerful features in Oracle SQL.Helps you find competitive advantage through built-in features that are common
图书封面Titlebook: Oracle SQL Revealed; Executing Business L Alex Reprintsev Book 2018 Alex Reprintsev 2018 PL/SQL.MODEL clause.CONNECT BY.Query Transformatio
描述Write queries using little-known, but powerful, SQL features implemented in Oracle‘s database engine. You will be able to take advantage of Oracle’s power in implementing business logic, thereby maximizing return from your company’s investment in Oracle Database products..Important features and aspects of SQL covered in this book include the model clause, row pattern matching, analytic and aggregate functions, and recursive subquery factoring, just to name a few. The focus is on implementing business logic in pure SQL, with a comparison of different approaches that can be used to write SELECT statements to return results that drive good decision making and competitive action in the marketplace.  .This book covers features that are often not well known, and sometimes not implemented in competing products. Chapters on query transformation and logical execution order provide a grasp of the big picture in which the individual SQL features described in the other chapters are executed. Also included are a discussion on when to use the procedural capabilities from PL/SQL, and a series of examples showing different mixes of SQL features being applied in common types of queries that you are
出版日期Book 2018
关键词PL/SQL; MODEL clause; CONNECT BY; Query Transformation; Analytic functions; Window functions; ANSI joins; R
版次1
doihttps://doi.org/10.1007/978-1-4842-3372-6
isbn_softcover978-1-4842-3371-9
isbn_ebook978-1-4842-3372-6
copyrightAlex Reprintsev 2018
The information of publication is updating

书目名称Oracle SQL Revealed影响因子(影响力)




书目名称Oracle SQL Revealed影响因子(影响力)学科排名




书目名称Oracle SQL Revealed网络公开度




书目名称Oracle SQL Revealed网络公开度学科排名




书目名称Oracle SQL Revealed被引频次




书目名称Oracle SQL Revealed被引频次学科排名




书目名称Oracle SQL Revealed年度引用




书目名称Oracle SQL Revealed年度引用学科排名




书目名称Oracle SQL Revealed读者反馈




书目名称Oracle SQL Revealed读者反馈学科排名




单选投票, 共有 1 人参与投票
 

0票 0.00%

Perfect with Aesthetics

 

0票 0.00%

Better Implies Difficulty

 

1票 100.00%

Good and Satisfactory

 

0票 0.00%

Adverse Performance

 

0票 0.00%

Disdainful Garbage

您所在的用户组没有投票权限
发表于 2025-3-21 21:25:28 | 显示全部楼层
发表于 2025-3-22 02:39:56 | 显示全部楼层
Logical Execution Order of Query Clauses can implement the entire logic using a single query block – it’s not always necessary, because Oracle can eliminate inline views during the query transformations. Moreover, in some cases additional inline views may help to improve the performance as it will be shown in the end of the chapter.
发表于 2025-3-22 07:52:11 | 显示全部楼层
Turing Completenessinteresting to analyze whether it‘s Turing complete or not for the sake of completeness. Moreover, as will be shown in the next chapter "When PL/SQL Is Better Than Vanilla SQL," sometimes pure SQL is not the best way to get the result even if an algorithm can be easily implemented using it.
发表于 2025-3-22 11:00:26 | 显示全部楼层
Recursive Subquery Factoringve impact on the performance because the transformation engine doesn’t treat named queries in the same way as inline views. For example, on older versions Oracle could have merged an inline view but not the named query with exactly the same text.
发表于 2025-3-22 13:09:53 | 显示全部楼层
petitive advantage through built-in features that are commonWrite queries using little-known, but powerful, SQL features implemented in Oracle‘s database engine. You will be able to take advantage of Oracle’s power in implementing business logic, thereby maximizing return from your company’s investm
发表于 2025-3-22 18:47:18 | 显示全部楼层
发表于 2025-3-22 23:14:55 | 显示全部楼层
发表于 2025-3-23 05:10:47 | 显示全部楼层
发表于 2025-3-23 06:57:18 | 显示全部楼层
 关于派博传思  派博传思旗下网站  友情链接
派博传思介绍 公司地理位置 论文服务流程 影响因子官网 SITEMAP 大讲堂 北京大学 Oxford Uni. Harvard Uni.
发展历史沿革 期刊点评 投稿经验总结 SCIENCEGARD IMPACTFACTOR 派博系数 清华大学 Yale Uni. Stanford Uni.
|Archiver|手机版|小黑屋| 派博传思国际 ( 京公网安备110108008328) GMT+8, 2025-6-7 15:42
Copyright © 2001-2015 派博传思   京公网安备110108008328 版权所有 All rights reserved
快速回复 返回顶部 返回列表