or clause in oracle


or clause in oracle

OR clause will return true if  any one of the statements are true.If both are false then it will return false.

OR keyword is use to pass condition in oracle query.

Syntax

>select column_name from table_name where column_name = column_data or column_name = column-data;

Example

>select * from student where name ='Vikas' or salary<=50000;






Full-stack web and mobile app development company Contact Us : Skype: indore.webcoder Email: info@w3sparks.com Sales: +91 8085506229