Post reply

Wildcard searches using brackets against oracle linked server

  • June 29, 2009 at 3:40 pm

    #72848

    Hi

    I have the following query

    SELECT ITEMS from

    FROM ORACLELINKED

    WHERE ITEM_NUMBER LIKE '50-[012]5%'

    Its running off 8i Oracle server,

    We are doing test to upgrade the Oracle Server to 9.2

    Since the upgrade test, we had moved to using

    select * from openquery (ORACLELINKED, 'SELECT ITEMS from

    WHERE ITEM_NUMBER LIKE '50-[012]5%')

    The openquery works fine under the old Oracle 8i but not the 9.2. Any suggestions in formatting?

    Thanks,

  • June 30, 2009 at 3:44 pm

    #1018030

    Looks like you changed your query from linked server with 4-part names to openquery. In the first case the query is run in SQLServer against data residing in Oracle, in the second is Oracle itself that executes the query, so you'll have to use Oracle syntax.

    Hope this helps

    Gianluca

    -- Gianluca Sartori

  • July 1, 2009 at 11:43 am

    #1018621

    Thanks for the reply. It took a while to figure the issue, I ended up just specifying all the cases.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply