DELETE FROM table1 WHERE (col1,col2,..) IN (SELECT col1,col2,.. FROM tabl

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

Question Posted / vinoth kumar

Answer Posted / vinoth kumar

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

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is execute immediate?

1159

What is bind variable in pl sql?

1102

How do I partition a table in sql?

1201

Explain about various levels of constraint.

996

What is microsoft t sql?

984

how is myisam table stored? : Sql dba

1097

Is join and inner join the same?

1040

What are sql built in functions?

978

How many types of indexes are there in sql?

1039

What is server name sql?

1201

State few characteristics of pl/sql?

1020

What are system versioned tables?

1069

what is union? : Sql dba

1080

what does the t-sql command ident_incr does? : Transact sql

1122

How to read xml file in oracle pl sql?

947