oracle_database_versions_combined

0

Please login or register to vote for this query.

(click on this box to dismiss)

returns all combinations of the oracle tags 'oracle', 'oracle-8i','oracle-9i',...,'oracle-12c' and the number of questions for this combination

Database Administrators

Q&A for database professionals who wish to improve their database skills and learn from others in the community

select count(*), t1.tagname, t2.tagname, t3.tagname, t4.tagname, t5.tagname, t6.tagname, t7.tagname, t8.tagname
from posts p 
left outer join 
(posttags pt1 join tags t1  on (pt1.tagid=t1.id and t1.tagname='oracle')) 
 on (p.id=pt1.postid)
left outer join 
(posttags pt2 join tags t2  on (pt2.tagid=t2.id and t2.tagname='oracle-12c')) 
 on (p.id=pt2.postid)
left outer join 
(posttags pt3 join tags t3  on (pt3.tagid=t3.id and t3.tagname='oracle-11g-r2')) 
 on (p.id=pt3.postid)
left outer join 
(posttags pt4 join tags t4  on (pt4.tagid=t4.id and t4.tagname='oracle-11g')) 
 on (p.id=pt4.postid)
left outer join 
(posttags pt5 join tags t5  on (pt5.tagid=t5.id and t5.tagname='oracle-10g-r2')) 
 on (p.id=pt5.postid)
left outer join 
(posttags pt6 join tags t6  on (pt6.tagid=t6.id and t6.tagname='oracle-10g')) 
 on (p.id=pt6.postid)
left outer join 
(posttags pt7 join tags t7  on (pt7.tagid=t7.id and t7.tagname='oracle-9i')) 
 on (p.id=pt7.postid)
left outer join 
(posttags pt8 join tags t8  on (pt8.tagid=t8.id and t8.tagname='oracle-8i')) 
 on (p.id=pt8.postid)
group by t1.tagname, t2.tagname, t3.tagname, t4.tagname, t5.tagname, t6.tagname, t7.tagname, t8.tagname
order by t1.tagname, t2.tagname, t3.tagname, t4.tagname, t5.tagname, t6.tagname, t7.tagname, t8.tagname

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results