dbTalk Databases Forums  

Function CONTAINSTABLE in MSSQL TO Oracle

Go Back dbTalk Databases Forums Databases comp.databases.oracle.misc 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
Page 1 of 4 1 2 3 4 >
 
Thread Tools Display Modes
  #1  
Old   
mmf.stavelot@gmail.com
 
Posts: n/a

Default Function CONTAINSTABLE in MSSQL TO Oracle - 10-02-2008 , 07:57 AM





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]


Thanks

St. Mr

Reply With Quote
  #2  
Old   
Michel Cadot
 
Posts: n/a

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-02-2008 , 10:40 AM






<mmf.stavelot (AT) gmail (DOT) com> a écrit dans le message de news: 3a5b6f5b-e0af-4cbc-8217-42cdda2fa15c...oglegroups.com...
Quote:
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]


Thanks

St. Mr
Explain what does this function do.

Regards
Michel




Reply With Quote
  #3  
Old   
Michel Cadot
 
Posts: n/a

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-02-2008 , 10:40 AM



<mmf.stavelot (AT) gmail (DOT) com> a écrit dans le message de news: 3a5b6f5b-e0af-4cbc-8217-42cdda2fa15c...oglegroups.com...
Quote:
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]


Thanks

St. Mr
Explain what does this function do.

Regards
Michel




Reply With Quote
  #4  
Old   
Michel Cadot
 
Posts: n/a

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-02-2008 , 10:40 AM



<mmf.stavelot (AT) gmail (DOT) com> a écrit dans le message de news: 3a5b6f5b-e0af-4cbc-8217-42cdda2fa15c...oglegroups.com...
Quote:
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]


Thanks

St. Mr
Explain what does this function do.

Regards
Michel




Reply With Quote
  #5  
Old   
Michel Cadot
 
Posts: n/a

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-02-2008 , 10:40 AM



<mmf.stavelot (AT) gmail (DOT) com> a écrit dans le message de news: 3a5b6f5b-e0af-4cbc-8217-42cdda2fa15c...oglegroups.com...
Quote:
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]


Thanks

St. Mr
Explain what does this function do.

Regards
Michel




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

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-02-2008 , 11:05 AM


In MSSQL CONTAINSTABLE:

Returns a table of zero, one, or more rows for those columns
containing character-based data types for precise or fuzzy (less
precise) matches to single words and phrases, the proximity of words
within a certain distance of one another, or weighted matches.
CONTAINSTABLE can be referenced in the FROM clause of a SELECT
statement as if it were a regular table name.

Kind Regards,

St. Mr

Michel Cadot wrote:
Quote:
mmf.stavelot (AT) gmail (DOT) com> a �crit dans le message de news: 3a5b6f5b-e0af-4cbc-8217-42cdda2fa15c...oglegroups.com...
| 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]
|
|
| Thanks
|
| St. Mr

Explain what does this function do.

Regards
Michel

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

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-02-2008 , 11:05 AM


In MSSQL CONTAINSTABLE:

Returns a table of zero, one, or more rows for those columns
containing character-based data types for precise or fuzzy (less
precise) matches to single words and phrases, the proximity of words
within a certain distance of one another, or weighted matches.
CONTAINSTABLE can be referenced in the FROM clause of a SELECT
statement as if it were a regular table name.

Kind Regards,

St. Mr

Michel Cadot wrote:
Quote:
mmf.stavelot (AT) gmail (DOT) com> a �crit dans le message de news: 3a5b6f5b-e0af-4cbc-8217-42cdda2fa15c...oglegroups.com...
| 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]
|
|
| Thanks
|
| St. Mr

Explain what does this function do.

Regards
Michel

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

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-02-2008 , 11:05 AM


In MSSQL CONTAINSTABLE:

Returns a table of zero, one, or more rows for those columns
containing character-based data types for precise or fuzzy (less
precise) matches to single words and phrases, the proximity of words
within a certain distance of one another, or weighted matches.
CONTAINSTABLE can be referenced in the FROM clause of a SELECT
statement as if it were a regular table name.

Kind Regards,

St. Mr

Michel Cadot wrote:
Quote:
mmf.stavelot (AT) gmail (DOT) com> a �crit dans le message de news: 3a5b6f5b-e0af-4cbc-8217-42cdda2fa15c...oglegroups.com...
| 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]
|
|
| Thanks
|
| St. Mr

Explain what does this function do.

Regards
Michel

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

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-02-2008 , 11:05 AM


In MSSQL CONTAINSTABLE:

Returns a table of zero, one, or more rows for those columns
containing character-based data types for precise or fuzzy (less
precise) matches to single words and phrases, the proximity of words
within a certain distance of one another, or weighted matches.
CONTAINSTABLE can be referenced in the FROM clause of a SELECT
statement as if it were a regular table name.

Kind Regards,

St. Mr

Michel Cadot wrote:
Quote:
mmf.stavelot (AT) gmail (DOT) com> a �crit dans le message de news: 3a5b6f5b-e0af-4cbc-8217-42cdda2fa15c...oglegroups.com...
| 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]
|
|
| Thanks
|
| St. Mr

Explain what does this function do.

Regards
Michel

Reply With Quote
  #10  
Old   
DA Morgan
 
Posts: n/a

Default Re: Function CONTAINSTABLE in MSSQL TO Oracle - 10-02-2008 , 05:24 PM


mmf.stavelot (AT) gmail (DOT) com wrote:
Quote:
In MSSQL CONTAINSTABLE:

Returns a table of zero, one, or more rows for those columns
containing character-based data types for precise or fuzzy (less
precise) matches to single words and phrases, the proximity of words
within a certain distance of one another, or weighted matches.
CONTAINSTABLE can be referenced in the FROM clause of a SELECT
statement as if it were a regular table name.

Kind Regards,

St. Mr

Michel Cadot wrote:
mmf.stavelot (AT) gmail (DOT) com> a �crit dans le message de news: 3a5b6f5b-e0af-4cbc-8217-42cdda2fa15c...oglegroups.com...
| 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]
|
|
| Thanks
|
| St. Mr

Explain what does this function do.

Regards
Michel
Go to http://tahiti.oracle.com and for your version look up:
Oracle Text and Context

Daniel A. Morgan
Oracle Ace Director
University of Washington


Reply With Quote
Reply
Page 1 of 4 1 2 3 4 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

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.


Contact Us - dbTalk Databases Forums - Archive - Top