Select * from table query returns no rows even though table has data
391634Jul 14 2007 — edited Jul 23 2007In one APEX instance, a simple table with 95 rows fails to return any data when I query "select * from table" in the sql Workshop. Looking at the explain plan, the CBO is doing a full table scan then adding a filter with predicate "null is not null" to the plan, thereby suppressing all rows. Adding in a RULE hint has the same behavior except the predicate is "1 = 2".
Queries in SQL*Plus work normally. This problem is only on APEX. In the recently refreshed development instance of this same structure the query works normally everywhere.
Has anyone seen this sort of behavior before? Any ideas on how I can fix this?