Home >> Oracle >> Comparison Operators in Oracle

Comparison Operators in Oracle

Operator          Description                  Example(a=20,b=10)
  =                     Equal                          (a = b) return not true.
 !=                     Not Equal                   (a != b) return true.
 <>                    Not                              (a <> b) return true.
 >                      Greater Than              (a > b) return not true.
 >=                    Greater Than Equals  (a >= b) return not true.
 <                       Less Than                  (a < b) return true.
 <=                     Less Than Equals      (a <= b) return true.

Post Your Comment

Next Questions
Logical Operators
Set Operators
Joins
Inner Join
Outer Join
Self Join
Cross Join
Equi Join
Anti Join
Semi Join
Create database
Drop database
Create table
Drop table
Truncate table
Alter Table
Create table AS
Global Temporary tables
SELECT Query
INSERT Query
INSERT ALL Query
UPDATE Query
DELETE Query
WHERE clause
AND Clause

Copyright ©2022 coderraj.com. All Rights Reserved.