Help with query.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Help with query.

  1. #1
    Join Date
    Jan 2002
    Posts
    38

    Help with query.

    Can anybody help with this query
    SELECT
    SUM(DBA.MAXBYTES)/1024 MAXSIZE,
    (DBA.bytes - (NVL(SUM(free.bytes), 0))) / 1024 USEDSIZE
    FROM
    DBA_DATA_FILES DBA,
    Dba_free_space free
    WHERE DBA.TABLESPACE_NAME LIKE '%TAMMY%'

    I get this error message.
    ERROR at line 3:
    ORA-00937: not a single-group group function
    Thanks

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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.... ???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width