roller  Processing...
Shroff Publishers & Distributors Pvt. Ltd.
Login
 
 
|
Books Expand/Collapse
Skip Navigation Links.
.Net Platform
3D Computer Graphics
Academics
ACCA (Association of Chartered Certified Accountants)
Accounting
ActionScript
Active Server Pages (ASP)
ADO .NET
Adobe
Adobe Acrobat
Adobe Indesign
Adobe Photoshop
Aeronautical Engineering & Aircraft Maintenance
AIEEE
Ajax
Algebra
Algorithms
Amazon
Android
Animation
ANSI
Apache
Apple
Apple Mobile
Application Development
Application Program Interface
Application Software
Architecture
Architecture & Analysis
Arduino
Artificial Intelligence
AS/400
ASP.NET
Assembly Language Programming
Astronomy
Audio Books
Autocad
Aviation
Aviation Weather
Banking
Beginners Level
Biographies & Memoirs
Biography
Bioinformatics
Biological Terrorism
Biology
Biotechnology Engineering
Body, Mind & Spirit
Book Publishing
BPEL (Business Process Execution Language)
Brand Management
Buddhism
Business
Business & Economics
Business & Investing
Business Application
Business Communications
Business Management
Business Skills
Business Software
Business, Management & Finance
C Programming
C# / Visual C# .Net
C++ Programming
C/ C++/ C#
CADD
Career Development
Career Guides
Catering & Hotel Management
Certification
Chartered Accountancy
Chemical Engineering
Chemistry
CIA
CICS
CIMA (Chartered Institute of Management Accountants)
CISA
Cisco / Brocade
CISSP
Civil Aviation Requirement
Civil Engineering
Civil Services Aptitude Test (CSAT)
Client/Server
Cloud Computing
Cloud Programming
CMMI (Capability Maturity Model Integration)
Cobol
Coldfusion
COM / DCOM / COM+
Communications
Competitive Examination
Complete Study Text
Complete Text
Computer Architecture
Computer Games
Computer Graphics
Computer Programming
Computer Science
Computer Security
Computer Vision
Computers
Configuration Management Software
Consumer Behaviour
Content Management System (CMS)
Cookbooks
CPIM
CQA
Criminology
Crystal Reports
CSS (Cascading Style Sheets)
Current Affairs
Customer Relationship Management (CRM)
Data
Data Analysis
Data Analytics
Data Modeling
Data Science
Data Structures
Data Warehousing
Database Management
Database Programming
Databases
DB2
Defence
Dental
Design
Desktop Publishing (Macintosh & Windows)
DHTML
Digital Audio
Digital Photography
Digital Video
Distributed Computing
DIY Projects
DNS
Drafting
Dreamweaver Ultradev / Dreamweaver MX / Dreamweaver CS
Drupal
E-Commerce
E-Learning
Eclipse
Economics
Education & Reference
Educational
Electrical Engineering
Electronics
Electronics Engineering
ELT & Dictionary
Email
Embedded Systems
Engineering
English
English Language Teaching
Enterprise
Enterprise JavaBeans (EJB)
Enterprise Products and Platforms
Enterprise Service Bus (ESB)
Entrepreneurship
Environment
Ergonomic
ERP (Enterprise Resource Planning)
Exam Kit
F#
Family & Relationships - Parenting
FAQ (Frequently Asked Questions)
Fashion Design
Fashion Technology
Fiction
Filemaker Pro
Finance
Financial Accounting
Financial Applications
Financial Management
Financial Operations
Financial Strategy
Flash
Flex
Foreign Exchange
Forensics
French
Functional Programming
Game Development
Game Programming
General
Geographical Information Systems (GIS)
Geometry
Globalization
GMAT (Graduate Management Admission Test)
GNU
Google
Google Android
Graph Theory
Graphics
Graphics Design
Graphics Programming
GRE (Graduate Record Examination)
Green Computing
Hacking
Hardware
Haskell
Health & Fitness - Healing
Health IT
Health, Mind & Body
Hedge Funds
Hibernate
Hive
Hobbies
Hospitality
Hotel Management
HRD
HTML
HTML5
Human Resource Management Systems (HRMS)
IBM
IBM Mainframe
IBM Technical Resources
IBM WebSphere
IIT-JEE
Image Processing
IMAP (Internet Message Access Protocol)
Industrial Design
Industrial Engineering
Information Management Software
Information Security
Information Technology
Information Theory
Infrastructure Solutions
Innovation Management
Inspirational
Insurance
Interactive Text
Interior Design
International Business
International Developemnt
Internet
Internet Advertising
Internet Programming
Internet Protocol
Internet Security
Introducing to Computers
Investments
iPad
iPhone
iPod
Islamic Finance
Jakarta Commons
Jakarta Struts
Java
Java 2 Enterprise Edition (J2EE)
Java Certification
Java Programming
Java Server Programming
JavaScript
JavaServer Faces (JSF)
JavaServer Pages (JSP)
JBoss
JDBC
Jini
Joomla!
Journalism
jQuery
LAN (Local Area Network)
Language
Law
LDAP
Leadership
Learning Disability
LEGO
Linux
Liquor
Literature
Logistics
Lotus Notes & Domino
Mac
Mac OS
Machine Learning
Macintosh
Main Exams
Management
Management Information System (MIS)
Marine
Marketing
Marketing Management
Mathematical & Statistical Software
Mathematics
Matlab
Maya
MCSA / MCSE / MCSD
Mechanical Engineering
Media
Medical
Microcontrollers
Microfinance
Microsoft
Microsoft .Net Framework
Microsoft Access
Microsoft Certification
Microsoft Development
Microsoft Dynamics
Microsoft Excel
Microsoft Frontpage
Microsoft Office
Microsoft PowerPoint
Microsoft Programming
Microsoft Project
Microsoft Sharepoint
Microsoft Silverlight
Microsoft SQL Server
Microsoft Visual Basic
Microsoft Windows
Microsoft Word
Mobile Computing
Mobile Development
Mobile Programming
Mobile Security
Moodle
Motivational
Mulitmedia Development
Multimedia
Multithreaded
Musical Instruments
MySQL
Negotiating
Network
Network Administration
Networking
New Age
Non Fiction
NTSE
Nursing
Obesity
Object Technology
Object-Oriented Programming
Office Application
OOP
Open Source
OpenGL Programming
Operating Systems
Operation Management
Operations Management
Oracle
Organizational Behavior
Organizational Management
Patent and Trademarks
Patterns
PC Hardware
PeopleSoft
Perl
Personal Computers
Personal Growth
Pharmacology
Philosophy
PHP
Physics
PMI-ACP Exam
PMP
Pocket Notes
Political Science
Politics & Government
Postfix
Practice & Revision Kit
Presentation Software
Programming
Programming Languages
Project Book
Project Management
Psychology
Python
Quality
Quality Management
Quick Test Professional (QTP)
Rails
RDF
Real Estate/Home Buying Guides
Recipes
Reference
Relationship Marketing
Religion & Spirituality
Research Methods in Management
Revision Cards
RFID (Radio Frequency Identification)
Risk Management
Risk Management & Insurance
Robotics
RPG (Report Program Generator)
RSS (Rich Site Summary)
Ruby
Sales Management
Samba
SAP
SAS
SAT (Scholastic Aptitude Test)
Science
Search Engine Marketing
Search Engine Optimization (SEO)
Securities
Security
Self-Help
Sendmail
SharePoint
Skills
SOA: Service-Oriented Architecture
SOAP
Social Aspects
Social Media
Social Networking
Social Sciences
Social Web
Software Architecture
Software Design
Software Development
Software Documentation
Software Engineering
Software Project
Software Testing
Solaris
Spiritual
Sports
Spreadsheet
Spring
SQL
Statistical Software
Statistics
Statistics Programming
Stock Market
Strategic Management
Structural Analysis & Design
Study Aids
Study Guide
Success
Supply Chain Management
Sybase
System Administration
System Programming
Systems Analysis & Design
TCP/IP
Tech Culture
Technical Writing
Technology
Technology & Society
Telecommunications
Telephony
Test Preparation
Text Processing
Time Management
Tivoli
TOEFL (Test of English as a Foreign Language)
Tomcat
Trade Business
Travel and Tourism Management
UML (Unified Modeling Language)
Unix
Unix Programming
Unix System Administration
Unix Text Editing
Unix Utilities
Used Books
User Experience
User Interface Design
Valuation
VBA
VBScript
View Engine
Virtualization
Virtualization and Cloud
Visual Basic
Visual Basic .Net / VB .NET
Visual Basic Certification
Visual Basic Programming
Visual C++
Visual Studio .Net
Vmware
Vocational
VoIP
VPN (Virtual Private Networks)
WAP
Web
Web Analytics
Web Application
Web Application Framework
Web Authoring
Web Design
Web Development
Web Graphics & Video
Web Marketing
Web Programming
Web Publishing
Web Security
Web Server
Web Services
WebLogic
Website Optimization
WebSphere
Windows
Windows 2000
Windows 7
Windows 8
Windows 95
Windows Administration
Windows Applications
Windows Forms
Windows NT
Windows NT Administration
Windows Programming
Windows Server
Windows Server 2003
Windows Vista
Windows XP
Wireless
WordPress
World Wide Web
X Windows
XHTML
XML (Extensible Markup Language)
XSL
XSLT
Yoga
Titles By Year Expand/Collapse
Product Details
Books » Oracle
Advanced Oracle SQL Programming
Advanced Oracle SQL Programming
The Expert Guide to Writing Complex Queries
By Donald Burleson, Laurent Schneider
|
ISBN: 9788184049404
Paperback
Pages: 316
Size: 9 X 6
Shroff/Rampant (2008)
Arrival Date: December 10, 2008
List Price: Rs 500.00
Net Price: Rs 450.00    You save 10.00%
Usually shipped in 2-3 days

Add to cart    Add to wishlist
Description Table of Contents
Oracle SQL is one of the world's most powerful dialects, packed with advanced functions and features that give Oracle SQL  procedural language capabilities.  Using these powerful features it is no longer necessary to embed Oracle SQL inside a procedural language, and native Oracle SQL can now be used to solve complex query problems.

This is an indispensable book for all Oracle DBA's and developers who need to understand how to apply Oracle SQL features for complex queries.

Written by a certified Oracle Master and Oracle ACE, this advanced book shows working examples of how to leverage Oracle SQL's powerful built-in functions for fast extraction of complex data and how to use native SQL for procedural processing.

Every developer needs to know how to use Oracle SQL to summarize and aggregate data from large tables and how to use powerful features such as the "model" clause to make SQL act as a procedural language.

This book shows important techniques on how to leverage Oracle's powerful XML interface to quickly format Oracle data with XML for instant publication.

This is not a book for beginners or dilettantes and it is designed for the professional Oracle developer, covering many advanced Oracle SQL techniques including XML queries, Oracle SQL analytics, SQL for aggregation, and traversing Hierarchies.

Best of all, the author reveals secrets for retrieving Oracle data faster and more elegantly than the traditional approaches to writing SQL.

About the Author

Laurent Schneider
is an Oracle Certified Master with more than 10 years of experience with Oracle and UNIX. He has written many articles about Oracle technologies and has provided thousands of answers on online technical forums. He is currently a management system engineer at LC Systems Engineering.

Donald Burleson
is one of the world’s top Oracle Database experts with more than 20 years of full-time DBA experience. He has written 30 books, including Oracle Data Mining and Oracle Shell Scripting, and serves as editor-in-chief of Rampant TechPress.
  • Using the Online Code Depot           
  • Conventions Used in this Book         
  • Acknowledgements   
Chapter 1: Oracle SQL Query Overview  
  • Introduction   
  • Syntax Review           
  • Subquery Inline view
  • Nested subquery        
  • Joins   
  • Sets    
  • SQL expressions        
  • Conclusion     
  • Exercises        
  • Solutions        
Chapter 2: Oracle SQL Functions  
  • Oracle SQL functions
  • Mathematic functions
  • Binary functions        
  • Signs functions          
  • Rounding and truncating functions   
  • Modulo functions      
  • Functions to search and modify strings         
  • Regular expression functions
  • Conversion functions
  • NLS functions           
  • National character set
  • Logical functions with true or false values    
  • Null functions
  • Conclusion     
  • Exercises        
  • Solutions        
Chapter 3: SQL Aggregate Functions
  • Aggregate functions  
  • Standard Aggregate Functions          
  • Distinct          
  • Keep   
  • Nested Aggregates    
  • Subtotals        
  • PIVOT and UNPIVOT         
  • Conclusion     
  • Exercises        
  • Solutions        
Chapter 4: Oracle SQL Analytics
  • Analytics        
  • OVER
  • PARTITION  
  • Ranking functions      
  • Window         
  • Aggregation   
  • FIRST_VALUE and LAST_VALUE          
  • Conclusion     
  • Exercises        
  • Solutions
Chapter 5: XML
  • XML  
  • XML Instance
  • XMLTYPE    
  • XMLELEMENT       
  • XMLCONCAT and XMLFOREST
  • XPATH          
  • XMLSEQUENCE     
  • XQuery          
  • Aggregation   
  • XMLSERIALIZE     
  • XMLCAST    
  • Conclusion     
  • Exercises        
  • Solutions        
Chapter 6: Oracle Hierarchies
  • Hierarchies     
  • Hierarchical Queries   
  • CONNECT BY, PRIOR and START WITH           
  • LEVEL          
  • ORDER SIBLINGS BY       
  • PRIOR           
  • SYS_CONNECT_BY_PATH           CONNECT_BY_ROOT       
  • CONNECT BY LOOP         
  • CONNECT BY NOCYCLE and CONNECT_BY_ISCYCLE      
  • CONNECT BY without PRIOR       CONNECT_BY_IS_LEAF  
  • WHERE and JOIN    
  • Aggregation   
  • Conclusion     
  • Exercises        
  • Solutions
Chapter 7: SQL For Modeling
  • SQL for Modeling     
  • Partitions, dimensions and measures
  • Update           
  • Upsert
  • CV     
  • Conditions     
  • FOR loops      
  • Iterations        
  • Reference Model       
  • Aggregation   
  • Analytics        
  • Ordered Rows           
  • Conclusion     
  • Exercises        
  • Solutions        
Appendix A:  SQL*Plus
  • Starting SQL*Plus     
  • SQL*Plus Statements
  • Formatting     
  • Substitution Variables
  • HTML
  • Index  
About Laurent Schneider

About Chen Shapira

About Tom Routen
MINI CART

Your cart is empty.
MINI WISHLIST

Your wishlist is empty.