Computers & Technology
Home Computing
Business & Culture
Programming
Software
Web Development
Certification
Networking
Security & Encryption
Computer Science
Operating Systems
Microsoft
Hardware
Databases
Graphic Design
Apple
Digital Music
Digital Photography & Video
Games & Strategy Guides
Project Management
Mobile & Wireless Computing
Education & Reference
Encyclopedias
Test Preparation
Studying & Workbooks
Schools & Teaching
Writing, Research & Publishing Guides
Foreign Language Study & Reference
Atlases & Maps
Dictionaries & Thesauruses
Words, Language & Grammar
College & University
Trivia & Fun Facts
Consumer Guides
Business & Investing
Industries & Professions
Management & Leadership
Organizational Behavior
Personal Finance
Small Business & Entrepreneurship
Popular Economics
Marketing & Sales
Finance
Skills
Business Life
Economics
Job Hunting & Careers
Biography & History
Reference
International
Real Estate
Investing
Women & Business
Science & Math
Mathematics
Technology
Reference
Earth Sciences
Physics
Biological Sciences
Behavioral Sciences
Nature & Ecology
Astronomy & Space Science
History & Philosophy
Experiments, Instruments & Measurement
Agricultural Sciences
Table of content
Oracle PL. SQL Interactive Workbook
Authors:
Rosenzweig B.
,
Silvestrova E
Published year: 2002
Pages: 1/146
Buy this book on amazon.com >>
1
2
Main
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
1
2
Oracle PL. SQL Interactive Workbook
Authors:
Rosenzweig B.
,
Silvestrova E
Published year: 2002
Pages: 1/146
Buy this book on amazon.com >>
Book categories
Computers & Technology
Programming
Languages & Tools
Databases
Oracle (18)
Education & Reference
Science & Math
Mathematics (121)