Oracle Database Tools Statement of Direction
Jeff Smith
Product Manager | Databases | Blogger | Software Development | Cloud | Social | Community Management | Product Marketing
The Oracle Database desktop development, query, and management platform for the past two decades has been Oracle SQL Developer. With more than 7,000,000 installs worldwide, we have helped our customers save billions of hours and dollars when it comes to building solutions for the Oracle Database.
In January of 2024, we released the first version of Oracle SQL Developer Extension for VS Code. This is the future of our desktop solution for Oracle Database developers, DBAs, and analysts.
The Oracle Developer Tools for VS Code (SQL and PLSQL) extension has been deprecated, and those users have been advised to migrate over to the SQL Developer Extension. All new features and enhancements to our desktop tools will be delivered via the SQL Developer Extension for VS Code.
Current Features
The SQL Developer Extension for VS Code currently supports working with SQL and PL/SQL files and database objects, executing, compiling, and debugging those programs, SQL History, visual explain plans, browsing the contents of the database, an integrated command line experience via SQLcl, code formatters, and support for the VS Code Language Server Protocol.
VS Code is also where we make our showcase features from Oracle Database 23ai easy to pick up and start using right away, including our JSON Relational Duality Views and it's accompanying 'Builder' and diagrammer in VS Code.
领英推荐
Upcoming Features
We will continue migrating over popular features from Oracle SQL Developer including our Reports, Real Time SQL Monitoring, Session Browser, Connection Folders, JavaScript development in the database (MLE), the DBA panel, Data Modeling, and much more.
Just as importantly, we will be doing work to take true advantage of the VS Code IDE platform, and empower developers to build rich Java, JavaScript, Python, Go, and more apps that work with the Oracle Database by helping them generate SQL code to embed. We'll also be working alongside our Oracle Cloud (OCI), GraalVM, and Java teams to integrate extensions and provide complementary features.
AI and code generation is the new normal, and we here at Oracle are working on bringing the support our developers require to build, document, support, and maintain rich applications - whether that means we make it easier to build new schemas or generate JavaScript code to be executed in our database's Multilingual Engine (MLE).
What happens to SQL Developer?
The current desktop Java applications SQL Developer and SQL Developer Data Modeler will receive annual maintenance updates and be supported until we reach critical mass in terms of adoption and features in the VS Code extension or extensions. SQL Developer will remain our flagship interface for the Oracle Database, but as a VS Code extension.
Oracle SQLcl and SQL Developer Web, also known as Database Actions, remain unchanged, and will continue to receive quarterly updates.
Want to learn more?
Resources:
Want to see what's possible? Just watch the video! You can see how the PL/SQL debugger works as well.
Oracle Apex Cloud Developer Certified Professional
2 个月Thanks for the great work with the new VS Code extension for Oracle SQL Developer, Jeff Smith and team. I believe a few essential features are still missing, like pinning the query results, exporting the results in an excel sheet along with the SQL in a worksheet in the same xlsx file, pinning the object body definition by default, checking the sql for a query result by clicking on SQL link button in the result view, Count option on result set to get the total row count , and few others. I hope those features are in the product backlog list. One more useful feature, if you allow me to suggest, could be to add a file export option for code beautifier or a code formatting rules file, so that the team members could use the same code formatting rules with an option to apply the formatting rules on every compilation of the selected db objects.
Format outputs with SQLPlus syntax is very common and important. As far as I know the plugin for VS code doesn’t support this syntax. Any particular reason? Can you improve with this compatibility please? Thanks
Software Engineer | OLTP Systems | Oracle APEX
2 个月Thank you for making our work more productive and efficient
Senior Software Developer
2 个月Is there a plan to bring Data Modeler into VS Code or will that remain a stand alone app?
Database Developer | Oracle Apps Developer | Oracle Retail Techno Functional Consultant | PLSQL Developer | WebFocus Report Developer| RMS,RPM,REIM | Oracle Cloud Fusion | OIC | Power BI | HCM
2 个月Good to know