Answer / tulsi

The main use of ON DELETE CASCADE is to delete the child
records automatically from a table when the related records
from master table is deleted.

Assign the ON DELETE CASCADE clause while creating the
foreign key

Answer / vilas

Yes,its true and won't display any error while deleting the
master table.

Answer / 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.

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

---

What is on delete set null?

0 Answers  

---

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  

---

what is a join? : Sql dba

0 Answers  

---

---

how to convert dates to character strings? : Sql dba

0 Answers  

---

trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output trans_id trans_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.

1 Answers   Oracle,

---

How many primary keys can a table have?

0 Answers  

---

What is embedded sql what are its advantages?

0 Answers  

---

What is the primary use of normalization?

0 Answers  

---

what is the difference between the query and corelated query

8 Answers   HSBC, IBM, TCS, Xenosoft,

---

what is the difference between join and union? : Sql dba

0 Answers  

---