What do you mean by Oracle IN Operator

IN operator is can be used easily test multiple values if an expression is equal to any member in a list

its Syntax:

SELECT column
FROM table
WHERE column IN (value1, value2, value3,value4…value_n);
Example:

SQL>F:\app\dell\virtual\product\12.2.0\dbhome_1\bin>sqlplus/nolog
 SQL*Plus: Release 12.2.0.1.0 Production on Thu Mar 3 10:15:34 2022
 Copyright (c) 1982, 2016, Oracle.  All rights reserved.
 SQL> conn BIuser@orcl
Enter password:
Connected.
--when we select all of the list column without IN operator 
SQL> SELECT NAME,SALARY,AGE FROM AMAN;
NAME                     SALARY        AGE
-------------------- ---------- ----------
MERI                       2000         18
SAMI                       5000         28
ABEBE                      4000         24
KEBEDE                     9000         34
DANIEL                     7600         44
ALMAZ                      5000         30
LIYA                       7000         29
 7 rows selected.
-- when we can use IN operator in the above table 
SQL> SELECT NAME,SALARY,AGE FROM AMAN WHERE ID IN('1','3','5') ORDER BY AGE
  2  ;
 NAME                     SALARY        AGE
-------------------- ---------- ----------
MERI                       2000         18
ABEBE                      4000         24
DANIEL                     7600         44
 SQL>

PC Gaming Headset Headphone Hook Holder Hanger Mount, Headphones Stand with Adjustable & Rotating Arm Clamp, Under Desk Design, Universal Fit, Built in Cable Clip Organizer EURPMASK

(27325)

$12.99 (as of 30/06/2024 15:53 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

🎧【Clamp-on Headphone Stand】The E-Hold Series headphone holder fits desks from 0.31 inch to 1.57 inch thick, making it a versatile choice for most setups. The spring clamp is a breeze to remove and reattach. No glue, no mess. It blends seamlessly into... read more

LLEVTIC Computer Speakers, Desktop Speakers with 6 Colorful RGB Lights, Volume Control PC Speakers, USB Powered Gaming Speakers with 3.5mm Aux Cable for PC Monitor Laptop Tablet Phone

(1250)

44% Off $26.88 $14.99 (as of 30/06/2024 15:56 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

【Full-Range Stereo Sound Quality】Equipped with advanced sound drivers and a full-range 2.0 channel reinforced stereo core, this computer speakers provides the perfect atmosphere for your entertainment activities such as watching movies, gaming, and l... read more

Laptop Cleaning Kit Keyboard Cleaner, Keyboard Cleaning Kit Electronics Cleaning Tool for MacBook iPad Phone iPhone Pro, Brush Tool for Tablet, Computer, PC, TV Camera Lens Computer Vacuum Keyboard

(2045)

$16.98 (as of 30/06/2024 15:53 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

DEEP CLEAN YOUR DEVICE The electronics cleaner kit can effectively deep clean all your electronic devices such as mobile phones, tablets, TVs, etc. It comes with retractable large keyboard brush, polishing cleaning cloth X 2, keycap puller, metal pen... read more

UtechSmart Venus Pro RGB Wireless MMO Gaming Mouse, 16,000 DPI Optical Sensor, 2.4 GHz Transmission Technology, Ergonomic Design, 16M Chroma RGB Lighting, 16 programmable Buttons, Up to 70 Hours

20% Off $59.99 $47.99 (as of 30/06/2024 15:53 GMT -04:00 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)

【Extensive Fully Programmable Buttons】16 customizable buttons can improve your gaming skills and performance by complex custom button macro coding of reconfiguration and assignment. The button custom function combines multiple keys into one button th... read more