Lost Password?


Delphi Forum - Delphi Programming Kings of Code
Registration is OPEN!6 months VIP Access - 20 $ Donation - 1 year VIP Access - 30 $ Donation -2 years VIP Access - 50 $ Donation - Gold user For life VIP Access - 150 $ Donation... Delphifan Crew

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Login or Register
Post Reply 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Oracle SQL Revealed
04-12-2018, 10:47 AM
Post: #1
Oracle SQL Revealed
Executing Business Logic in the Database Engine

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 likely to encounter. 

Author: Alex Reprintsev 
Publication Date: 2018
Number of pages: 389
ISBN-13: 978-1-4842-3372-6
Format: PDF, EPUB

Register or login to see this content

My Last Threads

You have no idea what you do not know!
                         Elon Musk

Quote this message in a reply
Post Reply 

Messages In This Thread
Oracle SQL Revealed - AdminDF™ - 04-12-2018 10:47 AM

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  EMS SQL Manager for Oracle v3.3.0.45868 fabiomatte.2010 25 1,962 04-16-2018 03:48 PM
Last Post: pax
  Oracle Database Utilities – Perform Data Export Import AdminDF™ 0 0 04-12-2018 10:39 AM
Last Post: AdminDF™
  Oracle Advanced PL/SQL Developer Professional Guide AdminDF™ 0 0 03-30-2018 01:50 PM
Last Post: AdminDF™
  Oracle Database 12c: Security Year AdminDF™ 0 0 03-10-2018 04:03 PM
Last Post: AdminDF™
  Oracle Database 12c: Backup and Recovery AdminDF™ 0 0 03-10-2018 04:02 PM
Last Post: AdminDF™
  PL SQL in Depth A Comprehensive Guide to Oracle PLSQL AdminDF™ 0 0 02-28-2018 02:52 PM
Last Post: AdminDF™
  Formal SQL Tuning for Oracle Databases: Practical Efficiency - Efficient Practice AdminDF™ 1 89 02-23-2018 10:01 PM
Last Post: ahgrdff
  Oracle Database 12c Administrator Certified Associate Study Guide: Exams 1Z0-061 and AdminDF™ 0 0 02-22-2018 10:58 AM
Last Post: AdminDF™
  Oracle Essbase & Oracle OLAP: The Guide to Oracle's Multidimensional Solution AdminDF™ 0 0 02-22-2018 10:55 AM
Last Post: AdminDF™
  Toad for Oracle 2017 Edition (x86/x64) AdminDF™ 1 108 02-06-2018 09:30 AM
Last Post: ajp

Forum Jump:

User(s) browsing this thread: 1 Guest(s)

Theme designed by Delphifan (Sidebar created by Delphifan - Delphifan.com)
Copyright © 2018 Delphi Forum - Delphi Programming Kings of Code - All rights reserved.

For GOLD or Payment Vip User Please send PM to Administrator

Delphi,Embarcadero,Delphi XE6,Delphi XE7,Delphi XE5,TMS,Devexpress,Delphi Components,Full Delphi Download,Delphi Android,Delphi IOS,Delphi Mobile programming,Delphi Forum,Embarcadero Berlin 10.1