Interested to Buy Any Domain ? << Click Here >> for more details...
how to delete all duplicate records from a table using
subquery?
- 7 Answers
- 23420 Views
- ABC, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / maninder
delete from abc where rowid not in (select max(rowid) from
abc group by column_name_with_dup.values.);
| Is This Answer Correct ? | 10 Yes | 6 No |
Post New Answer View All Answers
What is a snapshot log?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What is a proxy object?
How to convert dates to characters in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
How to update a table row with a record?
What is translate in oracle?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How to open a cursor variable?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
Explain oracle’s system global area (sga).
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How to loop through data rows in the implicit cursor?
Explain an exception?
