Database development

Niall Mc Phillips

Oracle Text - A powerful tool for Oracle APEX (and other) developers

Niall Mc Phillips
Long Acre sàrl
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

Informacije o predavanju

Jezik / Language: ENG


O Avtorju

Niall Mc Phillips has been developing using Oracle since Oracle V5, has been using Oracle PL/SQL Web technologies since 1995 and Oracle APEX since 2005. Niall has developed a number of large, multi-lingual applications for multinational companies and organisations 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 organiser of the Swiss APEX Meetup group and, in the past, has presented at 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.