ORACLE implicitly repeats the FETCH until all the rows from the cursor are consumed and stores each row in an element of the array.
ORACLE隐式重复FETCH,直到使用了来自游标的所有行并将每一行存储在阵列的一个元素中。
From here on out, until the cache expires, you will be able to fetch the result array directly out of cache, skipping over the SQL query.
从这里开始,直到缓存到期,您就能够直接从缓存中获取结果数组,跳过SQL查询。
POP(), for instance, could be implemented as a FETCH() of the last element, followed by STORESIZE(FETCHSIZE()-1) (setting the size of the array to be one less, effectively removing the last element).
例如,可以这样实现 POP() :对最后一个元素使用 FETCH() ,然后使用 STORESIZE(FETCHSIZE()-1) (将数组的大小减去 1,实际除去了最后一个元素)。
应用推荐