Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problems with deleting tuples
"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> schrieb im Newsbeitrag
news:3d52d62f$0$8505$cc9e4d1f_at_news.dial.pipex.com...
> I'm really not sure. how do you populate your ordered rowid table? surely
> you could just use the where clause for this population for your delete
> statement.
I've already implemented this "simple" delete:
delete from zsimp_kopf where (
zsimp_kopf.K2, zsimp_kopf.K3
) in (
select test_zsimp_kopf.K2, test_zsimp_kopf.K3
from test_zsimp_kopf
)
Primary key of zsimp_kopf and test_zsimp_kopf are columns K2 and K3 (test_zsimp_kopf is just a copy of zsimp_kopf with less tuples). Now I wonder why
delete from zsimp_kopf where zsimp_kopf.rowid in (select ordered_rids.* from ordered_rids)
(with ordered_rids: "create table ordered_rids (rid rowid primary key) organization index") results in an error.
Stefan Received on Thu Aug 08 2002 - 16:01:54 CDT