Re: Constraints and the exception table

On 20 Feb 96 at 15:32, Susan Tellier wrote :

> Can anybody tell me if there's an easy way to remove rows from a table
> based on rowid that refers to row_id in the exceptions table. (ex. I have
> three rows in the EMP table that I simply want to remove that I've
> found reference to in the exceptions table). I know the sqlplus solution by
> feeding in the specific row id's but there's got to be a more efficient
> way, I've got many tables and thousands of rows to clean out.
>

I'm sure I don't understand the question, because surely all you want to do is this:

DELETE FROM emp
WHERE emp.rowid IN
 (SELECT row_id
  FROM exceptions);

|  Peter Moore - Database Administrator - MAT Transport Ltd, London, UK
|  pt_at_chaff.demon.co.uk : +44 (171) 410 6373
|  "With a little study you'll go a long ways & I wish you'd start now!"