Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / murugaraj.g
HERE COLUMN_NAME IN ( SELECT COLUMN_NAME FROM TABLE D
WHERE D.COLUMN_NAME_1=E.COLUMN_NAME_1
MINUS
SELECT COLUMN_NAME FROM TABLE F
WHERE F.COLUMN_NAME_1 = E.COLUMN_NAME_1
AND ROWNUM = 1);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
How many schemas we have? how many you have used?
What are do's and dont's of Interface?
tell my any difficult situtation you solved in your experience in your company?
How can we import the data into a database using sql * loader?
where to define interorganization transaction charges and what are the different options?
What is the concept of soa governance?
How is choreography different from orchestration?
How do you register report in oracle apps?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
what are the balancing segments in AR?
What are the Standard Reports and Forms in HRMS?
what is global tempory table?
is it possible to run the interface without using oracle apps?
What do you understand by a set of books?