lancelly opened a new pull request, #28757: URL: https://github.com/apache/shardingsphere/pull/28757
Related issue: https://github.com/apache/shardingsphere/issues/27569 In this pr, I added PLSQL_BLOCK for PLSQL of Oracle. I referred to this doc where you can find the detailed definition: https://docs.oracle.com/en/database/oracle/oracle-database/21/lnpls/block.html#GUID-9ACEB9ED-567E-4E1A-A16A-B8B35214FC9D <img width="588" alt="截屏2023-10-14 19 11 51" src="https://github.com/apache/shardingsphere/assets/108499334/56c22fd4-b163-4535-a213-22295fdc50bf";> Now the following SQL can be parsed: DECLARE warehouse NUMBER := 1; ground NUMBER := 1; insured NUMBER := 1; result NUMBER; BEGIN SELECT BIN_TO_NUM(warehouse, ground, insured) INTO result FROM DUAL; UPDATE orders SET order_status = result WHERE order_id = 2441; END; <img width="1741" alt="截屏2023-10-14 19 12 57" src="https://github.com/apache/shardingsphere/assets/108499334/91097890-8d34-43a9-ac9e-022c43e0c3d7";> -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
