Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

ORA-00904 ÐÒÉ full outer join × ÓÏÅÄÉÎÅÎÉÉ Ó XMLTable

20 views
Skip to first unread message

Ignatiev Vjacheslav

unread,
Nov 26, 2007, 1:10:24 AM11/26/07
to

نزصعطر, بـجذ, قشد خإ شءث?

[ivv@ivvwork merge-gis-nodes]$ sqlplus $sqlConn @t.sql

SQL*Plus: Release 10.2.0.3.0 - Production on Fri Nov 23 11:44:55 2007

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Release 10.2.0.3.0 - Production

SQL> select *
2 from
3 XMLTable(
4 'for $n in /* return $n'
5 passing xmlType( '<row>1</row>' )
6 columns a char path 'a' ) a
7 full outer join
8 ( select '2' a from dual ) b
9 on a.a = b.a
10 /
on a.a = b.a
*
ERROR at line 9:
ORA-00904: "QMXTABCOL$": invalid identifier


Disconnected from Oracle Database 10g Release 10.2.0.3.0 - Production


0 new messages