SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00904 when full outer join with XMLTable()

610019Nov 22 2007 — edited Nov 23 2007

Hi! What's wrong with query?

Oracle Database 10g Release 10.2.0.3.0

select *
from 
 XMLTable( 
  'for $n in / return $n' 
  passing xmlType( '<row><a>1</a></row>' ) 
  columns a char path 'a' ) a
 full outer join
 ( select '2' a from dual ) b
 on a.a = b.a

ORA-00904: "QMXTABCOL$": invalid identifier

Message was edited by:
ivv

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 21 2007

Added on Nov 22 2007

4 comments

357 views