Synopsis
This in-depth guide explains how to use SQL to work with data in a database, and how to automate complicated tasks using PL/SQL.
"synopsis" may belong to another edition of this title.
About the Author
Christopher Allen (Santa Monica, CA) has been a database professional for almost 20 ears. He is an OCP DBA and an OCP Application Developer and has worked on numerous Oracle Financials implementations. In addition, he has taught several hundred computer classes to adults, resulting in extensive experience communicating technical information in ways that are easy to absorb and easy to remember. His published works include the Oracle Certified Professional Application Developer Exam Guide (co-author, Oracle Press), Hard Disk Smarts (John Wiley Publishing), and four books on Lotus (Que). He also served as technical editor for Microsoft's DOS 5 and DOS 6 manuals. He is currently employed at Metier, an Oracle partner company that provides consulting services in the Los Angeles area.
From the Back Cover
Learn to use SQL and PL/SQL in your Oracle database.
Get step-by-step details on performing database tasks quickly and easily.
Oracle PL/SQL 101 explains how to use SQL to work with data in a database, and how to automate complicated tasks using PL/SQL. You¿ll learn by doing--each chapter contains hands-on exercises designed to teach the concepts presented. This easy-to-follow book starts with database basics and then teaches how to store, retrieve, and manipulate data, control SQL*Plus, create and use SQL functions, and write PL/SQL programs.
- Understand the key components of a database--tables, rows, records, columns, and fields
- Create database tables, indexes, and constraints
- Write SQL commands to insert, select, update, and delete data
- Perform advanced data manipulation
- Write complete PL/SQL functions and procedures
- Declare variables using anchored types
- Create PL/SQL packages
- Use triggers to enforce complex business rules and security measures
"About this title" may belong to another edition of this title.
Other Popular Editions of the Same Title
Search results for Oracle PL/SQL 101
Stock Image
Oracle PLSQL 101
Published by
McGraw-Hill Osborne Media, 2000
ISBN 10: 007212606X
ISBN 13: 9780072126068
Used
Softcover
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. Item in good condition and has highlighting/writing on text. Used texts may not contain supplemental items such as CDs, info-trac etc. Seller Inventory # 00084934460
Stock Image
Oracle PLSQL 101
Published by
McGraw-Hill Osborne Media, 2000
ISBN 10: 007212606X
ISBN 13: 9780072126068
Used
Softcover
Seller: World of Books (was SecondSale), Montgomery, IL, U.S.A.
Seller rating 5 out of 5 stars
Condition: Acceptable. Item in good condition. Textbooks may not include supplemental items i.e. CDs, access codes etc. Seller Inventory # 00064943448
Seller Image
Oracle PL/SQL 101
Published by
McGraw-Hill Osborne Media, 2000
ISBN 10: 007212606X
ISBN 13: 9780072126068
Used
Softcover
Seller: ZBK Books, Carlstadt, NJ, U.S.A.
Seller rating 5 out of 5 stars
Condition: good. Fast & Free Shipping â" Good condition with a solid cover and clean pages. Shows normal signs of use such as light wear or a few marks highlighting, but overall a well-maintained copy ready to enjoy. Supplemental items like CDs or access codes may not be included. Seller Inventory # ZWV.007212606X.G
Stock Image
Oracle PL/SQL 101
Published by
McGraw-Hill Osborne Media, 2000
ISBN 10: 007212606X
ISBN 13: 9780072126068
Used
Softcover
Seller: Wonder Book, Frederick, MD, U.S.A.
Seller rating 5 out of 5 stars
Condition: Good. . With remainder mark. Owner's name on edges Writing inside. Seller Inventory # A03F-00565
Stock Image
Oracle PL/SQL 101
Published by
McGraw-Hill Osborne Media, 2000
ISBN 10: 007212606X
ISBN 13: 9780072126068
Used
Paperback
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: As New. No Jacket. Pages are clean and are not marred by notes or folds of any kind. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G007212606XI2N00
Stock Image
Oracle PL/SQL 101
Published by
McGraw-Hill Osborne Media, 2000
ISBN 10: 007212606X
ISBN 13: 9780072126068
Used
Paperback
Seller: ThriftBooks-Atlanta, AUSTELL, GA, U.S.A.
Seller rating 5 out of 5 stars
Paperback. Condition: Good. No Jacket. Pages can have notes/highlighting. Spine may show signs of wear. ~ ThriftBooks: Read More, Spend Less. Seller Inventory # G007212606XI3N00
Stock Image
Oracle PL/SQL 101
Published by
McGraw-Hill Osborne, 2000
ISBN 10: 007212606X
ISBN 13: 9780072126068
Used
Softcover
First Edition
Seller: Better World Books: West, Reno, NV, U.S.A.
Seller rating 5 out of 5 stars
Condition: Very Good. 1st Edition. Former library book; may include library markings. Used book that is in excellent condition. May show signs of wear or have minor defects. Seller Inventory # 4287499-75
Stock Image
Oracle PL/SQL 101
Published by
McGraw-Hill Osborne, 2000
ISBN 10: 007212606X
ISBN 13: 9780072126068
Used
Softcover
First Edition
Seller: Better World Books, Mishawaka, IN, U.S.A.
Seller rating 5 out of 5 stars
Condition: Very Good. 1st Edition. Used book that is in excellent condition. May show signs of wear or have minor defects. Seller Inventory # 5856337-75
Stock Image
Oracle PL/SQL 101 (Oracle Press Series)
Seller: AwesomeBooks, Wallingford, United Kingdom
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. Oracle PL/SQL 101 (Oracle Press Series) This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Seller Inventory # 7719-9780072126068
Buy Used
US$ 23.72
Shipping:
US$ 6.66
From United Kingdom to U.S.A.
Quantity: 2 available
Stock Image
Oracle PL/SQL 101 (Oracle Press Series)
Seller: Bahamut Media, Reading, United Kingdom
Seller rating 5 out of 5 stars
Paperback. Condition: Very Good. This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Seller Inventory # 6545-9780072126068
Buy Used
US$ 23.72
Shipping:
US$ 9.32
From United Kingdom to U.S.A.
Quantity: 1 available