Skip to Main Content

Oracle Application Express Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours.

Header container

January 24, 2019

Find Anything In Your APEX App - Fuzzy Search with Oracle Text
Ever had a requirement to add fuzzy search to your APEX application ...? And did you know that Oracle Database and APEX provide everything you need?

This Application Express Office Hours session shows how to provide error-tolerant searching to your end users using Application Express and the Oracle TEXT database feature. Oracle TEXT allows to build just one Index for all your data and it provides linguistic and fuzzy search capabilities. The APEX Interactive Grid component allows to declaratively integrate such an index - however, other APEX components can leverage Oracle TEXT as well. The session shows how to build the Oracle Text index and how to use it with various APEX components. Tips and Tricks for practical usage will wrap the session up.

Slides: https://www.slideshare.net/CarstenCzarski/find-anything-in-your-apex-app-fuzzy-s earch-with-oracle-text

Chat: http://bit.ly/apex_office_hours_chat__20190124

Video Highlights:
[2:50] Introduction
[8:30] Oracle Text
[11:25] APEX Interactive Grid Demo
[15:10] Oracle Text Fundamentals
[24:00] Demo - Building a new Text Index
[42:40] Summary
[44:30] Questions and Answers

Subscribe to give us feedback and be notified of upcoming sessions!

Ask a Question

Ask The Experts - Right Now!

Do you have a question about Application Express you'd like our experts to answer in their next session? Sign in and submit it here.

Please note that we cannot guarantee to answer all questions. We cannot help you with open Service Requests or account/licensing issues.

Experts

Your Experts
Carsten Czarski
Carsten Czarski, Consulting Member of Technical Staff    
Carsten Czarski is a member of the Oracle APEX development team, focusing on REST-related features, data loading and the Calendar component. He's also a pro on Oracle Spatial, Oracle Text, and JSON and XML functionality in the database.
David Peake
David Peake, Senior Principal Product Manager - Application Express    
David joined Oracle in 1993. He spent the first 13 years within Oracle Consulting in Australia, New Zealand, and the United States. In 2006, he joined the Product Development team as the Oracle Application Express (APEX) Product Manager. He presents at many conferences around the world including Oracle Openworld, ODTUG KScope, OGh APEX World, DOAG and UKOUG.
Chaitanya Koratamaddi
Chaitanya Koratamaddi, Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies    
Chaitanya is a Principal Product Manager for Oracle Application Express. Chaitanya has extensive knowledge and experience on various Oracle technologies such as Oracle Application Express, Oracle SQL Developer, SQL Developer Data Modeler, Oracle Database, Oracle XML DB, Oracle Database XE, Oracle Database Vault, Oracle REST Data Services, and Oracle Fusion Middleware. Chaitanya is a regular speaker at various global conferences like Oracle Open World, OTN Yathra, Oracle Code, Oracle Develop, Oracle Cloud World, OTN Developer Days, ODTUG, JavaOne, AIOUG Tech Days, Sangam, and other user groups. Chaitanya writes his technical blog @ http://chaitanyain.blogspot.com/.