| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: ** Want a new DELETE command **
On Wed, 21 May 1997 15:00:08 GMT, dathedba_at_mindspring.com (Doug Anderson) wrote:
>"Brian P. Mac Lean" <brian.maclean_at_teldta.com> wrote:
>>The real solution here is to use a partitioned view. We all know what
>>that is right!?. Then you could just drop the table containing the
>>purge data.
>
>I looked into partitioned views. Unfortunately, my requirement is to
>have an update against the view. It would not be a problem except
>that an update against a view with "UNION ALL" isn't allowed.
>
>There shouldn't be any confusion from Oracle's point-of-view with
>an update like this. The view would be able to establish the rowid
>and therefore the appropriate table to update. Go configure!
>
What about the perfectly legal:
create view emp_times_2
as
select * from emp
union all
select * from emp
/
Suppose DML was allowed, what would:
update emp_times_2 set sal = sal*1.1;
produce? The results are in general ambigous, hence not allowed.
Oracle8 does provide increased functionality in this area as well. Instead of using a partition view, you will use a partitioned table. Insert/update/delete supported as well as select.
>
>
>- Doug Anderson
> Oracle Database Administrator
> DAtheDBA_at_mindspring.com
>
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |