It is only used to describe the way to get data in memory.

Just like GPS navigation, GPS will give you the location on the map, and whether you can run depends on how much oil you have in your car.

For example:

If you get a result set in the database, whether you can get those data depends on your machine. If there is a CLOB field in the result set and your machine's memory+hard disk is always ***250M, it is impossible to see the data, right?

Modify the maximum cursor: alter system set open _ cursor = 800, scope = both.

As long as you can accept the performance, you can change it at will. In addition, the greater the plastic change, the greater the performance is affected.

The following is the answer of Mercedes-Benz M888.

1, plsql are all process-oriented languages, as well as C, cobol and so on. The similarity of these languages is that only one piece of data can be processed at a time, and the object returned by database sql is a collection, so it will be problematic to operate directly with plsql programs.

2. In this environment, a cursor will appear. A cursor is actually a memory address, and all it wants is the result set of an sql query. If necessary, press the cursor to fetch data one by one until all data are fetched.

As chsoftstar said, there is a problem that the cursor can't get the data, which is probably an error. The specific reasons have to be found by the landlord himself.