Oracle PL/SQL strategy

Original Title: Oracle and PL/SQL recipes: a problem-solution approach Author: (US) Josh Juneau Matt arena Translator: Political Commissar Name: turing Program Design Series Press: People's post and telecommunications Press ISBN: 9787115320766 Release Date: June 2013 publication date: 16 open pages: 376 versions: 1-1 category: computer> database> Oracle more about "Oracle PL/SQL Raiders" content Introduction computer books "Oracle PL/SQL Raiders" is PL/SQL all kinds of crux of the cure. The book is divided into 17 chapters, respectively introducing different PL/SQL aspects, including basic PL/SQL knowledge, common SQL tasks, triggers, exception handling, Oracle SQL developer, analysis and performance improvement. The organizational structure of this book is unique. The entire article uses the form of "problem-solution-Principle Analysis. Each section describes an actual case. The content is self-contained and independent from each other. PL/SQL is an extension of the SQL language in Oracle databases. It opens the door to centralized business logic in databases. With PL/SQL, Many of Oracle's latest features have emerged. PL/SQL is also the cornerstone of a very successful Oracle Application Express. Both authors of this book have over 20 years of experience in database application development and are familiar with various problems related to Oracle database operations using PL/SQL. In this book, the author summarizes his years of practical experience as a specific case and introduces how to solve the problem through the form of "problem-Principle Analysis-solution. This book has a unique organizational structure and its content comes from a simple perspective. Readers only need to browse directories to find out the problems you are facing and slightly modify the relevant code to solve them. Oracle PL/SQL strategy can lead new users into the PL/SQL world, and can also help professionals invincible in the PL/SQL world. Directory Oracle PL/SQL raiders chapter 1st PL/SQL basics 11.1 create code blocks 1 problem 1 solution 1 Principle Analysis 11.2 execute code blocks in SQL * Plus 2 problem 2 solution 2 Principle analysis 21.3 Save the code to the script 3 problem 3 solution 3 Principle Analysis 31.4 execute the script 4 Problem 4 solution 4 Principle Analysis 41.5 accept user keyboard input 5 Problem 5. solution 5 Principle Analysis 51.6 result 7 in SQL * Plus 7 problem 7 solution 7 Principle Analysis 71.7 Add comment in code 8 problem 8 solution 8 Principle Analysis 81.8 reference code block 9 Problem 9 solution 9 Principle Analysis 91.9 reference variable 10 from nested blocks 10 problem 10 solution 10 Principle Analysis 111.10 ignore replacement variable 11 problem 11 solution 1 11 solution 2 11 Principle Analysis 121.11 change replace variable character 12 Problem 12 solution 13 Principle Analysis 131.12 create a variable that matches the database column type 13 problem 13 solution 13 principle analysis 14 chapter 14 Basic SQL operations 2nd retrieve single row data from the database 15 problem 15 solution 1 15 solution 2 16 Principle Analysis 172.2 limiting column names and variable names 18 problem 18 solution 18 Principle Analysis 192.3 declaring variable types matching column types 19 problem 19 Solution solution 19 Principle Analysis 202.4 return query results to PL/SQL records 20 problem 20 solution 20 Principle Analysis 212.5 create custom records to receive query results 21 problem 21 solution 22 Principle Analysis 222.6 loop traversal query row result 23 problem 23 Solution 1 23 solution 2 23 Principle Analysis 242.7 obtain environment and session information 24 problem 24 Solution 24 Principle Analysis 252.8 format query result 27 Problem 27 solution 27 Principle Analysis 282.9 update query returned result row 28 problem 28 solution 28 Principle Analysis 292.10 update the row result returned by the cursor 30 problem 30 solution 30 Principle Analysis 312.11 Delete the row result returned by the cursor 31 problem 31 solution 31 Principle Analysis 322.12 execute transaction 32 problem 32 solution 32 Principle Analysis 332.13 ensure that the same data is "visible" for multiple queries 34 problem 34 solution 34 Principle Analysis 342.14 engage in executing another independent transaction 35 problem 35 solution 35 Principle Analysis 362.15 locate and delete duplicate row data 37 problem 37 solution 37 principle analysis 38 chapter 3rd cycle and logic 393.1 select to execute code timing 39 problem 39 solution 39 Principle Analysis 403.2 choice between two mutex conditions 40 problem 40 solution 40 Principle Analysis 413.3 multiple mutex conditions value 41 problem 41 solution 1 41 solution 2 42 Principle Analysis 433.4 expression with multiple output results 44 problem 44 solution 44 Principle Analysis 453.5 cycle until the specified conditions are met 45 problem 45 solution 45 Principle Analysis 463.6 traversal of cursor results until all row results are returned 46 problem 46 solution 46 Principle Analysis 473.7 cycle until condition is false 47 problem 47 solution 47 Principle Analysis 483.8 skip current loop iteration 48 problem 48 solution 48 Principle Analysis 493.9 iterations fixed times 50 problem 50 solution 50 Principle Analysis 503.10 reverse iteration 51 problem 51 solution 51 Principle Analysis 513.11 specify other cycles incremental 52 problem 52 solution 52 Principle Analysis 523.12 use odd numbers level traversal 52 problem 52 solution 53 Principle Analysis 533.13 exit outer loop 53 problem 53 solution 53 Principle Analysis 543.14 jump to the specified position in the Code 55 problem 55 solution 55 Principle Analysis 56 chapter 4th function, process, and package 574.1 create storage function 57 problem 57 solution 57 Principle Analysis 584.2 execute storage function 60 problem 60 solution 61 Principle Analysis 61