title: wrong query nested select error ORA-00913
body: <p>It doesnt work and I only got error ORA-00913: " too many values.". </p>
  
  <p>Problem I think is with nested select. I want to use this select to view.</p>
  
  <p>This code shows report for all employees. I changed attribute names for this post:</p>
  
  <pre><code> SELECT sk."AAAA", sk."BBBB", sk."CCCC", sk."DDD",
            sk."EEEE", sk."FFFF", sk."GGGGG",
            sk."HHHHH",
            (SELECT f.VALUE
             FROM fnd_user_property_tab f
             WHERE f.identity = sk.login
             AND NAME = 'IIIII') iii,sk."JJJJ",
  
             (SELECT f.VALUE
             FROM fnd_user_property_tab f
             WHERE f.identity = sk.login
             AND NAME = 'SMTP_MAIL_ADDRESS') mail,
  
             (SELECT f.VALUE
              FROM fnd_user_property_tab f
              WHERE f.identity = sk.login 
              AND NAME = 'KKKK') kkkk,
  
              (SELECT fnd.ORACLE_ROLE
               FROM fnd_user_role_tab fnd
               WHERE fnd.identity = sk.login
               AND fnd.ORACLE_ROLE LIKE 'STH-%') profil,
  
               (SELECT dr.ROLE, sox_co_w_roli(dr.role) skład
                FROM sys.dba_roles dr
                WHERE dr.role = (SELECT fnd.ORACLE_ROLE
                                FROM fnd_user_role_tab fnd
                                WHERE fnd.identity = sk.login  
                                AND fnd.ORACLE_ROLE LIKE 'STH-%')
               ) profile_role
      FROM sox_konta sk
      WHERE("PROFIL_DB" LIKE '%ppppp%'
            OR "PROFIL_DB" = 'oooooooo'
            OR "PROFIL_DB" = 'rrrrrrrr'
            )
      AND "COMPANIES" IN ('ZZ; ', 'YY; ')
  </code></pre>