Chapter Eleven. PL/SQL Language Features
11.1 COMMENTS
11.2 ASSIGNMENTS AND STATEMENTS
11.3 BOOLEAN EXPRESSION
11.5 LOGICAL OPERATORS
11.6 STRING CONCATENATION
11.9 TYPES
11.9.1 Boolean
11.9.2 Scalar Types
11.9.3 Records
11.9.4 %ROWTYPE
11.9.5 Index-By Tables
11.9.6 Varrays and Nested Tables
11.9.7 Objects
11.9.8 Large Objects (LOBs)
11.10 IF STATEMENT
11.10.1 Simple IF
11.10.2 If-Then-Else
11.10.3 If-Then-Elsif with Else
11.10.4 If-Then-Elsif No Else
11.10.5 Statement Expressions
11.10.6 Use DECODE and CASE in SQL
11.11 CASE STATEMENT
11.11.1 Searched CASE Statement
11.11.2 CASE with Selector
11.11.3 Using CASE within the SELECT
11.11.4 Using DECODE within the SELECT
11.12 LOOP
11.12.1 DO ...
Get Programming Oracle® Triggers and Stored Procedures, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.