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
Difference between varchar and varchar2 data types?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
Explain the use of parfile option in exp command.
What exactly do quotation marks around the table name do?
What is archive log in Oracle?
What is the difference between a user and a schema in oracle?
What is the difference between sharding and replication?
How to generate query output in html format?
How do I call oracle stored procedures that take no parameters?
How many anonymous blocks can be defined?
what is insert all statement in sql
Does oracle database need java?
What is a database table in oracle?
Explain user account with reference to oracle.
How to filter out duplications in the returning rows using oracle?