AND/OR Clause

View All Public Scripts Login to Run Script

Script Name AND/OR Clause
Visibility Unlisted - anyone with the share link can access
Description This script has OR/AND clause for selecting values with AND and OR parameters. AND is used when we want a value which satisfy both conditions. OR is used when we want any of condition to be satisfied. Created By- Ekta Narwal
Area SQL Types
Contributor ekta_narwal@yahoo.com
Created Sunday May 17, 2020

Statement 1

CREATE TABLE employee(eid number(4), ename char(15), ework varchar(12))

Table created.

Statement 2

INSERT INTO employee VALUES(893, 'Ritu', 'Accountant')

1 row(s) inserted.

Statement 3

INSERT INTO employee VALUES(1896, 'Parv', 'Banker')

1 row(s) inserted.

Statement 4

INSERT INTO employee VALUES(6725, 'Seema', 'Clerical')

1 row(s) inserted.

Statement 5

INSERT INTO employee VALUES(672, 'Seema', 'Clerical')

1 row(s) inserted.

Statement 6

INSERT INTO employee VALUES(1896, 'Parvesh', 'Banker')

1 row(s) inserted.

Statement 7

select * from employee


EID ENAME EWORK
893 Ritu           Accountant
1896 Parv           Banker
6725 Seema          Clerical
672 Seema          Clerical
1896 Parvesh        Banker

5 rows selected.

EID	ENAME	EWORK
893	Ritu	Accountant
1896	Parv	Banker
6725	Seema	Clerical
672	Seema	Clerical
1896	Parvesh	Banker

Statement 8

Select eid,ename from employee where ework= 'Banker' AND eid='1896'


EID ENAME
1896 Parv           
1896 Parvesh        

2 rows selected.

EID	ENAME
1896	Parv
1896	Parvesh

Statement 9

Select ename from employee where ework= 'Banker' OR eid='893'


ENAME
Ritu           
Parv           
Parvesh        

3 rows selected.

ENAME
Ritu
Parv
Parvesh

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database