By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table RV_USERS (UserID int, Audit_Date date);
insert into RV_USERS values (1, to_Date('2019/10/10', 'yyyy/mm/dd'));
1 rows affected
insert into RV_USERS values (2, to_Date('2019/10/10', 'yyyy/mm/dd'));
1 rows affected
insert into RV_USERS values (3, to_Date('2019/10/10', 'yyyy/mm/dd'));
1 rows affected
insert into RV_USERS values (4, to_Date('2019/10/10', 'yyyy/mm/dd'));
1 rows affected
insert into RV_USERS values (5, to_Date('2019/10/10', 'yyyy/mm/dd'));
1 rows affected
insert into RV_USERS values (5, to_Date('2019/10/10', 'yyyy/mm/dd'));
1 rows affected
SELECT * FROM RV_USERS WHERE UserID in (UserID, 2)
| USERID | AUDIT_DATE |
|---|---|
| 1 | 10-OCT-19 |
| 2 | 10-OCT-19 |
| 3 | 10-OCT-19 |
| 4 | 10-OCT-19 |
| 5 | 10-OCT-19 |
| 5 | 10-OCT-19 |