How to Execute a SQL Oracle script (create table) through Powershell

Question

The title says it all really, I have been trying to execute a SQL Oracle script through PowerShell, but it is not working. I am not getting an error, it just says 'running script/selection' at the bottom right hand corner. However I do not think it is correctly connecting to Oracle.

Please see the code in the .ps1 file:

sqlplus Username\Password "@C:\Users\...\script1.sql"

In the sql script there is:

CREATE TABLE DEPT 
(
  DEPTNO VARCHAR2(20) 
, DNAME VARCHAR2(20) 
, LOC VARCHAR2(20) 
);

The link mentioned here explains everything clearly. Just folow it. simple-talk.com/sql/sql-tools/… — XING
– XING, Commented Nov 15, 2016 at 14:29
There are a number of questions on this site which are similar. Have you seen these questions, stackoverflow.com/questions/9627225/…, stackoverflow.com/questions/24682465/… — Patrick Bacon
– Patrick Bacon, Commented Nov 15, 2016 at 14:45
I had see these links before, but thank you for posting: The solution which I later discovered was: sqlplus -s database/password@$pathtoscript — Chris Izzard
– Chris Izzard, Commented Nov 16, 2016 at 14:27

Joshan George · Accepted Answer · 2016-12-08 22:19:55Z

0

You can use the following

sqlplus <<UserName>>/<<Password>>@<<Database>> @"<<ScriptFilePath>>"

Database should be tnsnames.ora entry. You can use the following directly.

answered Dec 8, 2016 at 22:19

Joshan George

6681 gold badge7 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to Execute a SQL Oracle script (create table) through Powershell

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related