Summary
From the simplest ora:contains() function in SQL query, to building indexes with Oracle Text inside the Oracle database, and then to using Oracle SES to create a secure enterprise search application, you can enable full-text search on XML stored in Oracle Database 11g via different approaches. The ora:contains() function is ideal for a quick query on a small set of XML data. Oracle Text indexes XML stored within the database and allows you to provide real-time transactional index updates. However, if you are looking for “Google-like” searches across database tables/schemas and even applications, Oracle Secure Enterprise Search is the best choice, because it allows you to easily build an integrated XML search solution to securely search ...
Get Oracle Database 11g Building Oracle XML DB Applications now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
