write a query to delete similar records in particular
fields(columns) in different tables
- 6 Answers
- 12724 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
What is a unique key and primary key and foreign key?
What is sql injection owasp?
What is serial sql?
what is table? : Sql dba
what is index? : Sql dba
Which is better cte or subquery?
what are all the different normalizations? : Sql dba
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
How can I see all tables in sql?
What are the 3 types of behavioral triggers?
Can we commit in trigger?
What is the best partition size for windows 10?
What is the difference between functions, procedures, and packages in pl/sql?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
How to test for null values?
