Re: Constraints and the exception table

From: Anton Dischner <dischner_at_KLCH.MED.UNI-MUENCHEN.DE>
Date: Thu, 22 Feb 1996 09:16:52 +0100
Message-Id: <9602220829.AA21848@alice.jcc.com>

Hi Susan, oracle gang

this may help you to delete from big tables:

declare

        emp_key       emp.key%type; /* big table */
        exceptions_key  exceptions.key%type;

        cursor sel is select key from exceptions;
begin
        open sel;
        loop
                fetch sel into exceptions_key;
                exit when sel%notfound;
                delete from emp where exceptions_key = emp_key;
                commit;
        end loop;
        close sel;

end;
/

Sorry, rowid is not a valid type.

kind regards

Toni

+--------------------------------------------------------------------+


| Anton Dischner,  DBA and system-programmer   Phone: +49 89 70953202|

| Institut fuer Klinische Chemie               Fax  : +49 89 70958888|

| Klinikum Grosshadern                         Home : +49 89 6254060 |

| Ludwig Maximilians Universitaet Muenchen     Handy: +49 172 8388880|

| 81366 Muenchen Germany                                             |


| Marchioninistr. 15                dischner_at_klch.med.uni-muenchen.de|


+--------------------------------------------------------------------+

Received on Thu Feb 22 1996 - 03:29:50 CST