Answer / vinoth kumar

DELETE FROM table1 WHERE
(col1,col2,..) IN (SELECT col1,col2,.. FROM table2 where
condition)

Answer / radha sri seshu.kolla

while creating table and giving foreign key constraint give
the key word 'on delete cascade'.automatically when the
record in the master table is delated the relaeted record
in the detail table will also be deleted.

Answer / umadevi

example

delete from emp where deptno in (select deptno from dept
where emp.deptno=dept.deptno);

Answer / senthil

This done by Co-related sub-query:- based upon ROWID
uniqness this deletes the duplicate rows.

Delete from emp x where ROWID != (Select MIN(ROWID) from
emp y where y.empno = x.empno);

define sql insert statement ? : Sql dba

0 Answers  

---

What is dba in sql? : SQL DBA

0 Answers  

---

What are all the common sql functions?

0 Answers  

---

Can you alter start with clause?

1 Answers   TCS,

---

What is %type in pl sql?

0 Answers  

---

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers  

---

when a procedure /package is getting invalidated?

4 Answers   TCS,

---

write an sql query to find names of employee start with 'a'? : Sql dba

0 Answers  

---

How do you assign Construct the where clause without concatenating Field,value pairs?

1 Answers   Microsoft,

---

What are the two types of periodical indexes?

0 Answers  

---

how to use case expression? : Sql dba

0 Answers  

---

What is sql basics?

0 Answers  

---