Waliaula Makokha
Reputation: 815
Oracle Full Text Search
Which data type in Oracle 10 and 11g is best suited for full text search to be conducted on. I am thinking BLOB?
Upvotes: 1
Views: 1925
Answers (1)
bpgergo
Reputation: 16037
It could be varchar2, clob, or blob. It depends on the size of a chunk of text that will be in a record. docs: http://download.oracle.com/docs/cd/B28359_01/text.111/b28303/ind.htm
EDIT here's a basic introduction http://www.oracle-base.com/articles/9i/FullTextIndexingUsingOracleText9i.php
Upvotes: 1
Related Questions
- Does Oracle support full text search?
- Full text search
- Full text search in all columns in Oracle
- ORACLE TEXT SEARCH
- SQL Server full-text search
- Oracle Full Text how to search similar words
- FullText Search priory
- SQL Server Full Text Searching
- Oracle: Full text search with condition
- Full text search in SQL Server and Oracle