Re: Manipulating rows in a delete

Gautham Ramkumar wrote:
>
> I have a SQL statement as follows.
>
> delete from table_name
> where some criteria;
>
> Now my aim is to do some manipulation with each of the rows I
> delete without using triggers. I thought of a cursor but I can't do a
> delete in that.
> Please help

1. What is the objection to an ON-DELETE trigger? Perhaps you only want to do this sometimes, in which case:
2. Use a procedure to delete, e.g.

create or replace procedure deltab as

   cursor C is select from <table_name>

               where <some_criteria>
               for update of any_column_name;

    for R in C
    loop

       < do your thing >;
       delete <table_name> where current of C;

-- 
Chrysalis

FABRICATI DIEM, PVNC
('To Protect and to Serve')
Terry Pratchett : "Guards Guards"