Forta B. - Sams Teach Yourself Oracle PL/SQL in 10 Minutes

ePUB is an open, industry-standard format for eBooks. However, support of ePUB and its many features varies across reading devices and applications. Use your device or app settings to customize the presentation to your liking. Settings that you can customize often include font, font size, single or double column, landscape or portrait mode, and figures that you can click or tap to enlarge. For additional information about the settings and features on your reading device or app, visit the device manufacturers Web site.

Many titles include programming code or configuration examples. To optimize the presentation of these elements, view the eBook in single-column, landscape mode and adjust the font size to the smallest setting. In addition to presenting code and configurations in the reflowable text format, we have included images of the code that mimic the presentation found in the print book; therefore, where the reflowable format may compromise the presentation of the code listing, you will see a Click here to view code image link. Click the link to view the print-fidelity code image. To return to the previous page viewed, click the Back button on your device or app.

Ben Forta

800 East 96th Street, Indianapolis, Indiana 46240

Sams Teach Yourself Oracle PL/SQL in 10 Minutes

Copyright 2016 by Pearson Education, Inc.

All rights reserved. No part of this book shall be reproduced, stored in a retrieval system, or transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise, without written permission from the publisher. No patent liability is assumed with respect to the use of the information contained herein. Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors or omissions. Nor is any liability assumed for damages resulting from the use of the information contained herein.

ISBN-13: 978-0-672-32866-4
ISBN-10: 0-672-32866-6

Library of Congress Control Number: 2015910491

Printed in the United States of America

First Printing September 2015

Acquisitions Editor
Mark Taber

Managing Editor
Kristy Hart

Senior Project Editor
Betsy Gratner

Copy Editor
Paula Lowell

Indexer
Lisa Stumpf

Proofreader
Sarah Kearns

Editorial Assistant
Vanessa Evans

Cover Designer
Mark Shirar

Senior Compositor
Gloria Schurick

Trademarks

All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Sams Publishing cannot attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the validity of any trademark or service mark.

Warning and Disclaimer

Every effort has been made to make this book as complete and as accurate as possible, but no warranty or fitness is implied. The information provided is on an as is basis. The author and the publisher shall have neither liability nor responsibility to any person or entity with respect to any loss or damages arising from the information contained in this book or from the use of the programs accompanying it.

Special Sales

For information about buying this title in bulk quantities, or for special sales opportunities (which may include electronic versions; custom cover designs; and content particular to your business, training goals, marketing focus, or branding interests), please contact our corporate sales department at or (800) 382-3419.

For government sales inquiries, please contact .

For questions about sales outside the U.S., please contact .

Ben Forta has three decades of experience in the computer industry in product design and development, support, training, and marketing. As Adobe Inc.s Senior Director of Education Initiatives, he spends a considerable amount of time teaching, talking, and writing about Adobe products, coding and application development, creativity, and digital literacy and provides feedback to help shape the future direction of Adobe products.

Ben is the author of more than 40 books, including the worlds bestselling title on SQL, as well as titles on topics as diverse as Regular Expressions, mobile development, and Adobe ColdFusion. More than 750,000 copies of his books are in print in English, and titles have been translated into fifteen languages. Many of these titles are used as textbooks in colleges and universities worldwide.

Education is Bens passion. Between writing, lecturing, and in-classroom experience, Ben has dedicated his professional and personal lives to teaching, inspiring, and sharing his love for technology and creativity. He is immensely grateful to have had the opportunity to share with millions worldwide.

Ben is also a successful entrepreneur with experience creating, building, and selling start-ups. He is a sought-after public speaker, a writer, and a blogger, and he presents on education and development topics worldwide.

Its been sixteen years since the publication of my first book on SQL, Sams Teach Yourself SQL in 10 Minutes. That book was met with such positive feedback that it has been updated three times, has spawned four spin-off titles (the most recent being the book you are reading right now), and has been translated more than a dozen times. In all of its various flavors and iterations, this little book has helped hundreds of thousands learn the basics of SQL. So, first and foremost, thanks to all of you who have trusted me and this book over the years; your support is both incredibly humbling and a source of great pride.

I am blessed with some very vocal and opinionated readers who regularly share ideas, comments, suggestions, and occasionally criticism. These books continue to improve directly in response to that feedback, so thanks, and please keep it coming.

Thanks to the numerous schools and colleges the world over who have made this series part of their curriculum. Seeing students use my writing as part of their studies never ceases to thrill.

And finally, thanks to my partners at Pearson with whom Ive now published more than 40 titles, and without whose support none would have seen the light of day. In particular, thanks to Betsy Gratner for shepherding this book through the process, Paula Lowell for her editing help, and Mark Taber for once again patiently and encouragingly supporting whatever I toss his way.

Ben Forta

As the reader of this book, you are our most important critic and commentator. We value your opinion and want to know what were doing right, what we could do better, what areas youd like to see us publish in, and any other words of wisdom youre willing to pass our way.

We welcome your comments. You can email or write to let us know what you did or didnt like about this bookas well as what we can do to make our books better.

Please note that we cannot help you with technical problems related to the topic of this book.

When you write, please be sure to include this books title and author as well as your name and email address. We will carefully review your comments and share them with the author and editors who worked on the book.

Email:

Mail: Sams Publishing
ATTN: Reader Feedback