?
Solved

Cascade Delete

Posted on 2006-03-22
1
Medium Priority
?
433 Views
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?
0
Comment
Question by:lcor
1 Comment
 
LVL 7

Accepted Solution

by:
bubbledragon earned 2000 total points
ID: 16259568
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 :)    Introduction In a previous article (http://www.experts-exchang…
Browsers only know CSS so your awesome SASS code needs to be translated into normal CSS. Here I'll try to explain what you should aim for in order to take full advantage of SASS.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
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.
Suggested Courses

840 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