Timeline for ArcGIS - Help Using Oracle Function in Definition Query - No ArcSDE
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 11, 2020 at 15:27 | history | edited | CommunityBot |
Commonmark migration
|
|
| Aug 12, 2013 at 16:24 | answer | added | MattL | timeline score: 1 | |
| Aug 10, 2013 at 20:00 | comment | added | travis | An Oracle database isn't considered file based, so it does support subqueries, You have a function not a subquery. Can you select the result of gis_getmeterstatus (try: select gis_getmeterstatus(METERNAME,'2013/08/08 10:25:00','2013/08/09 10:25:00') from gis_meters where rownum < 10)? A subquery would be something like: Select * from gis_meters Where 0 not in (Select status from gis_meterhistory where logTime > :lowDate and logtime < :highDate) | |
| Aug 9, 2013 at 14:35 | history | asked | user890 | CC BY-SA 3.0 |