![](https://csdnimg.cn/release/download_crawler_static/10479084/bg13.jpg)
xix
2–53 Searched CASE Expression with WHEN ... IS NULL ........................................................ 2-40
2–54 Predefined Inquiry Directives $$PLSQL_LINE and $$PLSQL_UNIT ............................. 2-45
2–55 Displaying Values of PL/SQL Compilation Parameters ................................................... 2-45
2–56 PLSQL_CCFLAGS Assigns Value to Itself........................................................................... 2-46
2–57 Static Constants ........................................................................................................................ 2-49
2–58 Code for Checking Database Version ................................................................................... 2-50
2–59 Compiling Different Code for Different Database Versions ............................................. 2-51
2–60 Displaying Post-Processed Source Textsource text............................................................. 2-52
3–1 CHAR and VARCHAR2 Blank-Padding Difference ............................................................. 3-6
3–2 Printing BOOLEAN Values....................................................................................................... 3-7
3–3 PLS_INTEGER Calculation Raises Overflow Exception....................................................... 3-8
3–4 Preventing Example 3–3 Overflow........................................................................................... 3-9
3–5 Violating Constraint of SIMPLE_INTEGER Subtype......................................................... 3-10
3–6 User-Defined Unconstrained Subtypes Show Intended Use............................................. 3-12
3–7 User-Defined Constrained Subtype Detects Out-of-Range Values.................................. 3-13
3–8 Implicit Conversion Between Constrained Subtypes with Same Base Type .................. 3-13
3–9 Implicit Conversion Between Subtypes with Base Types in Same Family ..................... 3-14
4–1 IF THEN Statement..................................................................................................................... 4-2
4–2 IF THEN ELSE Statement .......................................................................................................... 4-3
4–3 Nested IF THEN ELSE Statements........................................................................................... 4-4
4–4 IF THEN ELSIF Statement......................................................................................................... 4-5
4–5 IF THEN ELSIF Statement Simulates Simple CASE Statement ........................................... 4-6
4–6 Simple CASE Statement............................................................................................................. 4-7
4–7 Searched CASE Statement ......................................................................................................... 4-8
4–8 EXCEPTION Instead of ELSE Clause in CASE Statement.................................................... 4-8
4–9 Basic LOOP Statement with EXIT Statement....................................................................... 4-10
4–10 Basic LOOP Statement with EXIT WHEN Statement......................................................... 4-10
4–11 Nested, Labeled Basic LOOP Statements with EXIT WHEN Statements........................ 4-11
4–12 Nested, Unabeled Basic LOOP Statements with EXIT WHEN Statements..................... 4-11
4–13 CONTINUE Statement in Basic LOOP Statement .............................................................. 4-12
4–14 CONTINUE WHEN Statement in Basic LOOP Statement ................................................ 4-13
4–15 FOR LOOP Statements............................................................................................................ 4-14
4–16 Reverse FOR LOOP Statements............................................................................................. 4-15
4–17 Simulating STEP Clause in FOR LOOP Statement ............................................................. 4-15
4–18 FOR LOOP Statement Tries to Change Index Value .......................................................... 4-16
4–19 Outside Statement References FOR LOOP Statement Index............................................. 4-16
4–20 FOR LOOP Statement Index with Same Name as Variable .............................................. 4-17
4–21 FOR LOOP Statement References Variable with Same Name as Index .......................... 4-17
4–22 Nested FOR LOOP Statements with Same Index Name.................................................... 4-18
4–23 FOR LOOP Statement Bounds............................................................................................... 4-18
4–24 Specifying FOR LOOP Statement Bounds at Run Time..................................................... 4-19
4–25 EXIT WHEN Statement in FOR LOOP Statement .............................................................. 4-19
4–26 EXIT WHEN Statement in Inner FOR LOOP Statement.................................................... 4-19
4–27 CONTINUE WHEN Statement in Inner FOR LOOP Statement....................................... 4-20
4–28 WHILE LOOP Statements ...................................................................................................... 4-21
4–29 GOTO Statement...................................................................................................................... 4-22
4–30 Incorrect Label Placement....................................................................................................... 4-22
4–31 GOTO Statement Goes to Labeled NULL Statement.......................................................... 4-23
4–32 GOTO Statement Transfers Control to Enclosing Block .................................................... 4-23
4–33 GOTO Statement Cannot Transfer Control into IF Statement .......................................... 4-23
4–34 NULL Statement Showing No Action .................................................................................. 4-24
4–35 NULL Statement as Placeholder During Subprogram Creation....................................... 4-25
4–36 NULL Statement in ELSE Clause of Simple CASE Statement .......................................... 4-25
5–1 Associative Array Indexed by String ....................................................................................... 5-4
5–2 Function Returns Associative Array Indexed by PLS_INTEGER ....................................... 5-5