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>


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

--
Michal
Received on Wed Jun 06 2001 - 12:56:33 CEST

Original text of this message