A common use of Oracle Text is to index HTML files on websites and provide search capabilities to users. The sample application in this appendix indexes a set of HTML files stored in the database. It also uses a web server connected to Oracle Database to provide the search service.

This appendix describes two versions of the Web query application:

• One using PL/SQL Server Pages (PSP)

• One using Java Server Pages (JSP)

Figure A-1 shows the JSP version of the text query application.

Figure A-2 shows the results of the text query.

The application returns links to documents containing the search term. Each document has four links:

• The HTML link displays the document.

  Graphics are not displayed in the filtered document.

• The Highlight link displays the document with the search term highlighted.

• The Theme link shows the top 50 themes associated with the document.

  The Gist link displays a short summary of the document.