executing SQL query using unix shell script Post: 302377467

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Executing a SQL query from a shell script

I cannot figure out how to run a SQL script, or just a sqlplus query, from a shell script (bash or ksh). Basically, I need to su - oracle from root and run a query, then test the exit status.

2. Shell Programming and Scripting

Executing Sql Query Using Shell Script

HI ALL i have a requirement like this. i have to write a shell script to run a sql query. DB is oracle. once the query is run, the results of the query has to be published in a data file. can you please advice me how to go about it. i am absolutely new to shell scripts and this is a part of my job.

3. Shell Programming and Scripting

executing a SQL query in shell script

Hi ALL, I need an help in connecting to oracle database, executing a select query and printing it on the screen. Can any one please write a simple code or psuedo code and let me know. select query returns multiple values( say select name from emp) Thanks in advance LM

4. UNIX for Dummies Questions & Answers

sql query results in unix shell script

Hi I want to get the a field from a SQL query into unix shell script variable. the whole situation is like this. 1. Opened a cursor to a table in DB2 databse. 2. Fetching individual rows with the help of cursor. 3. Each row has 4 fields. I want each of the field in individual shell...

5. Shell Programming and Scripting

Script executing sql query

Hello, I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query? Thanks

6. Shell Programming and Scripting

query sql using shell script

query sql using shell script, is it possible? my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script? thanks in advance!

7. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s...

8. Shell Programming and Scripting

Executing a shell script from a PL / SQL Block

Hi, I need to call a shell script present on solaris server from within a PL / SQL block. Kindly suggest.. Thanks Sudhir

9. UNIX for Dummies Questions & Answers

Regarding executing sql query in shell script

Hi, I have one SQL file prepared in UNIX and one script that is executing that. In SQL i have Update and create queries. I want to introduce conditions in SQL file (in UNIX) that if either of the create or update query failes whole transaction should be rollback. I just have 1 create...

10. UNIX for Beginners Questions & Answers

Help with Executing sql in Shell Script

Hello~ I have a requirement to write a shell script which will connect to the oracle database and run a select count(*) query on a table. The script should succeed only when the count returns a number greater than zero. If the count returns zero, the script should fail. Can someone please...

LEARN ABOUT DEBIAN

gretl

gretl(1)							   econometrics 							  gretl(1)

NAME

       gretl - GNU Regression, Econometrics and Time-series Library

SYNOPSIS

       gretl [ options ] [ datafile | scriptfile | sessionfile ]

DESCRIPTION

       gretl  is  an econometrics package, built around a shared library which may be accessed using a command-line client program (gretlcli) or a
       graphical user interface (gretl_x11).  The program gretl is a wrapper script that calls the GUI if the DISPLAY environment variable is set,
       otherwise the command-line client.

       For  details,  please  start up either the GUI or the command-line client and consult the online help, or read the printed manual, which is
       available in PDF format via the gretl website, http://gretl.sourceforge.net.

OPTIONS

       These are the options supported by the gretl_x11 program; gretlcli is a little different.

       -r script, --run script

	      Open a script.

       -c, --dump

	      Dump the configuration file.

       -d database, --db database

	      Open a local database.

       -e, --english

	      Force use of English.

       -r script, --run script

	      Open a script.

       -w database, --webdb database

	      Open a remote database.

       -h, --help

	      Give help information and exit.

       -v, --version

	      Give version information and exit.

FILES

       ~/.gretl2rc per-user configuration file

       ~/.gretl directory for user runtime files

ENVIRONMENT VARIABLES

       HOME   Specifies the user's home directory

       DISPLAY
	      Specifies the X window display to use

SEE ALSO

       gretlcli(1)

AUTHOR

       The gretl team

The gretl team							       1.9.5								  gretl(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Executing a SQL query from a shell script

Discussion started by: 98_1LE

2. Shell Programming and Scripting

Executing Sql Query Using Shell Script

Discussion started by: ragha81

3. Shell Programming and Scripting

executing a SQL query in shell script

Discussion started by: lijju.mathew

4. UNIX for Dummies Questions & Answers

sql query results in unix shell script

Discussion started by: skyineyes