how to delete duplicate rows from a specified table(only
single table)
how do you know which join is need to be used
Answer Posted / jas
delete from table_name where rowid > (select min(rowid)
from table_name where a.col_name=b.col_name)
create new_table as select distinct * from table_name;
drop table_name;
create table_name as select * from new_table;
drop new_table;
delete from table_name where rowid not in (select max
(rowid) from table_name where a.col_name=b.col_name)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is nvl?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
Where the sql database files are stored?
Differentiate pl/sql and sql?
How run sql*plus commands that are stored in a local file?
What are the two types of cursors in pl sql?
Explain the the delete statements in sql?
Can you call pl/sql package functions from within a fast formula?
Define sql delete statement.
What is recursive stored procedure?
What is a recursive stored procedure?
How can you view the errors encountered in a trigger?
How many types of cursors are available in pl/sql?
What is normalization sql?
How many sql are there?