Description: Item specificsCondition:Good : Seller Notes:“Paperback in Good condition”Format:Trade PaperbackPublisher:Prentice Hall PTRPublication Year:2000Language:EnglishISBN:9780130157430EAN:9780130157430About this productProduct InformationPart of the PH PTR Interactive's ground-breaking Interactive Workbook Series. This is the first of four entries in the Oracle Interactive Workbook Series. This book focuses on PL/SQL. PL/SQL is a programming language used in Oracle Tools (such as Oracle Developer) and in the database itself as stored procedures. It is essential for oracle DBAs and Oracle Developers to learn this language to work in the Oracle environment.Product IdentifiersPublisherPrentice Hall PTRISBN-100130157430ISBN-139780130157430eBay Product ID (ePID)1615114Product Key FeaturesFormatTrade PaperbackPublication Year2000LanguageEnglishDimensionsWeight32.2 OzWidth7in.Height1.2in.Length9.2in.Additional Product FeaturesDewey Edition21Table of ContentCONTENTS (NOTE: All chapters conclude with Test Your Thinking.) 1. Programming Concepts. The Nature of a Computer Program. Good Programming Practices. 2. PL/SQL Concepts. PL/SQL in Client-Server Architecture. PL/SQL in SQL*Plus. 3. General Programming Language Fundamentals. PL/SQL Programming Fundamentals. 4. SQL in PL/SQL. Making use of DML in PL/QL. Making Use of Savepoint. 5. Conditional Control. IF Satements. ELSIF Statements. Nested IF Statements. 6. Exception Handling and Built-In Exceptions. Handling Errors. Built-In Exceptions. 7. Iterative Control. Simple Loops. WHILE Loops. Numeric FOR Loops. Nested Loops. 8. Introduction to Cursors. Cursor Manipulation. Using Cursor FOR Loops and Nesting Cursors. Using PARAMETERS with Cursors. 9. Exceptions. Exception Scope. USER-DEFINED Exceptions. Exception Propagation. 10. Exceptions: Advanced Concepts. RAISE_APPLICATION_ERROR. EXCEPTION_INIT pragma. SQLCODE and SQLERRM. 11. Procedures. Creating Procedures. Passing Parameters IN and OUT of Procedures. 12. Functions. Creating and Using Functions. 13. Packages. The Benefits of Utilizing Packages. 14. Stored Code. Advanced Features of Stored Code. 15. Triggers. What Triggers Are. Types of Triggers. Mutating Table Issues. 16. PL/SQL Tables. Making Use of PL/SQL Tables. Appendix A: Answers to Self-Review Questions. Appendix B: PL/SQL Formatting Guide. Appendix C: Student Database Scheme. Index.Dewey Decimal005.75/65IllustratedYesAge LevelScholarly & ProfessionalSeriesThe Prentice Hall Ptr Oracle Ser.Copyright Date2000AuthorDouglas Scherer, Elena Silvestrova, Benjamin RosenweigNumber of Pages447 PagesLc Classification NumberQa76.73.P258r67 2000Lccn00-021909
Price: 11 USD
Location: Flushing, New York
End Time: 2024-11-19T17:03:39.000Z
Shipping Cost: N/A USD
Product Images
Item Specifics
All returns accepted: ReturnsNotAccepted
