Oracle Text—A powerful Tool for Oracle APEX (and Other) Developers

Session Number: 8066
Track: Application Express
Sub-Categorization: APEX Integration
Session Type: Tips, Techniques and Tuning
Primary Presenter: Niall Mc Phillips [Owner and CEO - Long Acre]
Time: Jun 26, 2019 (10:15 AM - 11:15 AM)
Room: 615, Level 6

Speaker Bio: Niall Mc Phillips has been developing using Oracle since Oracle V5. He has been using Oracle PL/SQL web technologies since 1995 and Oracle APEX since 2005. Niall has developed a number of large multilingual applications for multinational companies and organizations all over the world. Several of these receive tens of millions of views per year.

Niall is a strong believer in APEX solutions because of their stability, scalability, and rapid development speed. He is the organizer of the Swiss APEX Meetup group and, in the past, he has presented at ODTUG Kscope and other conferences on the use of APEX with Oracle Multimedia, Oracle Text, and also on his experiences with the implementation of large Oracle APEX projects.
Technologies or Products Used: Oracle Text, Oracle database, Oracle APEX

Session Summary for Attendees:  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