Re: Function CONTAINSTABLE in MSSQL TO Oracle

mmf.stavelot_at_gmail.com wrote:
> In MSSQL CONTAINSTABLE:
>
> Returns a table of zero, one, or more rows for those columns
> containing character-based data types for precise or fuzzy (less
> precise) matches to single words and phrases, the proximity of words
> within a certain distance of one another, or weighted matches.
> CONTAINSTABLE can be referenced in the FROM clause of a SELECT
> statement as if it were a regular table name.
>
> Kind Regards,
>
> St. Mr
>
> Michel Cadot wrote:

>> <mmf.stavelot_at_gmail.com> a �crit dans le message de news: 3a5b6f5b-e0af-4cbc-8217-42cdda2fa15c_at_j68g2000hsf.googlegroups.com...
>> | Hi,
>> |
>> | To what can find an equivalent for function CONTAINSTABLE in Oracle?
>> |
>> | MSSQL:
>> |
>> | SELECT select_list
>> | FROM table AS FT_TBL INNER JOIN
>> |   CONTAINSTABLE(table, column, contains_search_condition) AS KEY_TBL
>> |   ON FT_TBL.unique_key_column = KEY_TBL.[KEY]
>> |
>> |
>> | Thanks
>> |
>> | St. Mr
>>
>> Explain what does this function do.
>>
>> Regards
>> Michel

Go to http://tahiti.oracle.com and for your version look up: Oracle Text and Context

Daniel A. Morgan
Oracle Ace Director
University of Washington Received on Thu Oct 02 2008 - 17:24:01 CDT