Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with Executing sql in Shell Script
Top Forums UNIX for Beginners Questions & Answers Help with Executing sql in Shell Script Post 303011149 by drysdalk on Sunday 14th of January 2018 03:32:00 AM
Old 01-14-2018
Hi,

The approach typically taken here is to use the Oracle-provided sqlplus command-line client, with your SQL query embedded in-line inside your shell script.

So for example, something like this:

Code:
#!/bin/bash

output=`sqlplus -silent username/password <<EOF
SET PAGESIZE 0 FEEDBACK OFF VERIFY OFF HEADING OFF
SELECT * FROM table WHERE column='value';
EXIT;
EOF`

echo The result of the Oracle SQL query was: "$output"

All of the above assumes you have a properly-configured Oracle command-line environment, there are already environment variables and/or config files in existence for the client that define the details of your Oracle database instance, and so on. Likewise, the options you SET depend entirely on what format you want your output in and how you want sqlplus to behave.

But in terms of demonstrating the general approach, the above gives you a fairly straightforward example that you can them customise. You may very well find you need to parse the output of the SQL query further in order to use it for whatever you want to do next, but hopefully this is enough to get you started.
 

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. (3 Replies)
Discussion started by: 98_1LE
3 Replies

2. UNIX for Dummies Questions & Answers

Sh Shell Script executing remote SQL queries

Hi there folks, I am trying to execute remote sql queries on an Oracle server. I would like to save the result of the executed sql queries on a text file, and send that text file as an attachment to an email address. Could anyone give me an idea on how the above could be achieved? Any help... (2 Replies)
Discussion started by: Javed
2 Replies

3. 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. (14 Replies)
Discussion started by: ragha81
14 Replies

4. 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 (1 Reply)
Discussion started by: lijju.mathew
1 Replies

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 (2 Replies)
Discussion started by: kingluke
2 Replies

6. Shell Programming and Scripting

Executing Multiple .SQL Files from Single Shell Script file

Hi, Please help me out. I have around 700 sql files to execute in a defined order, how can i do it from shell script (3 Replies)
Discussion started by: anushilrai
3 Replies

7. UNIX for Dummies Questions & Answers

executing SQL query using unix shell script

I want to perform few post-session success tasks like update a status to 'true' in one of the sql database table, update date values to current system date in one of the configuration table in sql. How do i achieve this in a post session command?syntax with example will be helpful. (3 Replies)
Discussion started by: nathanvaithi
3 Replies

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 (1 Reply)
Discussion started by: sudhird
1 Replies

9. Shell Programming and Scripting

Executing set of sql queries from shell script

Hi All, I tried executing set of queries from shell script but not able to capture the input query in the log file. The code looks something similar to below sqlplus user/pwd@dbname << EOF > output.log $(<inputfile.txt) EOF The above code is capturing the output of queries into... (9 Replies)
Discussion started by: loggedin.ksh
9 Replies

10. 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... (2 Replies)
Discussion started by: abhii
2 Replies

LEARN ABOUT REDHAT

mysql

MYSQL(1)						      General Commands Manual							  MYSQL(1)

NAME

       mysql - text-based client for mysqld, a SQL-based relational database daemon

SYNOPSIS

       mysql   [-B|--batch]   [-#|--debug=   logfile]  [-T|--debug-info]  [-e|--exec=  command]  [-f|--force]  [-?|--help]  [-h|--host=  hostname]
       [-n|--unbuffered] [-p[pwd]] [--password=[pwd]] [-P|--port= pnum] [-q|--quick]  [-r|--raw]  [-s|--silent]  [-S|--socket=	snum]  [-u|--user=
       uname] [-v|--verbose] [-V|--version] [-w|--wait]

DESCRIPTION

       The  mysql  program provides a curses-based interface to the SQL-based database server daemon, mysqld(1).  Full fuller documentation, refer
       to the HTML documents installed with the package.

OPTIONS

       -B|--batch
	      Print results with a tab as separator, each row on a new line.

       -#|--debug=logfile
	      Employ the specified debug log.

       -T|--debug-info
	      Print debug information upon exiting.

       -e | --exec=command
	      Execute the specified command and quit (--batch is implicit).

       -f|--force
	      Continue even if the face of a SQL error.

       -?|--help
	      Display a help message and exit.

       -h|--host=hostname
	      Connect to the specified host.

       -n|--unbuffered
	      Flush the buffer after each query.

       -p|--password[=pwd]
	      Employ the specified password when connecting to the database server.  If a password is not supplied, it will be requested  interac-
	      tively.

       -P|--port=pnum
	      Employ the specified port number for connecting to the database server.

       -q|--quick
	      Do not cache the result; print it row by row.  This may slow down the server if the output is suspended.

       -r|--raw
	      Write fields without conversion.	(used with --batch).

       -s|--silent
	      Silent mode: reduce the amount of output.

       -S|--socket=snum
	      Employ the specified socket file for connecting to the database server.

       -u|--user=uname
	      Employ the specified user name for logging in to the server.

       -v|--verbose
	      Verbose mode: write more Specifying this option twice produces a tabular output format.

       -V|--version
	      Print the mysql version number and exit.

       -w|--wait
	      Wait and retry if the database server connection is down.

FILES

       /depot/bin/mysql      executable

       /depot/bin/mysqld     executable

       /depot/bin/safe_mysqld
			     executable shell script for starting mysqld safely

       /site/var/mysql/data  location of database files

EXAMPLE

       You can also read a backup dump file back into MySQL with:

       mysql  database < backup-file.sql

SEE ALSO

       isamchk	(1),  isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror
       (1), replace (1), safe_mysqld (1), which1 (1), zap (1),

AUTHOR

       Ver 6.3, distribution 3.20.20 Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se).  This software comes with no
       warranty.   Manual  page  by  R. P. C. Rodgers, Lister Hill National Center for Biomedical Communication, U.S. National Library of Medicine
       (rodgers@nlm.nih.gov).

								   13 June 1997 							  MYSQL(1)
All times are GMT -4. The time now is 04:00 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy