How to run sql programs in Unix Env?

anandv_1234 · 02-12-2008, 07:37 AM

Hi Folks,

I have a sql program in my home directory and i am able to run it in sqlplus enviornment, but i want to run this program in Unix Enviornment,means i want to write a shell script which has to call my sql program....

Can any one help me out on this?

Thanks in advance....

With Regards,
V.Anand,
Bangalore.

druuna · 02-12-2008, 09:35 AM

Hi,

Here documents are a way to do this, or if you have the sql statements in a 'sql-file' you can call sql with that file.

Here document example:

Code:

#!/bin/bash

sqlplus -s user/password <<EOF
SET PAGES 0
SET ECHO OFF
SET FEEDBACK OFF
SET TERMOUT OFF
SET LINES 132

SPOOL /tmp/dis_spec_const.sql
SELECT x from y where a equals b

SPOOL off

EOF

All between The first EOF and the closing EOF will be given to sqlplus.

Using a file that sqlplus 'executes' is also possible:

Code:

#!/bin/bash

sqlplus user/passwd @dir/sql-commands.do

All the commands in dir/sql-commands.do are executed.

Hope this helps.

Tinkster · 02-12-2008, 11:24 AM

Quote:

Originally Posted by druuna

Code:

#!/bin/bash

sqlplus user/passwd @dir/sql-commands.do

All the commands in dir/sql-commands.do are executed.

Hope this helps.

Or have the credentials in a file, too, so
you don't see them in ps' output ... that's
what we do at work.

Cheers,
Tink

druuna · 02-12-2008, 11:28 AM

Hi,

@Tinkster: Very good point! (and I'm a bit ashamed I overlooked that, I should know better.....).