Re: H.E.L.P! w Delete Beginning pauper needs help

From: Darren Brock <brock_at_governet.net>
Date: Mon, 13 Dec 1999 15:55:03 -0700
Message-ID: <38557947.8E862A79@governet.net>

ZC
part 1
you could set up a constraint on the child table that cascades the delete from the parent table.
CONSTRAINT key_name FOREIGN KEY (foreign_key_field) REFERENCES referenced_table (tables_primary_key) ON DELETE CASCADE

should work.

part 2
  upper or lower case both sides of where clause   ex..
  DELETE from GRADE_TYPE
  WHERE UPPER(echelon) = UPPER('retrival');

Darren

ZC wrote:
>
> Anyone know the command to delete across a table? delete from two
> tables. I'm getting ORA-02292: integrity constraint
> (echelon.INFO_FK_RETRIVAL_TYPE) violated - child record found.
> If you can, please provide an exaple.
>
> DELETE from GRADE_TYPE
> WHERE echelon = 'retrival';
>
> p.s. How would you make the above look for upper and lower case
> combinations on retrival: So it can look for Retrival, RETRIVAL,
> ReTriVal, etc..
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Dec 13 1999 - 16:55:03 CST