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:
http://apex.oracle.com/pls/otn/f?p=31517:76
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.
Enjoy.
This is a great post. Very simple and straight forward and really helpful.
ReplyDeleteI am curious why you need to create a lexar, I understood a "generic" oracle text index to use mixed case anyway.
Tony,
ReplyDeleteThanks. As far as the standard is concerned, I think that it is case sensitive.
Denes Kubicek
in CTX_DOC.SNIPPET(...,textkey,...) or the second parameter in your code is ROWID, i get DRG-50857: oracle error in drvdoc.get_rowid, unless i use table primary key column (like my_file_table.id).
ReplyDeletethanks for the code!
Hi,
ReplyDeletecan you send source code of blob search appliction for Oracle application express
vasusenthil@gmail.com
Hello,
ReplyDeleteI am not sending the source code to anyone since it would be too much work. If you follow the instructions on the login page of my application, you will be able to export it yourself.
Denes Kubicek