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

From: ZC <zuin_chn_at_my-deja.com>
Date: Mon, 13 Dec 1999 22:24:10 GMT
Message-ID: <833rm4$sue$1_at_nnrp1.deja.com>

[Quoted] 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 - 23:24:10 CET