I am looking for examples of SQL expressions to use in Make Query Layer that have WHERE statements that include conditions based on attribute values and geometries. The SDE from which I am pulling is an Oracle database.
Question 2: Who in a ModelBuilder tool or script tool asked an user to supply a geometry that is then used in a Query Layer SQL statement?
Thank you for your help.
Talking in too abstract of terms is always difficult. For your question 1, it would be helpful if you could provide a couple examples of what you are trying to achieve, e.g., I have three fields (field1 (str), field2 (dbl), field3 (date), field4 (geom)) where I want to select all rows where field1 = 'x' and field2 > 100. and area(field4) > 10 acres.
I don't think providing you with random examples relevant to my work will be useful for you in your work.