xinyiZzz commented on code in PR #31574:
URL: https://github.com/apache/doris/pull/31574#discussion_r1507119982
##########
fe/fe-core/src/main/antlr4/org/apache/doris/nereids/DorisParser.g4:
##########
@@ -337,6 +338,19 @@ fromClause
: FROM relations
;
+// For PL-SQL
+intoClause
+ : bulkCollectClause? INTO (tableRow | identifier) (COMMA (tableRow |
identifier))*
+ ;
+
+bulkCollectClause :
Review Comment:
https://docs.oracle.com/en/database/oracle/oracle-database/21/lnpls/plsql-optimization-and-tuning.html#GUID-19F50644-C88E-49AF-B31C-3EE4B4432714
```
The BULK COLLECT clause, a feature of bulk SQL, returns results from SQL to
PL/SQL in batches rather than one at a time.
With the BULK COLLECT clause, each of the preceding statements retrieves an
entire result set and stores it in one or more collection variables in a single
operation (which is more efficient than using a loop statement to retrieve one
result row at a time).
```
actually, this is not available yet, and there are still some problems.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
