Oracle SQL
Jumpstart with Examples
- 1st Edition - September 23, 2004
- Latest edition
- Authors: Gavin JT Powell, Carol McCullough-Dieter
- Language: English
Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA… Read more
World Book Day celebration
Where learning shapes lives
Up to 25% off trusted resources that support research, study, and discovery.
Description
Description
Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL.
Key features
Key features
* Each of the hundreds of SQL code examples was tested on a working Oracle 10g database
* Invaluable everyday tool that provides an absolute plethora of properly tested examples of Oracle SQL code
* Authors have four decades of commercial experience between them as developers and database administrators
* Invaluable everyday tool that provides an absolute plethora of properly tested examples of Oracle SQL code
* Authors have four decades of commercial experience between them as developers and database administrators
Readership
Readership
Oracle Developers and DBA’s.
Product details
Product details
- Edition: 1
- Latest edition
- Published: September 23, 2004
- Language: English
About the authors
About the authors
GP
Gavin JT Powell
Gavin Powell, BSc. Comp.Sci., OCP (Oracle8i Certified Professional) has fifteen years of computer industry experience. Diverse experience in database administration and database development in both relational and object databases. Applications development experience is procedural and object-oriented. He also has some systems administration experience. His extensive consulting experience includes software vendors, internet .COM’s (some unfortunately have met with their demise), accounting, banking, financial services, the travel industry, construction, retail, mining, shipping, education and general advisory capacity. Gavin Powell has worked with many software products, tools and programming languages. These tools include items in the list shown below. He has authored two successful books Oracle …High performance Tuning and the just released Oracle SQL
Affiliations and expertise
Microsoft and Database consultant; Author of seven database books.CM
Carol McCullough-Dieter
Carol McCullough-Dieter is a veteran database designer and trainer. She has written many books on Oracle including Oracle9i Database Administrator: Implementation and Administration. As an independent consultant for federal and state government projects in Wisconsin and Hawaii, she designed and implemented complex, secure, integrated web-based database systems. She has designed in-house and online training guides for Oracle SQL coding and performance tuning.
Affiliations and expertise
Independent Consultant, U.S.A.View book on ScienceDirect
View book on ScienceDirect
Read Oracle SQL on ScienceDirect