Re: Function CONTAINSTABLE in MSSQL TO Oracle

<mmf.stavelot_at_gmail.com> schreef in bericht news:32c64f2c-3fe9-452f-b6a0-76f1c22951fd_at_l76g2000hse.googlegroups.com...
> 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.

Please don't top post.

Solution
set the compiler option
$ORACLESYNTAXMSSQL before performing your query.

MShakespeare Received on Fri Oct 03 2008 - 04:03:51 CDT