Answer Posted / umadevi

--deletes records within table without changing table name
delete from temp t1 where rowid<(select max(rowid) from temp
t2 where t1.empno=t2.empno) order by empno;

or
--create new table n insert records.
create table t1 as select distinct * from temp;

or
(truncate table)
truncate table t1;
insert into t1 select distinct * from temp;

What is output spooling in sql*plus?

1035

---

What are local and global Indexes and where they are useful.

1444

---

What is pl sql block structure?

1036

---

What is t sql in sql server?

1075

---

Can a table contain multiple foreign key’s?

997

---

How to install oracle sql developer?

1046

---

Is postgresql a server?

1055

---

what is self join and what is the requirement of self join? : Sql dba

1145

---

What are reports usually used for?

1023

---

How is debugging done?

981

---

what is try_catch block in procedure

1748

---

how to check server status with 'mysqladmin'? : Sql dba

1075

---

What is dml statement?

956

---

What is sql clause?

1051

---

What is a sql driver?

999

---