union

[Anon]

select count(*) from (select A1.col1 col1 from A A1,A A2 where A1.col1=A2.col1 UNION
ALL select A.col1 col1 from A,B
where A.col1(+)=B.col1);

where A1 and A2 are alias table of A.
col1 is the field name.

col1 of A has following values
10,20,30,40,50,60,70,80,90,100

col1 of B has following values
15,20,25,30,35,40,45,50,35,60,65,30,80,90,100

Iam getting the result as 25

I want to know what's the A.col1(+) will do here.I want the description of the operation.

[Anon]

I presume you are using Oracle. It will select all records from Table A regardless of a related record in Table B i.e. an Outer Join