Hi.

I'm struggeling with creating a database query monitor with a specific query, which of course works fine in TOAD:

select case when min(date_updated) > sysdate -2 then 'Updated' ELSE 'NOT_Updated' END from MyTable

However the creation faiels and gives the error " You are trying to add a query  ...     without an identifier "

select Also tried to give the select an identifier such as  select case when min(date_updated) > sysdate -2 then 'Updated' ELSE 'NOT_Updated' END as "Result" from MyTable

With the same result

Any ideas for how to resolve this?

Regards

Jensen