Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: delete from a view

Re: delete from a view

From: Frederic Houbie <fh_at_ionicsoft.comNOSPAAAAM>
Date: Fri, 30 Apr 2004 08:54:36 +0200
Message-ID: <pan.2004.04.30.06.54.34.207978@ionicsoft.comNOSPAAAAM>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US