how to find find & delete duplicate rows from two different
tables?
Answer Posted / k.sailesh
We can find duplicate rows from two tables by using select *
from table name. it displays all the values repeated and unique.
We can delete duplicate rows by using Primary key constraint.
| Is This Answer Correct ? | 3 Yes | 17 No |
Post New Answer View All Answers
How will you identify oracle database software release?
what is Single Byte Overhead...?
How do I connect to oracle?
What is a cursor variable?
How to write a query with an inner join in oracle?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is the difference between substr & instr functions?
How do I find my oracle client driver version?
What is a synonym? What are its various types?
What are the database administrators utilities available?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What are dml statements in oracle?
Is it possible to split the print reviewer into more than one region ?
What is max rowid in oracle?
Can we create database in oracle using command line ?