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?
Shoutout to Emily Plummer (http://www.experts-exchange.com/members/eplummer26.html) for giving me this article! She did most of it, I just finished it up and posted it for her :)
In a previous article (http://www.experts-exchang…