Re: Function CONTAINSTABLE in MSSQL TO Oracle

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
Received on Thu Oct 02 2008 - 11:05:41 CDT