Everything required to connect to your database is included in the extension. If you have a TNSNames.ORA file, you can use that to define your database connections.
Easily point and click through creating connections using an EZCONNECT/BASIC connection list of properties, or reference a TNS entry, or use your Oracle Cloud Autonomous Database Wallet.ZIP files.
Once connected, right-click to open a worksheet. For any code editor, use the connection selector in the bottom right-hand corner to switch to a different database.
If a connection is interrupted, you'll be prompted to automatically reconnect.
The worksheet is where most of your work as an Oracle Database professional will take place. Running ad hoc queries or even complex SQL scripts can easily be achieved using our productivity features such as completion insight, SQL History, and our code snippets.
Existing SQL Developer users will find their familiar keyboard shortcuts intact, including ctrl+Enter for executing a statement and ctrl+Up arrow for recalling the previous item from your SQL History.
Browsing data and/or your query results becomes a breeze with our intuitive and friendly spreadsheet-style displays.
Invoke our Single Record View to easily browse one record at a time using our vertical, index-card like viewer.
Intuitively drag and drop columns around to achieve the desired display, or simply double-click toggle your way through apply SORTS on your columns.
When your results are ready to share, simply right-click to EXPORT them to the desired format.
Whether you're working directly with PL/SQL programs in your database, or working from your local workspace, SQL Developer makes it easy to develop your stored procedures, functions, packages, triggers, and more.
As you're coding, problems will be immediately detected via our PL/SQL and SQL Parser. Compiler errors are also automatically displayed as you save your work to the database.
When it's time to test or execute your program, SQL Developer provides an interactive panel where you can input the required parameters. The resulting PL/SQL anonymous block can be executed immediately or saved to a new code editor for further customization.
OUT and RETURN parameters are automatically captured and displayed post-execution, including your SYS_REFCURSORS.
All your favorite analytic functions, date format options, and conversion functions with examples are at your fingertips via VS Code's integrated code completion support for your active extension's code snippets.
We recognize that many developers feel more comfortable at a command or bash prompt. With the SQL Developer for VS Code, no compromise is required. Connections defined in the extension can also be used to spawn command line sessions to your database.
Oracle SQLcl is your modern command line interface (CLI) for Oracle Database. Popular features from SQL Developer, such as code completion, SQL History, and generation of DDL, have been implemented. In addition, Oracle's enhanced implementation of Liquibase for schema versioning is delivered in SQLcl via the Liquibase (lb) command.
Spawn a CLI session on demand or take any code editor and execute the contents immediately in a brand new, independent session—in a single click.