How to connect oracle from unix

Question

How to connect oracle from unix script? I am updating one column of table emp from unix script. for example: table is emp. I am updating table for the column salary where emp_id is PK. How could i do this? Any help guys? Thanks in advance

Lalit Kumar B · Accepted Answer · 2014-12-05 14:14:57Z

2

You need to take care of the environment variables like export ORACLE_HOME and PATH etc. properly. And then invoke SQLPLUS.

For example,

#!/bin/ksh

sqlplus -s /nolog << EOF
CONNECT user/password@service_name
update table set column = ....;
EXIT;
EOF

answered Dec 5, 2014 at 14:14

Lalit Kumar B

49.5k13 gold badges104 silver badges131 bronze badges

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

Comments

Alexander Kohler · Accepted Answer · 2014-12-05 14:17:39Z

1

Download sqlplus and follow this tutorial.

A sample script would something look like so

CONNECT user/password(@servicename if using a pluggable database) ALTER TABLE Emp PRIMARY KEY (emp_id)/*Or whatever updates you want here*/ EXIT;

answered Dec 5, 2014 at 14:17

Alexander Kohler

1,98716 silver badges23 bronze badges

Collectives™ on Stack Overflow

How to connect oracle from unix

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related