I want to run the following query, using Esri's Select by Attributes tool, on a table found in an ODC. After selecting these rows, I want to append the records to a table found on an SDE connection. Here's the query:
"REC_DATE" BETWEEN TRUNC(SYSDATE-600) AND TO_DATE(TO_CHAR(SYSDATE - 3,'YYYYMMDD')||'235959','YYYYMMDDHH24MISS')
And here's the error I get:
The lack of an object ID in the table I am selecting from prevents the Select by Attribute tool from functioning. I would like to select directly from this table and not have to export it to an SDE (which would add an OID field). Does anyone have recommendations on how to perform my query on my ODC table?
Using version 10.0 of Esri software.