Home >> Oracle >> OR Clause in Oracle

OR Clause in Oracle

OR clause used to check multiple condtion with a WHERE clause from a table in database.

It is used on SELECT,UPDATE and DELETE query.

Syntax

SELECT * FROM tablename WHERE condition1 OR condition2 OR condition3;

Example

SELECT * FROM students WHERE student_id=1 OR city='Delhi'

Post Your Comment

Next Questions
LIKE clause
IN clause
ORDER BY Clause
GROUP BY Clause
HAVING Clause
BETWEEN
EXISTS
NOT EXITS
ANY
ALL
MAX
MIN
AVG
COUNT
SUM
What is key
What is Super Key
What is Candidate Key
What is Primary Key
What is Unique Key
What is Foreign Key
Function
Procedure
Cursor
Trigger

Copyright ©2022 coderraj.com. All Rights Reserved.