Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ansupriya
If child record exists user cannot delete parent record.
Using on delete cascade on foreign constraint user can delete parent record .
Same time automatically it will delete the child record.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution
How to run pl/sql statements in sql*plus?
What do you mean by stored procedures? How do we use it?
What are system versioned tables?
What is sql procedures and functions?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is rtm in testing?
Is sql low level language?
How is sql used in oracle?
What is on delete set null?
List the various privileges that a user can grant to another user?
Is sqlite free?
What is the syntax and use of the coalesce function?
how do you tune the slow running queries in oracle db , explain the methodology
What is a common use of group by in sql?
