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
Whether any commands are used for months calculation? If so, what are they?
How to export several tables together?
What are the tools for Oracle ?
How do we display rows from the table without duplicates?
What is Undo Management Advisor in Oracle?
Difference between hot backup vs. Cold backup?
What is ordinary table in oracle?
Difference between pre-select and pre-query
How to create a temporary table in oracle?
What is the difference between substr and instr?
Explain index?
How to generate query output in html format?
What is a named program unit?
How would you begin to troubleshoot an ORA-3113 error?
Can the query output be sorted by multiple columns in oracle?