Home / pornchatline / Updating the records in to the cursor

Updating the records in to the cursor

The types of cursors used are very important in terms of performance.

You should take this approach in most circumstances, as you'll potentially see performance gains when switching from a looping construct to a set-based construct.

Notice the fld3 field in the table declaration; I'm making this a larger field so that fewer rows are created on a page of data.

In my opinion, this will make the test a little more realistic, as it will "simulate" a table that contains a variety of character columns along with some additional fields of data.

I'll take a closer look at each option and explain why it's difficult to pinpoint which is better in terms of performance.

Cursors are a looping construct built inside the database engine and come with a wide variety of features.


  1. Statements. These are the PL/SQL static SQL statements, which have the same syntax as the corresponding SQL statements, except as noted SELECT this statement is.

  2. Selecting Specific Database Records - Stefan Cameron on Forms Building intelligent forms using Adobe LiveCycle Designer.

  3. Hi, I have a table which has 12 million rows and I want to delete around 9 million rows from that table in Oracle. The query is DELETE FROM TAB1 WHERE COL_PK IN.

  4. Extensible Storage Engine ESE, also known as JET Blue, is an ISAM indexed sequential access method data storage technology from Microsoft. ESE is the core of.

Leave a Reply

Your email address will not be published. Required fields are marked *