Oracle - (i)a table is classfied as a parent table and you want to drop and recreat it .how would you do this

GeekInterview.com > Tech FAQs > Oracle

Go To First | Previous Question | Next Question

Oracle | Question 116 of 228

(i)a table is classfied as a parent table and you want to drop and recreat it .how would you do this without affecting the children tables?
(II)you want to group the following set of selected returns ,what can you grioup on?
max(sum_of_cost),min(sum_of_cost),count(item_no),item_no

(iii)"to delete duplicate records from table leaving on set of records"

Total Answers and Comments: 3

Last Update: October 24, 2007 Asked by: umarajeswari

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

February 13, 2007 13:13:08

geetha24

Member Since: March 2006 Contribution: 27

RE: (i)a table is classfied as a parent table and you ...

1. Drop the constraints first and then drop the table. Recreate table and the constraints.

Is this answer useful? Yes | No

February 27, 2007 06:13:21

sunil saini

RE: (i)a table is classfied as a parent table and you ...

(1) use cascade option in query

Is this answer useful? Yes | No

October 24, 2007 06:50:46

shravanam

Member Since: August 2007 Contribution: 22

RE: (i)a table is classfied as a parent table and you ...

i. YOU CAN NOT DELETE A PARENT TABLE WITHOUT DELETING CHILDREN TABLES. BUT VICE VERSA CAN TAKE PLACE.

II. IF YOU HAVE ITEM CATEGORY THEN U CAN HAVE GROUP BY EXPRESSION ON ITEM_CATEGORY.

III. DELETE FROM testduplicate
a WHERE rowid NOT IN (select max(rowid) FROM testduplicate b
WHERE a.tname=b.tname AND a.tid=b.tid);

Is this answer useful? Yes | No

Go To Top