ssabapathy
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes, want to confirm , dropping the parent table will drop the nested table.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.