I have several report queries that pull data from either shape file or an odbc connection. I am trying to switch one of these to an oracle odbc. however the syntax I have used for the msaccess connection doesn't isn't correct for the oracle. Can anyone help?
Thanks
SELECT * FROM GIS.SDO_SWCSCULVERTIN WHERE OBJECTID values (#PreserveSingleQuotes(OBJ_KEYS)#) ORDER BY OBJECTID