Thread: cascade delete

is there any way to  delete records  based on condition? something
similar to  truncate <table name> cascade;
I tried delete <table name> where id=12 cascade;
but didn't work. I am not thinking of changing the constraint to 'on
delete'

Thanks
Jagadeesh