dbTalk Databases Forums  

Function CONTAINSTABLE in MSSQL TO Oracle

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Function CONTAINSTABLE in MSSQL TO Oracle in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #31  
Old   
mmf.stavelot@gmail.com
 
Posts: n/a

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-03-2008 , 05:51 AM






Where it is possible to learn as to use given option
$ORACLESYNTAXMSSQL more in detail?

Thanks

St. Mr

Shakespeare wrote:
Quote:
mmf.stavelot (AT) gmail (DOT) com> schreef in bericht
news:32c64f2c-3fe9-452f-b6a0-76f1c22951fd (AT) l76g2000hse (DOT) 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 (DOT) 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

Reply With Quote
  #32  
Old   
mmf.stavelot@gmail.com
 
Posts: n/a

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-03-2008 , 05:51 AM






Where it is possible to learn as to use given option
$ORACLESYNTAXMSSQL more in detail?

Thanks

St. Mr

Shakespeare wrote:
Quote:
mmf.stavelot (AT) gmail (DOT) com> schreef in bericht
news:32c64f2c-3fe9-452f-b6a0-76f1c22951fd (AT) l76g2000hse (DOT) 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 (DOT) 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

Reply With Quote
  #33  
Old   
mmf.stavelot@gmail.com
 
Posts: n/a

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-03-2008 , 05:51 AM



Where it is possible to learn as to use given option
$ORACLESYNTAXMSSQL more in detail?

Thanks

St. Mr

Shakespeare wrote:
Quote:
mmf.stavelot (AT) gmail (DOT) com> schreef in bericht
news:32c64f2c-3fe9-452f-b6a0-76f1c22951fd (AT) l76g2000hse (DOT) 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 (DOT) 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

Reply With Quote
  #34  
Old   
Malcolm Dew-Jones
 
Posts: n/a

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-03-2008 , 04:41 PM



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

;


mmf.stavelot (AT) gmail (DOT) 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 (DOT) com> schreef in bericht
: > news:32c64f2c-3fe9-452f-b6a0-76f1c22951fd (AT) l76g2000hse (DOT) 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 (DOT) 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

--

Reply With Quote
  #35  
Old   
Malcolm Dew-Jones
 
Posts: n/a

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-03-2008 , 04:41 PM



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

;


mmf.stavelot (AT) gmail (DOT) 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 (DOT) com> schreef in bericht
: > news:32c64f2c-3fe9-452f-b6a0-76f1c22951fd (AT) l76g2000hse (DOT) 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 (DOT) 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

--

Reply With Quote
  #36  
Old   
Malcolm Dew-Jones
 
Posts: n/a

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-03-2008 , 04:41 PM



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

;


mmf.stavelot (AT) gmail (DOT) 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 (DOT) com> schreef in bericht
: > news:32c64f2c-3fe9-452f-b6a0-76f1c22951fd (AT) l76g2000hse (DOT) 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 (DOT) 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

--

Reply With Quote
  #37  
Old   
Malcolm Dew-Jones
 
Posts: n/a

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-03-2008 , 04:41 PM



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

;


mmf.stavelot (AT) gmail (DOT) 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 (DOT) com> schreef in bericht
: > news:32c64f2c-3fe9-452f-b6a0-76f1c22951fd (AT) l76g2000hse (DOT) 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 (DOT) 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

--

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.