Oracle PL/SQL for dummies
Find tips for creating efficient PL/SQL code If you know a bit about SQL, this book will make PL/SQL programming painless! The Oracle has spoken-you need to get up to speed on PL/SQL programming, right? We predict it'll be a breeze with this book! You'll find out about code structures, bes...
| Otros Autores: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Hoboken, N.J. :
Wiley
c2006.
|
| Edición: | 1st edition |
| Colección: | --For dummies.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627567106719 |
Tabla de Contenidos:
- Oracle PL/SQL For Dummies; About the Authors; Dedications; Authors' Acknowledgments; Contents at a Glance; Table of Contents; Introduction; About This Book; Foolish Assumptions; How This Book Is Organized; Icons Used in This Book; Where to Go from Here; Part I: Basic PL/SQL Concepts; Chapter 1: PL/SQL and Your Database; Knowing Just Enough about Relational Databases; The Scoop on SQL and PL/SQL; What Is PL/SQL Good For?; Chapter 2: The PL/SQL Environment; Setting Up an Oracle Environment; Hardware and Software Requirements; Accessing the Oracle Technology Network; Installing the Database
- Working with CodeEstablishing a Database Connection; The Basics of PL/SQL Programs; Examining the Sample Data; Part II: Getting Started with PL/SQL; Chapter 3: Laying the Groundwork: PL/SQL Fundamentals; PL/SQL As a Programming Language; Anonymous PL/SQL Blocks; Introducing the Lexical Set of Elements; Working with Constants and Variables; Building Expressions with Operators; Running Anonymous Blocks of Code; Creating Reusable PL/SQL Code; Storing PL/SQL in the Database; Checking Out PL/SQL Extras; Chapter 4: Controlling Program Flow; Creating Condition Statements; Looping the Loop
- Chapter 5: Handling ExceptionsUnderstanding Exception Basics; Adding Exception Handlers to Your Code; Understanding Different Exception Types; Predefined Exceptions in PL/SQL Code; Adding User-Defined Exceptions; Propagation of Exceptions; Writing Exceptional Exceptions; Chapter 6: PL/SQL and SQL Working Together; Cursors: What They Are and How to Use Them; Knowing Where to Declare Cursors; Being Explicitly Smart with Implicit Cursors; Accessing Status Info by Using Cursor Variables; Updating Records Fetched from Cursors; Taking a Shortcut with CURSOR FOR Loops; Referencing Functions in SQL
- Part III: Standards and StructuresChapter 7: Putting Your Code in the Right Place; Putting Code in the Database; Putting Code in the Application Server (Middle-Tier Approach); Where Should You Place the Business Logic?; Chapter 8: Creating Naming Standards; What's in a Naming Standard?; Setting Naming Standards for Common Code Elements; Making Sure Your Organization Follows Standards; Chapter 9: Creating Coding Standards; Why Standards Are Important; Universal Truths; Developing SQL Code Consistently; Part IV: PL/SQL Data Manipulations; Chapter 10: Basic Datatypes
- Introducing the Main Datatype GroupsWorking with Numeric Datatypes; Keeping Track of Date and Time; Storing Logical Values with BOOLEAN; Processing Characters and Strings; Chapter 11: Advanced Datatypes; Handling Large Objects in the Database; Working with Large Objects; Keeping Code Consistent with User-Defined Subtypes; Defining Your Own Datatypes; Grouping Sets of Data into Collections; Speeding Up Data Collection with Bulk Operations; Part V: Taking PL/SQL to the Next Level; Chapter 12: Transaction Control; Using Transactions to Maintain Data Consistency
- Committing or Rolling Back Changes to the Database
