Simple examples of PL/SQL using Oracle's HR schema
Tuesday, May 19, 2009
Boolean Variables
If a boolean variable is not initialized it isn’t true or false. Use NVL to have it take the appropriate course.
Declare Bool_Var Boolean ; Begin If Not Nvl(Bool_Var,False) Then Dbms_Output.Put_Line('False or Not Initialized'); Else Dbms_Output.Put_Line('True'); End If; End; /
No comments:
Post a Comment