Bug
Great Queries by Select By Attributes doesn't work with ORACLE data, but works with fGDB and SQL Server.
| Bug ID Number | NIM031527 |
|---|---|
| Submitted | January 23, 2008 |
| Last Modified | April 28, 2025 |
| Applies to | No Product Found |
| Version found | 9.2 |
| Status | Known Limit |
Additional Information
No Public ExplanationWorkaround
Modify the where clause for your oracle case to use nested queries or joins...Joins would be the fastest - "or" and "in" clauses are normally much slower.Examples:select * from user.Parcels where (PARCEL_ID in (1...1000) orPARCEL_ID in (1001...2000) )=================(select ... from ... where PARCEL_ID in (1, 2, ... 1000) )UNION(select ... from ... where PARCEL_ID in (1001, 1002, ... 2000))...UNION(select ... from ... where PARCEL_ID in (N, N+1, ... M)=================You can use ArcObjects (IDatabaseConnectionInfo2.ConnectionDBMS Property) to determine the type of GDB connected to if needed.Steps to Reproduce
Bug ID: NIM031527
Software:
- No Product Found
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App