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: Problems with deleting tuples

Re: Problems with deleting tuples

From: Stefan Krompaß <krompass_at_fmi.uni-passau.de>
Date: Thu, 8 Aug 2002 23:01:54 +0200
Message-ID: <aium8f$mbk$04$1@news.t-online.com>

"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

Original text of this message

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