SQL> SQL> CREATE OR REPLACE PROCEDURE plsb (str IN VARCHAR2, bool IN BOOLEAN) 2 IS 3 BEGIN 4 IF bool 5 THEN 6 DBMS_OUTPUT.PUT_LINE (str || ' - TRUE'); 7 ELSIF NOT bool 8 THEN 9 DBMS_OUTPUT.PUT_LINE (str || ' - FALSE'); 10 ELSE 11 DBMS_OUTPUT.PUT_LINE (str || ' - NULL'); 12 END IF; 13 END plsb; 14 / SP2-0804: Procedure created with compilation warnings
21.13.Boolean | ||||
21.13.1. | BOOLEAN | |||
21.13.2. | Boolean literals | |||
21.13.3. | Boolean variables can be assigned either directly by using values TRUE, FALSE, or NULL or as the results of logical expressions | |||
21.13.4. | How to assign a TRUE value to a variable of type boolean | |||
21.13.5. | Use BOOLEAN type variable | |||
21.13.6. | Use 'and' to connect two boolean expressions | |||
21.13.7. | Demonstrates the effects of NULLs on Boolean expressions | |||
21.13.8. | Boolean type parameter | |||
21.13.9. | Exit when a boolean conditioin | |||
21.13.10. | Logic operator and boolean value |