Trigger Question-2


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Trigger Question-2

  1. #1
    Sheryl Kemp Guest

    Trigger Question-2


    Yes, I have made the Oracle server a linked server in SQL. Is there any way
    to update the oracle table with a timestamp based on that record existing
    in the table on sql?




    you should probably should post this as a new post. The Oracle server is
    a
    >linker server w/in SQL Server ?



  2. #2
    DaveSatz Guest

    Re: Trigger Question-2

    something like:
    if exists ( select 1
    from oracle.mydb..table o
    where exists ( select 1
    from inserted i
    where i.theid = o.theid)
    )
    begin
    update oracle.mydb..table
    set timestamp = getdate() -- ?
    from oracle.mydb..table o
    where exists ( select 1
    from inserted i
    where i.theid = o.theid)
    end



    --
    HTH,
    David Satz
    Principal Software Engineer
    Hyperion Solutions
    ->Using SQL Server 7.0 SP3/6.5 SP5a/Cold Fusion 4.5.1 SP2/VSS
    (Please reply to group only - emails answered rarely)
    -----------------------------------------------------------------

    "Sheryl Kemp" <Dianedinero@aol.com> wrote in message
    news:3b545f4b$1@news.devx.com...
    >
    > Yes, I have made the Oracle server a linked server in SQL. Is there any

    way
    > to update the oracle table with a timestamp based on that record existing
    > in the table on sql?
    >
    >
    >
    >
    > you should probably should post this as a new post. The Oracle server is
    > a
    > >linker server w/in SQL Server ?

    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center