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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.