Oracle set operator (UNION, MINUS) and read consistency

  • From: "" <dmarc-noreply@xxxxxxxxxxxxx> (Redacted sender "lei.zeng" for DMARC)
  • To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 17 Nov 2015 17:46:11 +0000 (UTC)

Hi list,
I have a query using set operators like the following
select * from <table 1>union allselect * 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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2015