Results not returned when working with aggregate functions. Query should produce results but Nav notes 0 rows returned.
There is no error message. If the aggregate function is taken out of the query, it works. This is only an issue if there are NULLs in the table/result set. If an NVL statement is added to the aggregate function, it will return the expected data. This is only an issue on one computer. Other computers don't have this problem. It is not specific to the user's login.
The query itself works in SQL Plus and returns the expected rows.
© ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center