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

Closed Linux or Unix Question    
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 offline Forum Staff  
Join Date: Feb 2004
Last Activity: 26 November 2015, 3:17 PM EST
Location: NM
Posts: 10,595
Thanks: 372
Thanked 895 Times in 831 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
Closed Linux or Unix Question

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 10:44 AM
Supress ' quotes in a select statement inside Shell Script mahabunta Shell Programming and Scripting 1 12-14-2006 06:29 PM
Select entries between two dates by converting Unix timestamp in Oracle Database. amitsayshii UNIX for Advanced & Expert Users 1 08-08-2006 12:00 PM
Want to use the output of Select statement in Unix script akhilgoel9 Windows & DOS: Issues & Discussions 4 05-27-2005 10:52 AM
Pipe SQL select statement results to script houtakker UNIX for Dummies Questions & Answers 6 10-31-2003 01:20 PM

All times are GMT -4. The time now is 05:25 PM.