Why FULL NATURAL JOIN works?
976692Nov 29 2012 — edited Nov 29 2012select * from v$version;
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
Why such constructions are successfully parsed and full/left/right/cross are ignored?
select * from
(select 1 a from dual)
full natural join
(select 2 a from dual);
select * from
(select 1 a from dual)
left natural join
(select 2 a from dual);
select * from
(select 1 a from dual)
right natural join
(select 2 a from dual);
select * from
(select 1 a from dual)
cross natural join
(select 2 a from dual);
The same time if we try to alias tables it gets an error:
select * from
(select 1 a from dual) t1
full natural join
(select 2 a from dual) t2;
ORA-00905: missing keyword
00905. 00000 - "missing keyword"
*Cause:
*Action:
Error at Line: 29 Column: 5
Edited by: Slobodcicov on Nov 28, 2012 11:46 PM