Oracle set operator (UNION, MINUS) and read consistency
From: <"">
Date: Tue, 17 Nov 2015 17:46:11 +0000 (UTC)
Message-ID: <276495411.5875089.1447782371643.JavaMail.yahoo_at_mail.yahoo.com>
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
Date: Tue, 17 Nov 2015 17:46:11 +0000 (UTC)
Message-ID: <276495411.5875089.1447782371643.JavaMail.yahoo_at_mail.yahoo.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 17 2015 - 18:46:11 CET