Hi
i use this minus operator to find the non matching row of the second query.
after looking at the reasult of this query , i searched the one result in the second query alone i could see the data.
it's worng The MINUS query returns all rows in the first query that are not returned in the second query.
in my case it's returning the rows which returned by the second query.
(select distinct lower(trim(to_char(sso))),lower(trim(to_char(region))),to_date(expiration_date,'DD-MM-YY') from ca_ourc_view
where rownum <1001
)
minus
(select distinct lower(trim(to_char(sso))),lower(trim(to_char(region))),to_date(expiration_date,'DD-MM-YY') from ourc_members_v1@gesprd
where rownum <1001
)
thanks
Raj