Answer / shailesh donda

1. DISABLE FOREIGN KEY CONSTRAINT
2. DROP THE PARENT TABLE
3. RECREATE THE PARRENT TABLE
5. ENTER THE MEANINGFUL DATA IN PARENT TABLE
4. ENABLE FOREIGN KEY CONSTRAINT

Answer / hitesh

or we can also use ondelete cascade option while creating
table.using this help as to delete or change the data
easily in parent

Answer / sandra

drop foreign key constraint
drop parent table
recreate parent table
alter child table add foreign key

what is the link between suppliers and banks in ap module in oracle apps? And also query?

1 Answers   Polaris,

---

What is store procedure?and how do u take the values from database and run in scripts?

2 Answers   Polaris,

---

HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..

1 Answers   Infosys,

---

deference between & and &&

2 Answers   Mphasis,

---

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

2 Answers  

---

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

1 Answers   Alshaya,

---

can we drop dual table

7 Answers   Metric Stream,

---

how to create an user in oracle 10g.please give me an example..

1 Answers  

---

i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value

6 Answers   IBM,

---

can u give guidance abt packages of plsql

1 Answers   Mphasis,

---

default triggers available for reports

1 Answers  

---

what is semphore explian it?

1 Answers   IBM,

---