Cascade Delete

Posted on 2006-03-22
Last Modified: 2010-04-06
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?
Question by:lcor
    1 Comment
    LVL 7

    Accepted Solution


    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System ( introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
    Styling your websites can become very complex. Here I'll show how SASS can help you better organize, maintain and reuse your CSS code.
    Viewers will learn about the different types of variables in Java and how to declare them. Decide the type of variable desired: Put the keyword corresponding to the type of variable in front of the variable name: Use the equal sign to assign a v…
    This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now