Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: H.E.L.P! w Delete Beginning pauper needs help
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
![]() |
![]() |