Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in particular
fields(columns) in different tables
- 6 Answers
- 13894 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ram
Guys, Please see the question again. It is related to
deleting different tables. I guess, the question is
intented to get the answer - ON DELETE CASCADE. We give
foreign constraints on tables and when the parent record is
deleted, the child records are automatically deleted when
you give command as ON DELETE CASCADE
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Does oracle roll back the transaction on an error?
what are the t string functions available in tsql? : Transact sql
Why partition by is used in sql?
how to convert dates to character strings? : Sql dba
what are integrity rules?
How many types of cursors are available in pl/sql?
what are wild cards used in database for pattern matching ? : Sql dba
What is consistency?
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
What is dml statement?
Why select is used in sql?
How do I kill a query in postgresql?
Are sql connections encrypted?
What is bitemporal narrowing?
What is the difference between delete, truncate and drop command?
