SQL Plus script execution
Overview
For Oracle database users, DBeaver supports script execution through Oracle SQL Plus.
To use this feature:
- Ensure SQL Plus is installed on your system and properly configured to connect to your Oracle database.
-
Configure your Oracle database connection.
Info
For more details on configuring SQL Plus, see official Oracle documentation.
-
Ensure your local client configuration is correct to avoid connection issues. For more information on a Local client, see Local client configuration.
Execute scripts
- In the Database Navigator, select a schema within your Oracle database.
- Right-click to open the context menu and choose Tools -> Execute in SQL Plus.
- A wizard opens, prompting you to select the path to your script.
- After selecting your script, click Start and wait for the script execution to complete.
Use commands
DBeaver supports several commands for Oracle compatibility.