and clause in oracle


and clause in oracle

AND clause will return true if both statements are true other wise it will return false.

AND keyword is used along with where clause in oracle query.

Syntax

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

Example

>select * from student where name ='Vikas' and roll= 101;






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