Re: Function CONTAINSTABLE in MSSQL TO Oracle
Date: Fri, 3 Oct 2008 03:51:03 -0700 (PDT)
Message-ID: <3485e34f-add1-47dc-a0a1-cdb05e0efcce@79g2000hsk.googlegroups.com>
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
Received on Fri Oct 03 2008 - 05:51:03 CDT