Dive into Oracle ADF      (Updated: 2/3/2008; 9:20:23 PM.) Tips and tricks from Steve Muench on Oracle ADF Framework and JDeveloper IDE Useful Resources ADF Developers Guide ADF Learning Center ADF Step-by-Step Tutorial ADF SRDemo Sample JDev Online Documentation Oracle ADF FAQ Wiki Oracle ADF Training OTN J2EE for Forms Devs Oracle JHeadstart for ADF JHeadstart Features/Benefits Step-by-Step ADF/JHS Tutorial Books and Training on ADF ADF Recommended Reading ADF Toy Store Demo ADF Toy Store JSF 10.1.3 My Technical Articles Most Common ADF Methods My Recent Presentations My Oracle Magazine Columns JDev on OTN JDev Discussion Forum OTN HowTo Documents Some Companies Using ADF About Me Oracle Community Blogs JDev Release History JDeveloper/ADF Screencasts JDev/ADF 11g Tech Preview JDev/ADF 11g Tips Undocumented Samples Other ADF Bloggers AMIS Technology Andrejus Baranovski Chris Muir Didier Laurent Duncan Mills Edwin Biemond Frank Nimphius Gerard Davison Gerger Consulting Grant Ronald iAdvise JHeadstart Team Jakub Pawlowski Janusz Marchewa John Stegeman Luc Bors Lynn Munsinger Matthew Wilson Olaf Heimburger Shay Shmeltzer Search blog with Google:   Search BC4J JavaDoc:   August 2006 Sun Mon Tue Wed Thu Fri Sat     1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31     Jul   Sep Thursday, August 03, 2006 Querying Data from an XML Document Using SQLXML and a View Object I've posted example #77 to illustrate how you might leverage the power of Oracle's SQL XML support to easily query the interesting data from within an XML document using a view object. The DepartmentDataFromXML view object in the example uses a query that looks like this (NOTE: xmltext is a named bind variable): select   to_number(extractValue(value(x),'/ROW/DEPTNO'))     as DEPTNO,      substr(extractValue(value(x),'/ROW/DNAME'),1,10) as DNAME,      substr(extractValue(value(x),'/ROW/LOC'),1,10)   as LOC from   table(xmlsequence(extract(xmltype( :xmltext ),'/ROWSET/ROW'))) x to deliver a regular rowset of data as the view object's result without having to write any XML-parsing code. 3:53:10 PM     Optionally Filtering Query Based on URL Parameter Value I've added example #76 to illustrate how to use declarative techniques in the ADF page definition to optionally filter a view object's query by the value passed in a URL parameter, based on the presence or lack of that parameter. 9:29:31 AM     © Copyright 2008 Steve Muench.