Deleting with goup
From: Michal <michalp_at_cr-media.com.pl>
Date: Wed, 6 Jun 2001 12:56:33 +0200
Message-ID: <3b1e0c6b_at_news.vogel.pl>
Date: Wed, 6 Jun 2001 12:56:33 +0200
Message-ID: <3b1e0c6b_at_news.vogel.pl>
I need to delete some data from table
but I must use HAVING COUNT(*)=x
in the condition of delete. The delete syntax
of course do not allow such one so I've tried to
create view (with group by clause)
and delete data from it
but oracle says that this I cannot modify
data within it. Any other views created on
the same set of tables are of course udateable.
Is there any other way to delete it?
Thanks in advance
-- MichalReceived on Wed Jun 06 2001 - 12:56:33 CEST