How to set query conditions in oracle

In Oracle, you can use the where clause to set query conditions. where is used to find records that meet specified conditions from a table or a temporary data set. It can be used for conditions in select, update, and delete statements. The syntax is: "select * from table name where condition".

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to set query conditions in oracle

The where clause is used to find records that meet specified conditions from the table or temporary data set, and can be used for conditions in select, update, and delete statements.

Grammar of where clause

select 字段名1,字段名2,......字段名n from 表名 where 字段名 比较运算符 值;
select * from 表名 where 字段名 比较运算符 值;

Example:

select id,name,yz,sc,height from T_GIRL where id='0101';

select id,name,yz,sc,height from T_GIRL where height=172;

Recommended tutorial:《 Oracle Tutorial》

The above is the detailed content of How to set query conditions in oracle. For more information, please follow other related articles on the PHP Chinese website!