Forum Stats

  • 3,734,275 Users
  • 2,246,935 Discussions
  • 7,857,216 Comments

Discussions

How to run Oracle queries using the batch file

User_HJS01
User_HJS01 Member Posts: 11 Green Ribbon

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.

Answers

Sign In or Register to comment.