Re: Function CONTAINSTABLE in MSSQL TO Oracle

Thanks for answers, but I would like to see as this example in Oracle will look:

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

Malcolm Dew-Jones wrote:
> mmf.stavelot_at_gmail.com wrote:
> : 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]
>
>
> I'm guessing, but I would think that things liked pipelined functions and
> the CAST ... AS "function" would be a place to look.
Received on Fri Oct 03 2008 - 02:19:21 CDT