Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

pl sql if boolean

set serveroutput on

declare
  true_value boolean := true;
  false_value boolean := false;
  null_value boolean;
begin

    if not true_value then  --Should not pass
      dbms_output.put_line('True Value');
    end if;

    if not false_value then --Should pass
      dbms_output.put_line('False Value');
    end if;

    if null_value is null then --Just to make sure it is null
      dbms_output.put_line('Null Value is Null');
    end if;

    if not null_value then --Should not pass
      dbms_output.put_line('Null Value');
    end if;
end;
/
Source by stackoverflow.com #
 
PREVIOUS NEXT
Tagged: #pl #sql #boolean
ADD COMMENT
Topic
Name
3+5 =