Hello,
I cannot use order by in with my xmlagg clause. Any ideas???
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
SELECT XMLELEMENT("Department",
XMLAGG(
XMLELEMENT("Employee", e.atrb_cd||' '||e.vw_cd)
ORDER BY atrb_str_ord --this works if I -- it out
))
as "Dept_list"
FROM dim_vw_atrb e;
QL> desc dim_vw_atrb;
Name Null? Type
----------------------------------------- -------- ----------------------------
CLNT_CD NOT NULL NUMBER(2)
DIM_CD NOT NULL NUMBER(2)
VW_CD NOT NULL NUMBER(2)
ATRB_CD NOT NULL NUMBER(3)
ATRB_SRT_ORD NOT NULL NUMBER(2)
CRE_DT NOT NULL DATE
CRE_IDSID NOT NULL VARCHAR2(8)
LAST_MOD_DT NOT NULL DATE
LAST_MOD_IDSID NOT NULL VARCHAR2(8)
Thanks,
Jake
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jake Johnson
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
