LightDB24.1新特性Oracle模式支持存储过程支持inner和outer对变量的引用

对于多数数据库而言outer和inner为其关键字，不允许作为关键字来使用，Oracle支持使用outer和inner作为变量在存储过程中使用。

CREATE TABLE
lightdb@testdb01=# --outer测试
lightdb@testdb01=# DECLARE
lightdb@testdb01$#   CURSOR c_a IS
lightdb@testdb01$#      select * from record_filed;
lightdb@testdb01$#   zqdm_p  record_filed.id%TYPE;
lightdb@testdb01$# BEGIN
lightdb@testdb01$# FOR outer IN c_a LOOP
lightdb@testdb01$#   zqdm_p := outer.zqdm;
lightdb@testdb01$# end loop;
lightdb@testdb01$# end;
lightdb@testdb01$# /
DO
lightdb@testdb01=# --inner测试
lightdb@testdb01=# DECLARE
lightdb@testdb01$#   CURSOR c_a IS
lightdb@testdb01$#      select * from record_filed;
lightdb@testdb01$#   zqdm_p  record_filed.id%TYPE;
lightdb@testdb01$# BEGIN
lightdb@testdb01$# FOR inner IN c_a LOOP
lightdb@testdb01$#   zqdm_p := inner.zqdm;
lightdb@testdb01$# end loop;
lightdb@testdb01$# end;
lightdb@testdb01$# /
DO
复制