Getting into SQL/XML in Oracle

Get an overview of SQL and XML interoperability and learn how to begin working with XML documents stored in an Oracle database.

XML data is commonly used in today’s production systems and is a major part of database implementations. In the past, this fact caused design problems for database developers who consequently had to store, query, and update XML data as unstructured LOBs, or alternatively, “shred” data into relational tables and then put it back together. This approach resulted in programming complications and inefficiencies because the access mechanisms were immature.

The Oracle XML DB feature that was first delivered with Oracle9i Database Release 2 provided groundbreaking features for storing, retrieving, and manipulating XML data in the database. Oracle 10g Release 2 XML DB, however, greatly extends this initial approach in which XML data is little more than a BLOB in the database.

If you are a DBA or a developer new to the implementation of XML in Oracle, this article is for you: you will get an overview of SQL and XML interoperability and learn how to begin working with XML documents stored in an Oracle 10g Release 2 database, and about the many features of Oracle Database 10g Release 2 that DBAs and developers should become comfortable with before beginning to work with XML in the database. Thanks to these SQL/XML features, the skills you’ve already acquired while working with relational data can easily be enhanced to help you work with XML.

Continue Reading


Error handling in long-running batch jobs

Nice link if you in a situation where transaction and long running batch happen.

Using Oracle Database or Oracle EBS adapter for Oracle AQ (Advanced Queuing)

Follow this link

And how to set up Oracle AQ for the specific user?

GRANT Aq_administrator_role TO aqadm;

grant execute on DBMS_AQ to aqadm;

Why does the Adapter say ‘Action is not understood’ even though I am using the binding file generated by the ‘Consume Adapter Service’ wizard?

Good link

Get youtube video

Found another site to download youtube video. The page is simple and very esay to use. Check out this web page, they provide facility to download video from well known video sites such as youtube , google video, yahoo video, metacafe, dailymotion ,myspace video and many more. The number of supported video sites will grow and counting up.

HoldTube supports to download flv, 3gp, mp4, flv-HQ and mp4-HQ format for youtube video.

One interesting features that this web site provide, is we can enter up to 10 link video silmutanly.

Biztalk 2006 SQL Adapter polling bug. Potentially you can bring Biztalk Server to halt within few minutes.

follow this link.

Full Text Search in LINQ

good link