Write an SQL Query to
Delete Duplicate records from a table using ROWID.
Answer Posted / koti
Ganesh ,You are right very good.
delete from emp t
where rowid != ( select min(rowid)
from empno
where empno = t.empno );
---------And other answers are not right .
| Is This Answer Correct ? | 15 Yes | 16 No |
Post New Answer View All Answers
How can a process be deployed in soa?
What do you understand by soa and what are the benefits of using this architecture?
Do you know what are user profiles in apps. Any examples you can give?
A program must be written which accepts date parameter. The date parameter will accept data in the format DD/MM/YYYY. This data has to be validated and post validation, the following details have to be displayed for this date parameter 1. Input date must be defaulted to sysdate, It can be overridden by any other date. 2. Financial year should be displayed for this date parameter. Eg: If the input date is 30/11/2010, the financial year must be displayed as 1. From Date : 01-Aprr-2010 To Date: 31-Mar-2011 3. Calendar year and Calendar month must also be displayed. 4. The next payment cycle (say for EB), must be displayed based on this date parameter. 5. The previous payment must also be displayed based on this date.
Can you explain the difference between architecture followed in 10g & 11g?
what are the balancing segments in AR?
what are the prerequisites for costing transactions?
What is oracle soa suite and what are its different components?
Can u give the Documentation of Custom.pll in oracle apps
tell me the scenarios of the independent in reports
how do you describe O2C along with tables
tell my any difficult situtation you solved in your experience in your company?
How to move the one file from one instance to another instance? And your scripts also?
Plz anybody send me Technical specification for AP Interface
List the types of flexfield?