Oracle Text – A Powerful Tool for Oracle Developers
Oracle Text is included with every edition of the Oracle database – even the free Express Edition (XE). Many APEX applications can benefit from adding its powerful search capabilities. This presentation will explain how to quickly add powerful text searching capabilities to your APEX application.
We’ll look at: Strategies for gathering and indexing textual data to be searched — Indexing of BLOBs containing PDFs or Word documents — Indexing of structured documents such as XML or JSON — Searching your data using the Oracle Text syntax — Different search types such as word , phrase, stem, etc. — Searching within tags — Google-like highlighting of snippets in search results.