![]() | |
![]() |
| | Thread Tools | Display Modes |
#31
| |||
| |||
|
|
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 |
#32
| |||
| |||
|
|
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 |
#33
| |||
| |||
|
|
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 |
#34
| |||
| |||
|
#35
| |||
| |||
|
#36
| |||
| |||
|
#37
| |||
| |||
|
![]() |
| Thread Tools | |
| Display Modes | |
| |