Reviews PHP Oracle Training TutorialsTable of Contents
Querying Data with Oracle XQuery Using XQuery to Construct XML from Relational DataQuerying Data with Oracle XQuery
Querying Data with Oracle XQuery
Starting with Oracle Database 10g Release 2, you can take advantage of a full-featured native XQuery engine integrated with the database. With Oracle XQuery, you can accomplish various tasks involved in developing PHP/Oracle XML applications, operating on any kind of data that can be expressed in XML.
The following figure shows the data sources with which Oracle XQuery can work.
As you can see from the figure, XQuery can be used to query any data stored in the database and out of it.
NOTE: Please note that XQuery is not available in the Express Edition of Oracle Database. For more information on Oracle XQuery, you can refer to Oracle documentation: chapter Using XQuery with Oracle XML DB in the Oracle XML DB Developer's Guide. You can also refer to the XQuery 1.0: An XML Query Language W3C Recommendation at http://www.w3.org/TR/xquery/" target="_blank" rel="nofollow".
PHP Oracle Training Tutorials
- PHP Oracle Web Development
- XML Processing in PHP and Oracle Applications
- Creating XML with the DOM PHP Extension
- Querying a DOM Document with XPath
- Transforming and Processing XML with XSLT
- Performing XML Processing inside the Database
- Moving All the XML Processing into the Database
- Performing XSLT Transformations inside the Database
- Using Oracle Database for Storing, Modifying, and Retrieving XML Data
- Using XMLType for Handling XML Data in the Database
- Using XML Schemas
- Retrieving XML Data
- Using XMLType Views
- Performing DML Operations on XML Schema Based XMLType Views
- Using Oracle XML DB Repository
- Accessing Repository Resources with SQL
- Taking Advantage of Standard Internet Protocols
- Querying Data with Oracle XQuery
- Breaking up XML into Relational Data
Comments
Connect
Related Articles
- Oracle Coherence: Creating Indexes
- Oracle Coherence: Query Limitations
- Oracle Coherence: Built-in Aggregators
- Oracle Coherence: Implementing LookupValuesAggregator
- Oracle Application Express 3.2 – The Essentials and More Review
- Oracle Siebel CRM 8 Installation and Management Review
- Oracle Forms - Report Files
- Oracle Forms Modules
- Oracle Forms - PL/SQL Libraries
- Oracle Forms - Understanding XML
- Oracle Coherence: Obtaining Query Results
- Oracle Coherence: Controlling Query Scope Using Data Affinity
- Oracle Coherence: Other built-in value extractors
- Oracle Coherence: Querying The Data Grid
- Oracle Coherence: Aggregators
Exforsys e-Newsletter
Enhance Technical and Soft Skills every week, get our Job Interview Questions and Answers eBook free when you subscribe.
Subscribe and Get Free Bonus PDF Book
