Unix/Linux Go Back    

UNIX and Linux Applications Discuss UNIX and Linux software applications. This includes SQL, Databases, Middleware, MOM, SOA, EDA, CEP, BI, BPM and similar topics.

Oracle Select IN statement

UNIX and Linux Applications

oracle, select

Thread Tools Search this Thread Display Modes
Old Unix and Linux 03-26-2009
benefactr benefactr is offline
Registered User
Join Date: Jul 2007
Last Activity: 4 February 2013, 4:02 PM EST
Posts: 76
Thanks: 0
Thanked 0 Times in 0 Posts
Oracle Select IN statement

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.
Sponsored Links
Old Unix and Linux 03-26-2009
jim mcnamara jim mcnamara is online now Forum Staff  
Join Date: Feb 2004
Last Activity: 30 April 2017, 10:04 PM EDT
Location: NM
Posts: 11,031
Thanks: 519
Thanked 1,049 Times in 972 Posts
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')

Sponsored Links

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Executing a Oracle SQL statement in a UNIX script ganga.dharan Shell Programming and Scripting 1 12-08-2008 09:44 AM
Supress ' quotes in a select statement inside Shell Script mahabunta Shell Programming and Scripting 1 12-14-2006 05:29 PM
Select entries between two dates by converting Unix timestamp in Oracle Database. amitsayshii UNIX for Advanced & Expert Users 1 08-08-2006 11:00 AM
Want to use the output of Select statement in Unix script akhilgoel9 Windows & DOS: Issues & Discussions 4 05-27-2005 09:52 AM
Pipe SQL select statement results to script houtakker UNIX for Dummies Questions & Answers 6 10-31-2003 12:20 PM

All times are GMT -4. The time now is 10:30 PM.