What does in in oracle mean?

In in oracle means "within...". In is often used in conditional expressions to set the range for data operations. The field value only needs to satisfy any one within this range. , the syntax is "field in(value1,value2,…)".

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

What does in mean in Oracle

in is often used in conditional expressions (where), its function is to control within a certain range Operate, query or delete the data. The field value only needs to satisfy any one within this range.

The example query syntax is as follows:

select * from TableName(表名） where 字段 in (value1，value2，…);

The example is as follows:

(1) Query all records in the t_hero table

(2) Query all records whose keyid is equal to one of these three values ​​(21, 16, 7). As long as one of these three values ​​is satisfied, you can query it.

Recommended tutorial: "Oracle Tutorial"

The above is the detailed content of What does in in oracle mean?. For more information, please follow other related articles on the PHP Chinese website!