Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Error: "ORA-00920 invalid relational operator" when viewing the Schema Browser's Data Tab.
설명
Error received when viewing the Data Tab for a table:
"ORA-00920 invalid relational operator Cause: A search condition was entered with an invalid or missing relational operator.
Action: Include a valid relational operator such as =, !=, ^=, <>, >, <, >=, <=, ALL, ANY, [NOT] BETWEEN, EXISTS, [NOT] IN, IS [NOT] NULL, or [NOT] LIKE in the condition."
원인
An invalid filter is set.
해결 방안
RESOLUTION 1:
1. After receiving the error, click OK to close the error box.
2. click on the filter/Sort icon.
3. In the Table Sort window, click the clear filter button and the clear sort button.
4. Relaunch the Schema Browser.
RESOLUTION 2:
Click clear all data grid filters icon in the Schema Browser window to clear any filters currently set.
