Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.
|
|
google unix.com
|
|||||||
| Forums | Register | Forum Rules | Links | Albums | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
 |
| UNIX and Linux Applications Discuss UNIX and Linux software applications. This includes SQL, Databases, Middleware, MOM, SOA, EDA, CEP, BI, BPM and similar topics. |
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 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 01:20 PM |
 |
Powered by 
|
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
03-26-2009
|
||||
|
||||
|
Oracle Select IN statement
If I recall, when I used informix I could do a sql statement like:
Code:
SELECT Value from Table WHERE ID in (100,200,300); Thanks. |
|
03-26-2009
|
||||
|
||||
|
The datatypes have to correspond to the column's definition. The syntax is okay as you have it. Your example works for numeric datatypes.
Code:
-- varchar
in ('A', 'B', 'C')
|
|
| Bookmarks |
| Tags |
| oracle, select |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Hybrid Mode
