Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> RE: Variable Cursors...
Hi,
Thanks for your help.
In this case the Oracle Version is 8.0.4.
I've got 8.1.6i, but it isn't installed yet.
Do you think I don't need to use cursors to update or delete a big amount of records (perhaps 500,000 or a million, an each record is for 1 Kb)? In MS-SQLServer 6.5 it gives me many time problems.
Regards,
-- Ricardo Sánchez Berbegal Mobile Systems S.I., S.A. rsanchez_at_mobilesyst.com "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> escribió en el mensaje news:90h5af$1778u$10_at_ID-62141.news.dfncis.de...Received on Tue Dec 05 2000 - 03:15:00 CST
> 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.
> >
> >
> >
>
>