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?
Answer Posted / 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
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
What is the difference between recovery and restoring of the oracle database?
what are the tools used for oracle 10g in real time.
What are different types of transactions in ar? : oracle accounts receivable
Difference between negative and positive adjustments : oracle accounts receivable
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
Could you please let me know the interfaces in OM / FA??
Explain the payment term in ar. : oracle accounts receivable
What Are Cross Validation & Adi?
I would like to study certification course in Data base adminidtrator then where would i go to study this course?
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
Is there any link between pr form(purchse requisition)and po form(purchase order)
Are These Dff's Flexible?
Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable
What is an Oracle database Partial Backup?
i want to know about the javaBean.what is its purpose and how it can use in Forms.