Results 1 to 2 of 2

Thread: Trigger

  1. #1
    Join Date
    Aug 2003

    Unanswered: Trigger

    I am trying to make a trigger that will delete doubles from a certain table in my Oracle database. I want to refresh the data in this table from a SQL Server table once a week. What I have is the old data in the Oracle table and then the new data from the Server table. Most of the old records and new records will be the same, so I want to eliminate the doubles.

  2. #2
    Join Date
    Sep 2002
    Provided Answers: 1

    Re: Trigger

    Rather than insert everything and then delete you should insert only that which is new.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts