Re: SQL Query help
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 2 Jun 2015 08:30:56 +0100
Message-ID: <73991C80F6904F5EBCE0ABE9C8F8CEBE_at_Primary>
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2015.0.5941 / Virus Database: 4354/9916 - Release Date: 06/01/15
Date: Tue, 2 Jun 2015 08:30:56 +0100
Message-ID: <73991C80F6904F5EBCE0ABE9C8F8CEBE_at_Primary>
At least - it's good in principle, but less good in your example since all three CREATE statements fail on the 11.2.0.4 I have handy, and the query references at least one column that doesn't exist in the definitions.
Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com/all-postings
Author: Oracle Core (Apress 2011)
http://www.apress.com/9781430239543
- Original Message ----- From: "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> To: "ORACLE-L" <oracle-l_at_freelists.org> Sent: Tuesday, June 02, 2015 8:08 AM Subject: Re: SQL Query help
|
|
| Giving us the table definitions is good.
|
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2015.0.5941 / Virus Database: 4354/9916 - Release Date: 06/01/15
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 02 2015 - 09:30:56 CEST