Assertion: cursor | /r/HasProperty | created
Facets:
value: synchronously
type: MANNER
value: on executing below fetch statement
type: TEMPORAL
value: asynchronously
type: MANNER
Source sentences:
text: The XQuery language allows cursors to be created using the subsequence() function.
text: If the query optimizer estimates that the number of returned rows is greater than this threshold, the cursor is generated asynchronously, allowing the user to fetch rows from the cursor while the cursor continues to be populated.
text: Once the cursor has been created, the insertRow method is used to insert a list (or tuple) of values that will make up the new row.
text: If the cursor is created with GLOBAL attribute, the scope is cursor is not limited to the batch where it was created, and the cursor name can be referenced by any batch in the same connection.
text: Now go back to a session where the cursor was created on executing below fetch statement two times.
text: A cursor can also be created and associated with a variable without having a cursor name defined.
text: Cursors are created using the DECLARE statement.
text: Otherwise, the cursor is generated synchronously, and the query waits until all rows are returned.