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


Please Help Members By Posting Answers For Below Questions

while creating requisitions i am unable to see the list of organisation can anyone help me out ?

1704


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

1614


we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

1873


What are different types of receipt reversals ? Explain them : oracle accounts receivable

723


Could you please let me know the interfaces in OM / FA??

1736






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

1957


can u give guidance abt packages of plsql

1644


What are different types of transactions in ar? : oracle accounts receivable

745


What is supporting issues GL AP and AR?

1987


What is the importance of batch source set up in ar? : oracle accounts receivable

716


Explain how to close periods in ar. : oracle accounts receivable

707


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

1769


A scenario for amount correction & how to use amount correction functionality in AP invoices

1651


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1646


Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

6739