Oracle Select IN statement

Linux and Unix-Like UNIX and Linux Applications
1

If I recall, when I used informix I could do a sql statement like:

SELECT Value from Table WHERE ID in (100,200,300);

How do I do this in Oracle? I believe I am using Oracle 10 if that matters.
Thanks.

2

The datatypes have to correspond to the column's definition. The syntax is okay as you have it. Your example works for numeric datatypes.

-- varchar
in ('A', 'B', 'C')