example delete from emp where deptno in (select deptno from dept where

write a query to delete similar records in different tables
with same structure

Question Posted / umadevi

Answer Posted / umadevi

example

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

Is This Answer Correct ?

3 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Mention what does the hierarchical profiler does?

555

What are its different types of dbms?

531

What are actual parameters and formal parameters?

560

How show all rows in sql?

602

Can we use ddl statements in stored procedure?

691

How subquery works in sql?

535

Is grant a ddl statement?

449

Is subquery faster than join?

566

Name the operator which is used in the query for pattern matching?

501

What is an index in sql with example?

510

What are the ways on commenting in a pl/sql code?

509

How do you go back in sql?

526

How do I start pl sql?

486

How do I enable sql encryption?

516

How do you change a value in sql?

546