plsql-executor's Introduction

SQLPlus Remote Executor README

The "SQLPlus Remote Executor" extension for Visual Studio Code provides a powerful tool for Oracle database developers and administrators who wish to execute SQL scripts remotely using SQLPlus. Integrating directly with VS Code, this extension simplifies the process of connecting and executing SQL scripts on Oracle databases from any location.

Features

Simplified Connection: Quickly access your Oracle databases by entering essential connection information directly from the VS Code user interface.
Connection Management: Save your favorite connection configurations for quick and hassle-free access to different Oracle databases.
Remote Execution: Use the SQLPlus tool to run SQL scripts directly on your Oracle database, regardless of the physical location of the database.
Displaying Results: Visualizza i risultati delle query direttamente in VS Code, facilitando l'analisi e la comprensione dei dati restituiti.
Multi-Database Compatibility: It supports connecting to several Oracle databases at once, allowing you to work on multiple projects without having to constantly reconfigure connections.

Requirements

You must have the SQLPlus tool installed on the same machine on which Visual Studio Code is running. SQLPlus is the command-line interface tool provided by Oracle for running SQL commands and scripts on Oracle databases. Make sure the tool is configured correctly and can be run from the command line.

Extension Settings

This extension contributes the following settings:

plsql-executor.sqlplusPath: Folder in which the SQLPath tool is installed..
plsql-executor.defaultProfile: Default profile for running scripts
plsql-executor.profiles: Array describing the various connection profiles, the profile structure is as follows

"plsql-executor.profiles": [
        {
            "name": "dev",
            "connectionString": {
                "user": "<username>",
                "password": "<password>",
                "dbAddress": "<host>",
                "dbService": "<serviceName>"
            }
        }
    ]

Known Issues

To report any problems please create an issue on the Repository GitHub

Release Notes

1.0.0

plsql-executor's People

Contributors

Watchers

plsql-executor's Issues

Write readme file

Nothing to say just write it

Crash of the prompt after a plsql error

The prompt crashes after a plsql script has an error.
If teh promt crashes i can't see the error and i can't fix the script

Add configuration contrubutes

In the package.json file declare the configuration properties.

sqlplus path must be a file picker if exist a string otherwise
default profile a simple string or an enum
a complex configuration like edit settings JSON for inserting different profiles (check if it is possible to validate JSON)

Add keybindings for running commands

Update package.json to add keybindins to run command.
https://code.visualstudio.com/api/references/contribution-points#keybinding-example

Gestione spazi percorsi script da eseguire

Se si prova ad eseguire uno script che contiene degli spazi nel percorso es: "C:\Users\test a\prova.sql", il processo va in errore perché converte il percorso in "C:\Users\test".