what is where clause in oracle


what is where clause in oracle

where clause is use to pass condition with our SQL queries.

Suppose we want to retrieve only one record then we have to pass where clause along with select query.

Where clause with select query

>select * from table_name where condition;

Query

>select * from stud where roll=101;

Here only matched data will be displayed.

where clause with update query

>update table_name set field_name =new_value where condition;

Query

>update student set name='Vicky' where roll =101;

here only matched record will be updated.






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