Enterprise Manager

**************************
For exsample2
Of course.We can use above logic in select with group by and having

select ID,
min(case when Val in('aaa','ccc') then 1 else 0 end)
as chk1,
max(case when Val in('aaa','ccc') then 1 else 0 end)
as chk2,
 max(case when Val='aaa' then 1 else 0 end)
*max(case when Val='ccc' then 1 else 0 end)
as chk3,
min(case when Val in('aaa','ccc') then 0 else 1 end)
as chk4,
max(case when Val in('aaa','ccc') then 1 else 0 end)
as chk5
  from boolEx1
group by ID
order by ID;

ID  CHK1  CHK2  CHK3  CHK4  CHK5
--  ----  ----  ----  ----  ----
 1     0     1     1     0     1
 2     1     1     1     0     1
 3     0     1     0     0     1
 4     0     0     0     1     0

*****************************************************************
3. What is summary of "Boolean algebra in some Rows" ? ?:|

I have used this Logic.
http://en.wikipedia.org/wiki/First-order_logic

"max(case when P(X) then 1 else 0 end) = 1"
 is for some X:P(X)
"min(case when P(X) then 1 else 0 end) = 1"
 is for all  X:P(X)
"max(case when P(X) then 0 else 1 end) = 1"
 is for some X:not(P(X))
"min(case when P(X) then 0 else 1 end) = 1"
 is for all  X:not(P(X))

and sometimes I use below one.

 "max(case when P(X) then 1 else 0 end)
* max(case when Q(X) then 1 else 0 end) = 1"
is for some X:P(X) and for some X:Q(X)

*****************************************************************
4. What threads are using "Boolean algebra in some Rows" ?:|

I will write that threads sorted by easy.

634915
551061
526715

557138
551338

585154
621506

*****************************************************************
OracleSQLPuzzle (MyHomePage)
http://www.geocities.jp/oraclesqlpuzzle

sister thread
Tabibitosan method tutorial 1007478

These forums are generally not used to post tutorials so it is likely those that might benefit from them won't find what you've posted.

Consider helping us kick off the new Sample Code section:
https://www.samplecode.oracle.com

I assume in your Boolean Algebra 0 represents False and 1 represents True. If so:
You mean chk1 will check if each ID has nothing but either 'aaa'or 'ccc'
I assume it is typo and you meant 'ccc' not 'bbb'.
You mean chk4 will check if each ID has something other than 'aaa' or 'ccc'. It might not have 'aaa' or 'ccc' at all.
You mean chk5 will check each ID has at least 'aaa' or 'ccc'.

SY.

In chk3 you made a typo as Solomon has already write.
So I think chk4=¬chk1 (NOT chk1). If so you should use max instead of min.
So I think chk5=¬chk2 (NOT chk2). If so you should use min instead of max.

SQL> select ID,
  2  min(case when Val in('aaa','ccc') then 1 else 0 end) as chk1,
  3  max(case when Val in('aaa','ccc') then 1 else 0 end) as chk2,
  4  max(case when Val='aaa' then 1 else 0 end)*max(case when Val='ccc' then 1 else 0 end) as chk3,
  5  max(case when Val in('aaa','ccc') then 0 else 1 end) as chk4,
  6  min(case when Val in('aaa','ccc') then 0 else 1 end) as chk5
  7  from boolEx1
  8  group by ID
  9  order by id;

        ID       CHK1       CHK2       CHK3       CHK4       CHK5
---------- ---------- ---------- ---------- ---------- ----------
         1          0          1          1          1          0
         2          1          1          1          0          0
         3          0          1          0          1          0
         4          0          0          0          1          1

Max
[My Italian Oracle blog|http://oracleitalia.wordpress.com/2009/12/26/leggiamo-meglio-il-dizionario-dati-utilizzando-dbms_metadata/]

OOPS my English is not good at.
I have fixed my English miss of previous post.

When I will answer similar threads,I will write these tutorial threads URL B-)