Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    8

    Unanswered: Compare data two identical tables ?

    Hello,

    Iīm still newbee, so forgive if the question is stupid...

    Is there an easy way to compare data between two identical tables ?

    I know I can use the minus command.
    But I also want to see the "modified" records ...

    Maybe someone has got a script written in plsql or sql ?
    Thanks anyway !

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    With minus you will see modified records...
    I think the minus will do what you want.
    You will see all the records that are not the same.

    Groetjes

    Ruud
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

Posting Permissions

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