Well a Union would be nice, but really i am looking to having several columns
7 weeks
and this is a VERY large table, so 7 queries unioned together would be VERY large indeed.

I can't believe there is no logic commands besides strict = in Oracle SQL

I think this is a HUGE disadvantage

any suggestions?