Oracle Compatibility: Nested Subprograms

[gaoxueyu]

Feature Request

Oracle Compatibility: Nested Subprograms

Describe the feature you'd like to propose:
The PLISQL functionality in IvorySQL was developed to ensure compatibility with Oracle's PL/SQL. In Oracle's PL/SQL, it is possible to declare and define subprograms (including both functions and procedures) within other subprograms, and these subprograms can be overloaded. Additionally, subprograms can be nested within other subprograms, providing great convenience and flexibility for PL/SQL developers. To ensure that Oracle PL/SQL programs can be smoothly migrated to IvorySQL in future projects, we also support the aforementioned syntax and usage in PLISQL.
Such functions, which are internally defined and called within functions, procedures, or anonymous blocks, are referred to as nested subprograms, inner functions, or inline functions.