Yes
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
@jloracle
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] on behalf
of dmarc-noreply@xxxxxxxxxxxxx [dmarc-noreply@xxxxxxxxxxxxx]
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