Almost every application I create contains a BLOB (file) table for storing files available for a download. In the most of the cases it will store some documentation related to the application - user manuals, howto's and similar stuff. The download functionality is a nice thing but how about searching the content of those files? There are some examples arround showing how to do that in ApEx but in my opinion the most of them are far to complex. I created an example in my Demo Application, showing how to do that in less than five minutes:
This example includes the most frequently used functionalities:
1. mixed case search
2. highlighted snippets
3. index synchronization on commit
If you need more, you can always look into the Oracle Text Documentation.