Answer Posted / santosh kumar

simple answer for deleting duplicate record from a table.....
table:---
create table t1 (id number(5),name varchar2(20));

then:----
insert into t1 values(10,'a');
insert into t1 values(10,'a');
insert into t1 values(20,'b');
insert into t1 values(20,'b');
---after insertion it'll like this----
id name
10 a
10 a
20 b
20 b

-------------------------------------------------------------
delete from t1
where rowid not in (select min(rowid) from t1 group by name);

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

1011

---

Determine if oracle date is on a weekend?

1087

---

Why does sql need a server?

1083

---

What is record data type?

979

---

How do I run a program in pl sql?

1053

---

What is data definition language?

1135

---

Why truncate is used in sql?

1043

---

What is sqlerrd?

1015

---

What are sql triggers used for?

1035

---

Is pl sql better than sql?

1086

---

Are subqueries faster than joins?

1076

---

What is package in pl sql with an examples?

1084

---

How do I view a sql trace file?

1061

---

what is acid property in database? : Sql dba

1067

---

What is the most restrictive isolation level? : Transact sql

1124

---