Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Compare rows in diffrent table

Compare rows in diffrent table

From: vikram morey <vikram_morey_at_rediffmail.com>
Date: 11 Jun 2002 01:45:07 -0700
Message-ID: <1df1ef17.0206110045.58672433@posting.google.com> 





Dear All



I have a problem. 



I want to compare rows in the tables in my schema. If any two rows are
identical by any combination in any given table, it should not allow
me to delete the same.



Can someone help me out, by giving a solurtion for that. I am thinking
of writing a procedure using minus and union all, or writing a before
delete trigger.



Which will be better and how to do it.



Thanks,



Vikram
Received on Tue Jun 11 2002 - 03:45:07 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US