Re: delete from a view

On Thu, 29 Apr 2004 12:49:26 -0400, Serge Rielau wrote:

> Frederic,
>
> So each table in the UNION ALL is a another subtype in the same
> hierarchy and the view is just merging them together again?
> I'm quite certain that Oracle supports subtables.
> You shouldn't need that view.
> Simply create a table hierarchy and then select "inclusive" from the
> root table.
>
> Here's how it looks in standard SQL (you may need to adjust to Oracle
> dialect):
> CREATE TABLE root OF root_t .....
> CREATE TABLE sub1 OF sub1 UNDER root_t ....
> CREATE TABLE sub2 OF sub2 UNDER root_2 ...
>
> SELECT * FROM root
> => returns all rows in root, sub1 and sub2
>
> SELECT * FROM ONLY(root)
> => returns only rows in root
>
> SELECT * FROM sub1;
> => returns all rows from sub1 and its subtables
>
> Cheers
> Serge

The idea sounds really great but when I do this in Oracle 10g, i get

CREATE TABLE eo OF extrinsicobjectv2 UNDER RegistryObjectV2; ERROR at line 1:
ORA-03001: unimplemented feature

.... :-( Received on Fri Apr 30 2004 - 01:54:36 CDT