Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to run Oracle queries using the batch file

User_HJS01Jan 26 2021

Hi All,
Please Note : I am executing ORACLE queries.
My apologies if this is a repeated question.
I am a beginner and trying to execute a simple select * query using batch file.
Here is my syntax:
@echo off
@echo - Executing scripts
sqlplus -s SERVERNAME -d DB NAME -u USERID -p PASSW -i C:\Users\XXX\Desktop\OTHER\script1.sql
PAUSE
Unfortunately, this script does not do anything. Any help will be appreciated.

Comments
Post Details
Added on Jan 26 2021
1 comment
4,980 views