Logical Operators

And :- The oracle engine will process all rows in a table and display the result only when all of the conditions specified using the AND operator
OR:-    The oracle engine will process all rows in a table and display the result only when any of the conditions specified using the OR operator.
NOT:- The oracle engine will process all rows in a table and display the result only when none of the conditions specified using the NOT operator are satisfied.

select * from vision where sal >2000 and sal<4000;

• select * from vision where sal<2000 or sal>3000;
• select * from vision where not(sal=2000 or eno=400);

BETWEEN:- In order to select data that is within a range of values the BETWEEN operator is used. The BETWEEN operator allows the selection of rows that contain values within a specified lower and upper limit. The range coded after the BETWEEN is inclusive.

Ex:-   1    Select * from vision where sal between 2000 and 3000;
2     Select * from vision where sal not between 2000 and 3000;

 

For
Online Classes

Contact Us: +919885348743