eBook - PDF

Oracle SQL

Name: Oracle SQL
Author: Gavin JT Powell,Carol McCullough-Dieter

Jumpstart with Examples

Gavin JT Powell,

Carol McCullough-Dieter,

688 pages
English
PDF
Available on iOS & Android

eBook - PDF

Oracle SQL

Jumpstart with Examples

Gavin JT Powell,

Carol McCullough-Dieter,

Book details

Table of contents

Citations

About This Book

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.* 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

Frequently asked questions

Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.

At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.

Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.

We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.

Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.

Yes, you can access Oracle SQL by Gavin JT Powell,Carol McCullough-Dieter in PDF and/or ePUB format, as well as other popular books in Computer Science & Databases. We have over one million books available in our catalogue for you to explore.

Information

Publisher

Digital Press

Year

2004

ISBN

9780080479835

Topic

Computer Science

Subtopic

Databases

Index

Computer Science

Front Cover
Oracle SQL Jumpstart with Examples
Copyright Page
Table of Contents
Foreword
Preface
Acknowledgements
Chapter 1. Introduction to Oracle SQL
Chapter 2. New Features of Oracle SQL
Chapter 3. Oracle Database Architecture
Chapter 4. The SELECT Statement
Chapter 5. Filtering Rows
Chapter 6. Sorting Rows
Chapter 7. Operators, Conditions, and Pseudocolumns
Chapter 8. Using SQL*Plus
Chapter 9. Single-Row Functions
Chapter 10. Joining Tables
Chapter 11. Grouping and Summarizing Data
Chapter 12. Subqueries
Chapter 13. Unusual Query Types
Chapter 14. Expressions
Chapter 15. Data Manipulation Language (DML)
Chapter 16. Datatypes and Collections
Chapter 17. XML in Oracle
Chapter 18. Tables
Chapter 19. Views
Chapter 20. Constraints
Chapter 21. Indexes and Clusters
Chapter 22. Sequences and Synonyms
Chapter 23. Security
Chapter 24. Basic PL/SQL
Appendix A. Schema Scripting
Appendix B. Utility Scripts
Appendix C. Sources of Information
Index