Oracle PL/SQL For Dummies

Handbook, Oracle JDeveloper 3 Handbook, Oracle Designer Handbook (2 editions), Oracle Forms Developer and Reports: Advanced Techniques and ….

More PDF Content

Oracle PL/SQL FOR DUMmIES by Michael Rosenblum and Dr. Paul Dorsey
 Part I Basic PL/SQL Concepts 7. Chapter 1. PL/SQL and Your Database 9. Chapter 2. The PL/SQL Environment 23. Part II Getting Started with PL/SQL 39. Chapter 3. Laying the Groundwork PL/SQL Fundamentals 41. Chapter 4. Controlling Program Flow 85. Chapter 5. Handling Exceptions 105. Chapter 6. PL/SQL and SQL Working Together127. Part III Standards and Structures 163. Chapter 7. Putting Your Code in the Right Place165. Chapter 8. Creating Naming Standards 187. Chapter 9. Creating Coding Standards 201. Part IV PL/SQL Data Manipulations 219. Chapter 10. Basic Datatypes 221. Chapter 11. Advanced Datatypes 253. Part V Taking PL/SQL to the Next Level289. Chapter 12. Transaction Control 291. Chapter 13. Dynamic SQL and PL/SQL 313. Chapter 14. PL/SQL Best Practices 335. Part VI The Part of Tens 355. Chapter 15. Ten PL/SQL Tips 357. Chapter 16. Ten Common Mistakes to Avoid in PL/SQL377. Index 397. Table of Contents Introduction 1. About This Book1. Foolish Assumptions 2. How This Book Is Organized2. Part I Basic PL/SQL Concepts 2. Part II Getting Started with PL/SQL3. Part III Standards and Structures 3. Part IV PL/SQL Data Manipulations 3. Part V Taking PL/SQL to the Next Level 3. Part VI The Part of Tens 4. Icons Used in This Book4. Where to Go from Here4. Part I Basic PL/SQL Concepts7. Chapter 1. PL/SQL and Your Database 9. Knowing Just Enough about Relational Databases9. What makes a database relational 10. Understanding basic database terminology 12. Introducing database normalization13. What is a DBMS 16. The Scoop on SQL and PL/SQL16. The purpose of SQL and PL/SQL 17. The difference between SQL and PL/SQL18. Whats new in Oracle SQL and PL/SQL 18. What Is PL/SQL Good For 19. Using database triggers 19. Scripting with speed 20. Keeping code serverside 20. Programming for Oracle Developer 21. Chapter 2. The PL/SQL Environment 23. Setting Up an Oracle Environment23. Hardware and Software Requirements25. Accessing the Oracle Technology Network 26. Installing the Database 27. Working with Code28. SQLPlus28. Oracle SQL Developer30. Thirdparty tools 30. x Oracle PL/SQL For Dummies Establishing a Database Connection 31. Checking the operating services 32. Connecting with your username 32. Unlocking or locking accounts 33. Resetting passwords 33. Setting up the server to communicate 34. The Basics of PL/SQL Programs34. Writing a simple program34. Creating stored procedures 36. Passing parameters to procedures 36. Examining the Sample Data 37. The ScottTiger schema 37. The Human Resources HR and Order Entry OE schemas38. Part II Getting Started with PL/SQL39. Chapter 3. Laying the Groundwork PL/SQL Fundamentals 41. PL/SQL As a Programming Language 41. Anonymous PL/SQL Blocks42. Introducing the Lexical Set of Elements43. Identifiers 44. Delimiters 44. Literals 45. Comments 45. Working with Constants and Variables46. Declaring variables46. Assigning values to variables 48. Literals as variable values49. Understanding the scope of variables51. Building Expressions with Operators53. Running Anonymous Blocks of Code56. Identifying common mistakes56. Spotting compilation errors57. Recognizing semicolonrelated errors 57. Creating Reusable PL/SQL Code 59. Wrapping a task into a procedure 59. Returning values with functions61. Parameters of subprograms 63. Storing PL/SQL in the Database 67. Database procedures and functions 68. Packages 69. Triggers71. Interpreting and fixing compilation errors73. Table of Contents Checking Out PL/SQL Extras 76. Overloading calls76. Resolving calls to subprograms 78. Recursion 80. Compiler hints and directives 82. Builtin packages 83. xi. Chapter 4. Controlling Program Flow 85. Creating Condition Statements 85. IFTHEN statements 86. IFELSE statements 87. CASE statements89. Comparing with NULL91. Handling conditions 95. Looping the Loop 97. Simple loops97. Nested loops 99. WHILE loop100. FOR loop 102. Chapter 5. Handling Exceptions 105. Understanding Exception Basics 106. Adding Exception Handlers to Your Code 107. Understanding Different Exception Types110. Predefined Exceptions in PL/SQL Code111. Adding UserDefined Exceptions114. Assigning a code to a userdefined exception 115. Including error messages in userdefined exceptions 116. Propagation of Exceptions 118. Seeing propagation of exceptions in action118. Handling exceptions without halting the program 122. Avoiding exceptions raised in declaration part and exception handler 124. Writing Exceptional Exceptions 126. Chapter 6. PL/SQL and SQL Working Together 127. Cursors What They Are and How to Use Them 128. Returning more than one piece of information 129. Looping through multiple records 132. Placing cursors in nested loops 133. Passing parameters to cursors134. Knowing Where to Declare Cursors137. Defining cursors in the header of the program unit 138. Defining cursors in the local PL/SQL block138. Defining cursors in the package body 139. Defining cursors in the package spec 140. xii Oracle PL/SQL For Dummies Being Explicitly Smart with Implicit Cursors142. Retrieving a single row The basic syntax142. Handling exceptions in implicit cursors 143. Returning an implicit cursor into a record 143. Accessing Status Info by Using Cursor Variables144. Checking the status of explicit cursors 145. Checking the status of implicit cursors146. Updating Records Fetched from Cursors148. Using a simple UPDATE statement148. Updating with logical operators148. Taking a Shortcut with CURSOR FOR Loops150. Comparing CURSOR FOR loops to cursors with the LOOP command150. When do CURSOR FOR loops simplify exception handling152. When CURSOR FOR loops make your life harder153. Knowing what record is processing155. Referencing Functions in SQL155. Important facts to remember157. Getting good performance with functions 160. Part III Standards and Structures 163. Chapter 7. Putting Your Code in the Right Place 165. Putting Code in the Database 165. Managing code166. Packaging code in the database 166. Placing triggers on tables174. Building INSTEAD OF trigger views177. Advantages of putting code in the database 182. Disadvantages of putting code in the database 182. Putting Code in the Application Server MiddleTier Approach 183. Advantages of the middletier approach184. Disadvantages of the middletier approach184. Placing code in the view layer 185. Where Should You Place the Business Logic 185. Chapter 8. Creating Naming Standards 187. Whats in a Naming Standard 187. Oracle database influences 188. Java influences188. Modern application development tools and their influences189. Setting Naming Standards for Common Code Elements 189. Basic objects 190. Variables 191

Download Oracle PL/SQL For Dummies pdf from phoenixalley.com, 435 pages, 7305.82KB.