SELECT USER_JC.JC_NAME as Rolle,
       SUBSELECT."Child-Profile" as Subrolle,
       CASE
          WHEN SUBSELECT."Child-Profile" LIKE '%OSADM%' THEN 'OSA'
          WHEN SUBSELECT."Child-Profile" LIKE '%DBA%' THEN 'DBA'
          ELSE 'App'
       END as type,
       PROV_SYS_ENT_USER.FIRSTNAME,
       PROV_SYS_ENT_USER.LASTNAME,
       PROV_SYS_ENT_USER.DEPARTMENT
  FROM USER_JC
       INNER JOIN (SELECT PARENTPROFILE.JC_NAME AS "Parent-Profile",
                          PROFILE.JC_NAME AS "Child-Profile",
                          PROFILE.DESCRIPTION AS "desc"
                     FROM    JOB_CODE PROFILE
                          INNER JOIN
                             JC_JC PARENTPROFILE
                          ON (PARENTPROFILE.CON_JC_NAME = PROFILE.JC_NAME)
                    WHERE PROFILE.JC_NAME LIKE '%LDAP_DIR_33%'
                          AND PROFILE.ADD_INFO_MASTER LIKE '%RoleInRQM=0%'
                   UNION ALL
                   SELECT JC_NAME AS "Parent-Profile",
                          NULL AS "Child-Profile",
                          NULL AS "desc"
                     FROM JOB_CODE
                    WHERE JC_NAME LIKE '%LDAP_DIR_33%'
                          AND ADD_INFO_MASTER LIKE '%RoleInRQM=1%') SUBSELECT
          ON SUBSELECT."Parent-Profile" = USER_JC.JC_NAME
       NATURAL JOIN PROV_SYS_ENT_USER order by USER_JC.JC_NAME

Rolle 					Subrolle 	Type 	Firstname 	Lastname 	Department
UNIX_ADMIN_INSURANCE			                OSA		Hans		Brunner		SAP Basis
TOMCAT_ALL				TOMCAT_WIN	App		Esther		Runner		Middleware
TOMCAT_ALL				TOMCAT_UX	App		Esther		Runner		Middleware

SELECT PROFILE_GRP.JC_NAME,
       PROFILE_GRP.UG_NAME,
       SERVERVERBINDUNG.RSS_USER_NAME
  FROM    UG_JC PROFILE_GRP
       INNER JOIN
          RU_UG SERVERVERBINDUNG
       ON PROFILE_GRP.UG_NAME = SERVERVERBINDUNG.UG_NAME
 WHERE     PROFILE_GRP.JC_NAME LIKE '%LDAP_DIR_33%'
       AND PROFILE_GRP.JC_NAME NOT LIKE 'PROV_SYS%'
       AND SERVERVERBINDUNG.RSS_NAME = 'LDAP_DIR_33SRV'

JC_NAME					UG_NAME				RSS_USER_NAME
UNIX_ADMIN_INSURANCE	                UG_UNIX_ADM			host3.orafaq.com	
UNIX_ADMIN_INSURANCE	                UG_UNIX_ADM			host356.orafaq.com	
TOMCAT_WIN				UG_TOMCAT_WIN_ADM 	host2.google.com  
TOMCAT_WIN				UG_TOMCAT_WIN_ADM 	host345.google.com 
TOMCAT_WIN				UG_TOMCAT_WIN_ADM 	host66.google.com  
TOMCAT_UX				UG_TOMCAT_UX_ADM 	host31.google.com  

Select <Q1.col1,Q1.col2...>,<Q2.col1,Q2.col2...> 
   from (Query_1) Q1, (Query_2) Q2
 where 
   case when <put your conditions here>
        then <result>
   end = <result>

 WHERE CASE
 53   54            WHEN Q1.SUBROLLE IS NULL THEN Q1.ROLLE = Q2.JC_NAME
          WHEN Q1.SUBROLLE IS NOT NULL THEN Q1.SUBROLLE = Q2.JC_NAME
 55   56            ELSE END;
          WHEN Q1.SUBROLLE IS NULL THEN Q1.ROLLE = Q2.JC_NAME
                                                 *
ERROR at line 54:
ORA-00905: missing keyword


SQL>

select  *
  from  q1,
        q2
  where JC_NAME = NVL(Subrolle,Rolle)
/

select  *
  from  q1,
        q2
  where JC_NAME = NVL(Subrolle,Rolle)