Post reply

insert into linked server table in Oracle

  • May 8, 2003 at 2:35 pm

    #81485

    What is the syntax to insert into an Oracle table from SQL Server 2000 that has already been linked using sp_addlinkedserver.

  • May 8, 2003 at 6:55 pm

    #456611

    Use four-part name to access linked server, ie linkedserver.catalog.schema.tablename. For example.

    select * from EA..EXAV.GROUPS

    insert into EA..EXAV.GROUPS values ('Test', 'Test', 9, 381273546)

    INSERT statements should supply values for all columns in a table even if certain columns in the table can be NULL or have default values.

  • May 9, 2003 at 4:34 am

    #456643

    This forums thread should be of help

    http://dbforums.com/arch/7/2002/3/331663

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

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