Interested to Buy Any Domain ? << Click Here >> for more details...
A table is classified as a parent table and you want to
drop and re-create it. How would you do this without
affecting the children tables?
- 3 Answers
- 15056 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 29 Yes | 5 No |
Post New Answer View All Answers
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
please send me oracle pl/sql exp resume. and also faqs...
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
Difference between transaction type and transaction sources. : oracle accounts receivable
can u give guidance abt packages of plsql
how to replace not in with not exist?
Hi, I want to know basic information about Oracle HRMS and the institutes in hyderabad or the best faculty as i want to make my career in it.And also want to know may a person from non technical background be able to do this course. Regards, Swetha
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
What is auto invoicing? : oracle accounts receivable
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
Where in the Oracle directory tree structure are audit traces placed?
types of receipts and detail desription about recipts and tables effected by receipts?
Differentiate between earned discounts and unearned discounts? : oracle accounts receivable
