Last 25 post from my Blog eoracleapps.blogspot.com

For All 500+ Posts on Oracle Applications, RICE components/Workflow/ADF/BPEL go to eoracleapps.blogspot.com

Wednesday, May 27, 2009

XML DB Functions

--XML Element
select line_id,XMLELEMENT("Order",
XMLELEMENT("LINEID", line_id) ,
XMLELEMENT("Item", ordered_item)
)from oe_order_lines_all
where creation_date between sysdate-17 and sysdate
Posted by Oracle Tutor at 2:08 AM

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)