Flylib.com
Oracle PL/SQL Interactive Workbook (2nd Edition)
Oracle PL/SQL Interactive Workbook (2nd Edition)
ISBN: 0130473200
EAN: 2147483647
Year: 2002
Pages: 146
Authors:
Benjamin Rosenzweig
,
Elena Silvestrova
BUY ON AMAZON
Main
TOC
Copyright
THE PRENTICE HALL PTR ORACLE SERIES
Acknowledgments
Acknowledgments from Ben Rosenzweig
Acknowledgments from Elena Silvestrova
About the Authors
Introduction
Who This Book Is For
How This Book Is Organized
About The Companion Web Site
What You Will Need
Using SQLPlus
Conventions Used In This Book
About Prentice Hall Professional Technical Reference
Chapter 1. Programming Concepts
Lab 1.1 The Nature of a Computer Program and Programming Languages
Lab 2.1 Good Programming Practices
Chapter 1 Test Your Thinking
Chapter 2. PLSQL Concepts
Lab 2.1 PLSQL In Client-Server Architecture
Lab 2.2 PLSQL in SQLPlus
Chapter 2 Test Your Thinking
Chapter 3. General Programming Language Fundamentals
Lab 3.1 PLSQL Programming Fundamentals
Chapter 3 Test Your Thinking
Chapter 4. SQL in PLSQL
Lab 4.1 Making Use of DML in PLSQL
Lab 4.2 Making Use of SAVEPOINT
Chapter 4 Test Your Thinking
Chapter 5. Conditional Control: IF Statements
Lab 5.1 IF Statements
Lab 5.2 ELSIF Statements
Lab 5.3 Nested IF Statements
Chapter 5 Test Your Thinking
Chapter 6. Conditional Control: Case Statements
Lab 6.1 CASE Statements
Lab 6.2 CASE Expressions
Lab 6.3 NULLIF and COALESCE Functions
Chapter 6 Test Your Thinking
Chapter 7. Error Handling and Built-In Exceptions
Lab 7.1 Handling Errors
Lab 7.2 Built-In Exceptions
Chapter 7 Test Your Thinking
Chapter 8. Iterative Control
Lab 8.1 Simple Loops
LAB 8.2 WHILE Loops
Lab 8.3 Numeric for Loops
Lab 8.4 Nested Loops
Chapter 8 Test Your Thinking
Chapter 9. Introduction to Cursors
Lab 9.1 Cursor Manipulation
Lab 9.2 Using Cursor for Loops and Nesting Cursors
Chapter 9 Test Your Thinking
Chapter 10. Exceptions
Lab 10.1 Exception Scope
Lab 10.2 User-Defined Exceptions
Lab 10.3 Exception Propagation
Chapter 10 Test Your Thinking
Chapter 11. Exceptions: Advanced Concepts
Lab 11.1 RAISE_APPLICATION_ERROR
Lab 11.2 EXCEPTION_INIT Pragma
Lab 11.3 SQLCODE and SQLERRM
Chapter 11 Test Your Thinking
Chapter 12. Procedures
PLSQL Stored Code
Lab 12.1 Creating Procedures
Lab 12.2 Passing Parameters In and Out of Procedures
Chapter 12 Test Your Thinking
Chapter 13. Functions
Lab 13.1 Creating and Using Functions
Chapter 13 Test Your Thinking
Chapter 14. Packages
Lab 14.1 The Benefits of Utilizing Packages
Chapter 14 Test Your Thinking
Chapter 15. Advanced Cursors
Lab 15.1 Using Parameters with Cursors and for Update Cursors
Lab 15.2 Cursor Variables
Chapter 16. Stored Code
Lab 16.1 Gathering Stored Code Information
Chapter 16 Test Your Thinking
Chapter 17. Triggers
Lab 17.1 What Triggers Are
Lab 17.2 Types of Triggers
Lab 17.3 Mutating Table Issues
Chapter 17 Test Your Thinking
Chapter 18. Collections
Lab 18.1 PLSQL Tables
Lab 18.2 Varrays
Lab 18.3 Multilevel Collections
Chapter 18 Test Your Thinking
Chapter 19. Records
Lab 19.1 Records
Lab 19.2 Nested Records
Lab 19.3 Collections of Records
Chapter 19 Test Your Thinking
Appendix A. Answers to Self-Review Questions
Chapter 1 Programming Concepts
Chapter 2 PLSQL Concepts
Chapter 3 General Programming Language Fundamentals
Chapter 4 SQL in PLSQL
Chapter 5 Conditional Control: IF Statements
Chapter 6 Conditional Control: CASE Statements
Chapter 7 Error Handling and Built-In Exceptions
Chapter 8 Iterative Control
Chapter 9 Introduction to Cursors
Chapter 10 Exceptions
Chapter 11 Exceptions: Advanced Concepts
Chapter 12 Procedures
Chapter 13 Functions
Chapter 14 Packages
Chapter 15 Advanced Cursors
Chapter 16 Stored Code
Chapter 17 Triggers
Chapter 18 Collections
Chapter 19 Records
Appendix B. PLSQL Formatting Guide
PLSQL Code Naming Conventions and Formatting Guidelines
Other Suggestions
Appendix C. Student Database Schema
Table and Column Descriptions
Appendix D. Answers to Test Your Thinking Sections
Chapter 1 Programming Concepts
Chapter 2 PLSQL Concepts
Chapter 3 General Programming Language Fundamentals
Chapter 4 SQL in PLSQL
Chapter 5 Conditional Control: IF Statements
Chapter 6 Conditional Control: CASE Statements
Chapter 7 Error Handling and Built-In Exceptions
Chapter 8 Iterative Control
Chapter 9 Introduction to Cursors
Chapter 10 Exceptions
Chapter 11 Exceptions: Advanced Concepts
Chapter 12 Procedures
Chapter 13 Functions
Chapter 14 Packages
Chapter 15 Stored Code
Chapter 17 Triggers
Chapter 18 Collections
Chapter 19 Records
Appendix E. Oracle 9i SQL New Features
SQL Standards
JOINs
Scalar Subquery
Oracle PL/SQL Interactive Workbook (2nd Edition)
ISBN: 0130473200
EAN: 2147483647
Year: 2002
Pages: 146
Authors:
Benjamin Rosenzweig
,
Elena Silvestrova
BUY ON AMAZON
CISSP Exam Cram 2
BUSINESS CONTINUITY PLANNING
How to Prepare for the Exam
Physical Security
Single Sign-On
Answers to Exam Prep Questions
Making Sense of Change Management: A Complete Guide to the Models, Tools and Techniques of Organizational Change
Team change
Leading change
Mergers and acquisitions
Cultural change
IT-based process change
101 Microsoft Visual Basic .NET Applications
Working with Console Applications
Working with the .NET Framework
Advanced .NET Framework
Coding Conventions
Windows Server 2003 for .NET Developers
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 225 Outside Branch Circuits and Feeders
Article 312 Cabinets, Cutout Boxes, and Meter Socket Enclosures
Article 374 Cellular Metal Floor Raceways
Article 408: Switchboards and Panelboards
Example No. D4(b) Optional Calculation for Multifamily Dwelling
HTI+ Home Technology Integrator & CEDIA Installer I All-In-One Exam Guide
Computer Network Basics
Computer Network Hardware
Distributed Audio System Basics
Home Communication System Basics
Troubleshooting and Maintaining a Home Security System
MPLS Configuration on Cisco IOS Software
Unicast IP Forwarding in Traditional IP Networks
RIPv2 PE-CE Routing Overview, Configuration, and Verification
Case Study-Hub and Spoke MPLS VPN Network with Sites Using Same AS Numbers
CSC Architecture Benefits
Case Study 2: Implementing Multi-VRF CE, VRF Selection Using Source IP Address, VRF Selection Using Policy-Based Routing, NAT and HSRP Support in MPLS VPN, and Multicast VPN Support over Multi-VRF CE
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies