Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Variable Cursors...

Re: Variable Cursors...

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 4 Dec 2000 23:02:23 +0100
Message-ID: <90h5af$1778u$10@ID-62141.news.dfncis.de>

Answer is version specific.

Please specify your version *always*
There is no relationship between deleting a huge amount of records and a variable cursor.

Regards,

Sybrand Bakker, Oracle DBA

<0> wrote in message news:3a2bc63e$1_4_at_news.arrakis.es...
> How can I have a cursor for a variable SELECT statement?
>
> I'm trying to make a general procedure to delete some
> records from a table.
> This procedure will be applyed for different tables. We
> think that we need to use a variable cursor because of the
> big amount of records to be deleted.
>
> So we need only one cursor with a variable SELECT statement
> that will return different kinds of records depending on
> the table.
>
> Thanks,
> --
> Ricardo Sánchez Berbegal
> Mobile Systems S.I., S.A.
>
>
>
Received on Mon Dec 04 2000 - 16:02:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US