Interested to Buy Any Domain ? << Click Here >> for more details...
Write an SQL Query to
Delete Duplicate records from a table using ROWID.
- 24 Answers
- 77841 Views
- pspl, Satyam, Thinkways, I also Faced
- E-Mail Answers
Answer Posted / parthasarathi
delete tab1 where (col1_dup,rowid) in (select
col1_dup,max(rowid) from tab1 where group by col1_dup having
count(col1_dup)>1);
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you understand by soa and what are the benefits of using this architecture?
What is a flexfield? List out its types.
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.
what is pay run id ?
What is oracle soa suite and what are its different components?
What is sca and how is it useful?
tell me the scenarios of the independent in reports
where to define interorganization transaction charges and what are the different options?
Plz anybody send me Technical specification for AP Interface
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Do you know what are user profiles in apps. Any examples you can give?
What are do's and dont's of Interface?
Tell me how to find the custom directory in front end?
Do you know where we can check the status of po?
What is the concept of soa governance?
