Oracle Revolutionizes Database Management with New SQL Developer Extension for Visual Studio Code
- 17 April 2024
In a groundbreaking move, Oracle has released its renowned SQL Developer tool as an extension for Visual Studio Code (VS Code), the world's most popular integrated development environment (IDE). This new extension is set to redefine how Oracle Database professionals manage, develop, and query databases.
Key Features of the Oracle SQL Developer Extension for VS Code:
• Seamless Integration: Execute SQL queries, scripts, and interact with database schema objects directly within VS Code.
• User-Inspired Development: Built on decades of user feedback from over 6 million global users, ensuring a feature-rich experience.
• Future-Ready: Oracle plans to rapidly introduce desktop tool features, positioning the SQL Developer Extension as the next-gen SQL Developer.
Getting Started is Simple:
• Easy Installation: Click the 'Install' button in VS Code to add the SQL Developer extension.
• Robust Connectivity: Connect to databases using TNSNames.ORA files, EZCONNECT, or Oracle Cloud Autonomous Database Wallets.
• Secure and Convenient: Enjoy secure password storage and easy schema navigation within VS Code.
Enhanced Productivity for Database Professionals:
• SQL Worksheet: Leverage productivity tools like completion insight, SQL History, and code snippets for efficient database management.
• Data Grids: Intuitive spreadsheet-style displays make browsing data and query results effortless.
• PL/SQL Code Editor: Develop stored procedures, functions, packages, and more with immediate problem detection and compiler error feedback.
Integrated Command Line Interface:
• Oracle SQLcl: Access a modern command-line interface with popular SQL Developer features, including Liquibase for schema versioning.
Support and Resources:
• Multilingual Support: The extension supports multiple languages, ensuring accessibility for a global user base.
• Comprehensive Support: Users with My Oracle Support can request official product support, including bug reports and enhancement requests.
Oracle's commitment to continuous improvement is evident in its data and telemetry practices, aimed at enhancing product features without compromising user privacy.
Free to Use:
• The Oracle SQL Developer Extension for VS Code is available for free under the Free Use Terms and Conditions (FUTC) License.
This release marks a significant milestone for Oracle, offering database professionals a more integrated and efficient toolset for managing the world's leading database system. Stay tuned for more updates and features in the coming quarters.