Interested to Buy Any Domain ? << Click Here >> for more details...
how to find find & delete duplicate rows from two different
tables?
- 3 Answers
- 11595 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
How do we get field detail of a table?
How to rename an index?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
How to call a stored function with parameters?
What is a system tablespace and when it is created?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What is the difference between translate and replace?
How does oracle handle read consistency?
What is MTTR advisor in Oracle?
Explain overloading. Can functions be overloaded?
How to select some columns from a table in oracle?
How to display row numbers with the records?
How to view the data files in the current database?
How to assign values to data fields in record variables?
What are the most common interview questions on ETL Testing for experience?
