How do I run a script from SQLPlus command-line?

Question

To run a script as you start SQL*Plus, use one of the following options: Follow the SQLPLUS command with your username, a slash, a space, @, and the name of the file: SQLPLUS HR @SALES. SQL*Plus starts, prompts for your password and runs the script. Include your username as the first line of the file.

How do I run a SQL file in SQLPlus?

Other option is to follow these steps:1Open SQL*Plus.2connect to the proper database woth user name and password.3Select the menu FILE from menu bar and OPEN the .sql file from the proper folder. ... 4Press Enter to get back to the SQL*prompt.5Type @file_name. ... 6Or you can type RUN.

How do I run SQL from the command-line?

To start SQL Command Line from the desktop and connect locally:1Do one of the following: On Windows: Click Start, point to Programs (or All Programs), point to Oracle Database 10g Express Edition, and then select Run SQL Command Line. ... 2At the SQL Command Line prompt, enter the following command: CONNECT username/password.

How do I run a SQL script in Oracle?

5.9.1Open the script you want to execute in the Script Editor.2Click Run in the Script Editor. The Run Script page appears. ... 3Click Run Now to submit the script for execution. ... 4To view script results, click View Results.

Expert · Answer