Help with query.
Can anybody help with this query
(DBA.bytes - (NVL(SUM(free.bytes), 0))) / 1024 USEDSIZE
WHERE DBA.TABLESPACE_NAME LIKE '%TAMMY%'
I get this error message.
ERROR at line 3:
ORA-00937: not a single-group group function
You need a SQL course badly.
You are using aggreate/groupping function obviously you have to group your result set. You are querying two views and where is the join condition or you like cartesian products.... ???
Click Here to Expand Forum to Full Width