Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

WISHLIST - create or replace PARTIAL package body ...

DataProcessingMay 3 2025

Oftentimes I think about the pros and cons of C# and PL/SQL project organization.

LIKE: The C# partial class keyword feature that permits hosting individual class methods in different files. The compiler assembles all files in the project (sub)folders for the same class from different files having the partial keyword into a single logical unit.

DISLIKE: that a PL/SQL package requires every procedure and function to be contained in the same physical code file.
The PL/SQL compiler handles packages as two separate entities, specification and body, and the same goes for TYPE object spec and TYPE body. Compiler also handles scenarios for standalone schema level triggers, functions, procedures, views, etc.

WISH: Oracle and Oracle SQL Developer for VSCode to support the external organization of PL/SQL packages in a similar manner using a partial keyword as is done in C#. VSCode supports a directory structure project model; root folder and sub folders and files are all members of a project.

Comments
Post Details
Added on May 3 2025
3 comments
113 views