Use or to connect two boolean expression : OR « Select Query « Oracle PL / SQL






Use or to connect two boolean expression

   

SQL>
SQL> create table courses
  2  ( code        VARCHAR2(6)  constraint C_PK
  3                             primary key
  4  , description VARCHAR2(30)
  5  , category    CHAR(3)
  6  , duration    NUMBER(2)
  7  ) ;

Table created.

SQL> insert into courses values('SQL','SQL','GEN',4);

1 row created.

SQL> insert into courses values('OAU','Java','GEN',1);

1 row created.

SQL> insert into courses values('JAV','C++','BLD',4);

1 row created.

SQL> insert into courses values('PLS','C','BLD',1);

1 row created.

SQL> insert into courses values('XML','XML','BLD',2);

1 row created.

SQL> insert into courses values('ERM','ERP','DSG',3);

1 row created.

SQL> insert into courses values('PMT','ERP','DSG',1);

1 row created.

SQL> insert into courses values('RSD','jQuery','DSG',2);

1 row created.

SQL> insert into courses values('PRO','Linux','DSG',5);

1 row created.

SQL> insert into courses values('GEN','Oracle','DSG',4);

1 row created.

SQL>
SQL> select code, category, duration
  2  from   courses
  3  where  category = 'BLD'
  4  or     duration = 2;

CODE   CAT   DURATION
------ --- ----------
JAV    BLD          4
PLS    BLD          1
XML    BLD          2
RSD    DSG          2

SQL> drop table courses;

Table dropped.

SQL>

   
    
    
  








Related examples in the same category

1.Query specific columns with where clause and 'or' operator
2.OR operator
3.OR operator : combine date compare and number compare
4.Query specific columns with where clause, or operator and order by
5.(1=1 or 1=0) and 0=1
6.1=1 or (1=0 and 0=1) (put and into parentheses)
7.1=1 or 1=0 and 0=1 (no parentheses)
8.OR operator combines two comparisons into one