Selecting from and updating the same table oracle
The type is associated with the table function when the table function is created.
First, one set of slave processes partitions the data as directed in the function's declaration; then a second set of slave scans executes the table function in parallel on the partitioned data.
, and before you increment it, you need to get its current value.
This current value will be used as an ID for some operation, so concurrent sessions must not get the same value.
A pipelined table function can return the table function's result collection in subsets.
The returned collection behaves like a stream that can be fetched from on demand.