Boolean expressions in where clause

  

SQL>
SQL> create table gift(
  2           gift_id                integer         primary key
  3          ,emp_id                integer
  4          ,register_date              date not null
  5          ,total_price        number(7,2)
  6          ,deliver_date           date
  7          ,deliver_time           varchar2(7)
  8          ,payment        varchar2(2)
  9          ,emp_no                 number(3,0)
 10          ,deliver_name           varchar2(35)
 11          ,message        varchar2(100)
 12  );

Table created.

SQL>
SQL> insert into gift(gift_id,emp_id,register_date,total_price,deliver_date,deliver_time,payment,emp_no,deliver_name,message)values
  2                 (1,1,'14-Feb-1999', 123.12, '14-Feb-1999', '12 noon', 'CA',1, null, 'Happy Birthday to you');

1 row created.

SQL> insert into gift(gift_id  ,emp_id ,register_date ,total_price ,deliver_date ,deliver_time ,payment ,emp_no,deliver_name ,message)values
  2                 (2,1,'14-Feb-1999', 50.98, '14-feb-1999', '1 pm', 'CA',7, 'name1', 'Happy Birthday');

1 row created.

SQL> insert into gift(gift_id  ,emp_id ,register_date ,total_price ,deliver_date ,deliver_time,payment ,emp_no,deliver_name ,message )values
  2                 (3, 2,'14-Feb-1999', 35.99, '14-feb-1999', '1 pm', 'VS',2, 'Tom', 'Happy Birthday');

1 row created.

SQL> insert into gift(gift_id  ,emp_id ,register_date ,total_price ,deliver_date ,deliver_time,payment ,emp_no,deliver_name ,message )values
  2                 (4, 2,'14-Feb-1999', 19.95, '14-feb-1999', '5 pm', 'CA',2, 'Mary', 'Happy Birthday');

1 row created.

SQL>
SQL>
SQL>
SQL> select gift_id, total_price, payment
  2    from gift
  3   where (payment = 'CA' OR payment = 'VS' OR payment = 'VG')
  4     AND total_price > 15;

   GIFT_ID TOTAL_PRICE PA
---------- ----------- --
         1      123.12 CA
         2       50.98 CA
         3       35.99 VS
         4       19.95 CA

4 rows selected.

SQL>
SQL> drop table gift;

Table dropped.

Related examples in the same category

1.	PL/SQL BOOLEAN datatypes accept only TRUE, FALSE, NULL
2.	Define and use boolean value
3.	Boolean data type with If statement
4.	Use the NVL() against a non-initialized BOOLEAN variable:
5.	Boolean literals
6.	Assign a value to a variable of type boolean. Don't use quotes around the value like this

Boolean expressions in where clause : Boolean « Data Type « Oracle PL / SQL

Related examples in the same category