HTH,
Dave
[EMAIL PROTECTED] wrote:
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: Dave Hau 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).
