Link to home
Start Free TrialLog in
Avatar of lcor
lcor

asked on

Cascade Delete

I'm trying to delete all blank values from a table..

SQLplus complains with the following sql statement.

delete from table_name where column_name=' ';

Integrity constraint violated.

I can't seem to find in the Oracle sql documentation instructions on how to form a cascade.

I need help in two ways
(1) what is the Oracle 9i Rel 2 sql statement that will perform the delete
(2)  Where can I get some decent documentation on Oracle SQL or SQL in general?  Can anyone recommend a good book?
ASKER CERTIFIED SOLUTION
Avatar of bubbledragon
bubbledragon

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial