| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> H.E.L.P! w Delete Beginning pauper needs help
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:23:46 CST
 |
 |