• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

Nested Table in Oracle 817

Hi All

 Thanks very much for answering my previous questions.

 If I delete my parent table, will the same command delete all it's nested tables or do I need to handle nested table separately? Please advise.

For e.g

  Create table test (
   id number,
   name varchar2(250),
   address address_tab)
   nested table address store as nested_address;

If I delete test table , will it delete the content for address also?

  • 2
2 Solutions
The quote below is not a direct answer to your question but the implication is that when you drop the parent table, all nested tables will also be droped. It is hard to imagine how it could work any other way.

"You cannot directly drop the storage table of a nested table.
Instead, you must drop the nested table column using the ALTER
ALTER TABLE department
DROP COLUMN courses; " -

The above statement was for 9.2.
Yes, want to confirm , dropping the parent table will drop the nested table.
all in all, nested table behaves exactly as an attribute value of a relation, and follow the same transaction rule as in delete, update, insert.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now