Is there a way to make variables have different options? For instance, I am writing a SQL Query, and for the variable that I use, I would love to have a dropdown that is pre-built with options for the user running the query.
Is that possible?
I think I can use field filter after doing some research, but every time I apply it and pick the data from the drop down I get this error - ORA-00907: missing right parenthesis
Please post diagnostic info. You're using Oracle right?