how to find find & delete duplicate rows from two different
tables?
- 3 Answers
- 10882 Views
- Accenture, TCS, I also Faced
- E-Mail Answers
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
What is a proxy class?
Name the three major set of files on disk that compose a database in Oracle?
What is proxy method?
What are the four Oracle system processes that must always be up and running for the database to be useable?
What are the different editions of oracle?
How to create an initialization parameter file?
What are the attributes of the cursor?
What privilege is needed for a user to insert rows to tables in another schema?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
How to lock and unlock a user account in oracle?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
What is columnar storage what is the advantage?
How do I spool to a csv formatted file using sqlplus?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
