SQL Plus Script Execution

Table of contents

• Execute scripts
• Use commands

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.

  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

1. In the Database Navigator, select a schema within your Oracle database.
2. Right-click to open the context menu and choose Tools -> Execute in SQL Plus.
3. A wizard opens, prompting you to select the path to your script.
4. After selecting your script, click Start and wait for the script execution to complete.

Use commands

DBeaver supports several commands for Oracle compatibility.

Example:

ACCEPT salary NUMBER FORMAT '000.0' DEFAULT '000.99' 
PROMPT 'Enter weekly salary '