RE: Oracle set operator (UNION, MINUS) and read consistency

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 17 Nov 2015 18:11:46 +0000
Message-ID: <CE70217733273F49A8A162EE074F64D9282B1525_at_EXMBX01.thus.corp>

Yes

Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
_at_jloracle

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] on behalf of dmarc-noreply_at_freelists.org [dmarc-noreply_at_freelists.org] Sent: 17 November 2015 17:46
To: Oracle-L Freelists
Subject: Oracle set operator (UNION, MINUS) and read consistency

Hi list,

I have a query using set operators like the following

select * from <table 1>
union all
select * from <table 2>

Does Oracle consider this as ONE query which allows both 'select' statements have read consistency back to the time when the first 'select' statement starts?

Thanks,
Lei

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 17 2015 - 19:11:46 CET