Search
 
SCRIPT & CODE EXAMPLE
 

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;
/
Comment

PREVIOUS NEXT
Code Example
Sql :: make selected text uppercase mssql 
Sql :: mysql uuid 
Sql :: how to dump .csv file into mysql 
Sql :: delete from table where length sql 
Sql :: mysqldump password in file 
Sql :: update query in sql 
Sql :: postrgesql concat 2 columns divided by ; 
Sql :: mysql dump structure only 
Sql :: local sql server 
Sql :: sql max count 
Sql :: difference between left outer join and left join in sql 
Sql :: sql query print strings and int 
Sql :: select only columns that are not empty oracle sql 
Sql :: insert into table sql 
Sql :: creating a database sql 
Sql :: sql like with multiple values 
Sql :: foreign key sql 
Sql :: mariadb check constraint example? 
Sql :: tables in sql 
Sql :: find the names of sailors who have reserved at least one boat 
Sql :: sql select without column name 
Sql :: Join multiple table by MySQL 
Sql :: com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client 
Sql :: mysql error 1452 
Sql :: insert sql 
Sql :: ORA-06502: PL/SQL: numeric or value error: character string buffer too small 
Sql :: sql logo 
Sql :: query params sql insert python f string 
Sql :: online compiler for sql plus 
Sql :: sql select all 
ADD CONTENT
Topic
Content
Source link
Name
3+9 =