oracle xmlagg 聚合,xmlagg

SYS_XMLAGG(expr[,fmt]) 该函数用于汇总所有 XML 文档,并生成一个 XML 文档。 示例: SELECT SYS_XMLAGG(SYS_XMLGEN(a.order_content)) xml_content from doc_clinic_order a, clinics_item b, med_frequencydict c where a.......

(’Sales Representative’ as "Title"), xmlagg (xmlelement (’Name’, "FirstName", ’’, "LastName"))) FROM "Demo"."demo"."Employees" WHERE "Title" = ’Sales Representative’; might result in

ROWID NAME --- ---AAAAASAABAAAAB6ABc ACCESS$ AAAAASAABAAAC1QAAK AGGXMLIMP AAAAASAABAAAC1QAAL AGGXQIMP AAAAASAABAAAGiRAAI ALERT_QT AAAAASAABAAAGiRAAh ALERT_QUE AAAAASAABAAAGujAAo ALERT_QUE$1 AAAAASAABAAAGujAAp ALERT......

(ARG,LENGTH) 1 0 0 0 0 0 0 0 0 0 0 0 0 XMLCOMMENT XMLATTRIBUTES XMLAGG VERIFY_TRUSTED_CON TEXT_ROLE_FOR_USER VERIFY_ROLE_FOR_US ER VERIFY_GROUP_FOR_U SER VARIANCE_SAMP VARIANCE VARGRAPHIC VARCHAR_FORMAT VAR......