1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

how to function nesting group!!!

Discussion in 'Oracle SCM & Manufacturing' started by sabindj, May 24, 2011.

  1. sabindj

    sabindj Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    SELECT MAX(AVG(salary))
    FROM employees
    GROUP BY department_id;
     
  2. the above query always works
     
    sabindj likes this.
  3. sabindj

    sabindj Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Re: how to grant table space for new user!

    another issue i have created user and also granted all privileges to the new user.
    while creating a new table under the new created user.
    the following error message displays:
    ORA-01950: no privileges on tablespace 'USERS'
    please advice how to grant tablespace for new created user...