IslandSQL for VS Code

This extension integrates a language server for IslandSQL in Visual Studio Code. IslandSQL parses all files with an .isql file extension and all file extensions that are registered for Oracle Developer Tools for VS Code (SQL and PLSQL).

IslandSQL supports any Oracle SQL*Plus or SQLcl file. However, DML statements are currently the only islands of interest. This extension is considered an early prototype of a language server integration in VS Code.

Features

Outline View

Show DML statements in SQL files.

Command "Find in DML..."

Find text in DML statements within SQL files. The serarch expression is a case-insensitive regular expression (dot matches new lines).

The result is shown in the explorer view in the sidebar.

Requirements

JRE/JDK 8

The external command java must open a Java runtime or development environment. Version 8 or newer is required. Java is used to start the language server process locally. Without Java this extension will not work.

SQL and PL/SQL Extension (optional)

This extension does not provide syntax highlighting. For better user experience install Oracle Developer Tools for VS Code (SQL and PLSQL).