Make shell script to write entry into DB using oracle Sqlplus and then exit.

kkrrss · 01-22-2017, 02:23 AM

Hello..

Can anyone teach me how i can make a shell script to connect to a Oracle database using sqlplus and create one record and then exit ?

my work around is..

01. Connect in to Oracle DB

Code:

 sqlplus orauser/password@10.0.0.1/TEST

02. insert one row into table.

Code:

 INSERT INTO table
(column1, column2, ... column_n )
VALUES
(expression1, expression2, ... expression_n );

03. exit from sqlplus and continue the shell script.

Thank You.

pan64 · 01-22-2017, 02:32 AM

probably this helps:
http://stackoverflow.com/questions/1...m-command-line

kkrrss · 01-22-2017, 02:35 AM

thanks a lot pan!

Hope this is helpful for me. will check and let you know. thanks a lot.

Habitual · 01-22-2017, 10:20 AM

https://oracle-base.com/articles/mis...hell-scripting