Re: Function CONTAINSTABLE in MSSQL TO Oracle

That sort of detail is most likely found at topost-thwacker.com, I should think.

 ;

mmf.stavelot_at_gmail.com wrote:
: Where it is possible to learn as to use given option
: $ORACLESYNTAXMSSQL more in detail?

: Thanks

: St. Mr

: Shakespeare wrote:
: > <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

--