I have a really simple query
WHERE PAID = ‘NA’
AND DELETED IS NULL;
It returns a data set. But when I right click to do “Record Count” I get ORA-01427: single-row subquery returns more than one row. I understand the error, just not how I can get this from a simple count on a set of data that has already been pulled??
Is this me being incredibly stupid? I have restarted TOAD and the same thing occurs. I’m using 12.1 Professional.