Re: Function CONTAINSTABLE in MSSQL TO Oracle
Date: Fri, 3 Oct 2008 03:38:50 -0700 (PDT)
Thanks, this good solution, but I would like to solve his means SQL
> <mmf.stavelot_at_gmail.com> schreef in bericht
> > 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.
> set the compiler option
> before performing your query.
Received on Fri Oct 03 2008 - 05:38:50 CDT