Interested to Buy Any Domain ? << Click Here >> for more details...
how to find find & delete duplicate rows from two different
tables?
- 3 Answers
- 11809 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 are the oracle DML commands possible through an update strategy?
What are the built-in functions used for sending Parameters to forms ?
Explain the blob datatype?
How to create tables for odbc connection testing?
What are the various oracle database objects?
How to do a full database export?
Differentiate between pre-select and pre-query?
Which are the five query types available in oracle?
Explain the use of rows option in exp command.
How a tablespace is related to data files?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How to calculate date and time differences in oracle?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What are data pump export and import modes?
What is the usage of synonyms?
