How to pass Variable from shell script to select query for SqlPlus? Post: 302857257

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to pass variable to SQLPLUS in a ksh script?

Hi, I am writing a ksh script which will use sqlplus to run a sql and pass 2 variables as the SQL request. In the ksh script, I have 2 variables which are $min_snap and $max_snap holding 2 different numbers. Inside the same script, I am using SQLPLUS to run an Oracle SQL script,...

2. UNIX for Dummies Questions & Answers

select count(*) in sqlplus into variable unix shell

Need to select count(*) from table to check for zero result in unix script

3. Shell Programming and Scripting

How to pass parameter from sqlplus(procedure completed) to your shell script

if then # mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com echo "FILE does not exist" exit 1 fi echo "FILE EXIST" size=-1 set $(du /export/home/oracle/nas/scott21.dmp.gz) while do echo "Inside the loop" size=$1 set $(du...

4. Shell Programming and Scripting

In a csh script, can I set a variable to the result of an SQLPLUS select query?

Can someone tell me why I'm getting error when I try to run this? #!/bin/csh -f source ~/.cshrc # set SQLPLUS = ${ORACLE_HOME}/bin/sqlplus # set count=`$SQLPLUS -s ${DB_LOGIN} << END select count(1) from put_groups where group_name='PC' and description='EOD_EVENT' and serial_number=1;...

5. Shell Programming and Scripting

redirecting oracle sqlplus select query into file

So, I would like to run differen select queries on multiple databases.. I made a script wich I thought to be called something like.. ./script.sh sql_file_name out.log or to enter select statement in a command line.. (aix) and I did created some shell script wich is not working.. it...

6. Shell Programming and Scripting

Problems with storing oracle sqlplus query output shell script

Hello everyone, I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected. I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't...

7. Shell Programming and Scripting

How to run a SQL select query in Oracle database through shell script?

I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this? Is there a way to have a persistent connection to oracle database...

8. Shell Programming and Scripting

How to print the output of a select query using shell script?

HI, I want to connect to database and fetch the count from a table. The sql query is as below : select count(*) from table_test where test_column='read'; How can I print the output of this statement using shell script. Thanks in advance.

9. Shell Programming and Scripting

Shell Script (ksh) - SQLPlus query filter using a string variable

Using ksh, I am using SQLPlus to execute a query with a filter using a string variable. REPO_DB=DEV1 FOLDER_NM='U_nmalencia' FOLDER_CHECK=$(sqlplus -s /nolog <<EOF CONNECT user/pswd_select@${REPO_DB} set echo off heading off feedback off select subj_name from subject where...

10. Shell Programming and Scripting

Pass a VARIABLE to sqlplus script

Hi Team, I am trying to run a sqlplus script against several databases via a FOR/LOOP and also passing the loop variable to a sqlplus script I am calling, as follows: #!/bin/bash export ORACLE_SID=plgc1 export ORACLE_HOME=/opt/oracle/product/11.2.0.2/db_1 export...

LEARN ABOUT DEBIAN

inspircd

INSPIRCD(1)						      General Commands Manual						       INSPIRCD(1)

NAME

       inspircd - A modular C++ IRC Daemon

SYNOPSIS

       inspircd [--version]  [--config <config>]  [--runasroot]  [--nofork]  [--nolog]	[--logfile <filename>]	[--debug]  [--testsuite]

DESCRIPTION

       This manual page documents briefly the inspircd command.

       inspircd  is a modular C++ IRC Daemon (ircd) for Linux, BSD and Windows systems created to provide a stable, modern, lightweight irc server
       from scratch and provide a vast number of features in a modularised form using an advanced module API. By keeping the functionality of  the
       main  core  to  a  minimum  we hope to increase the stability and speed of our project and make it customisable to the needs of many users.
       InspIRCd is designed primarily to be a custom irc server for the chatspike irc network (irc.chatspike.net) but we are releasing it into the
       public  domain  under GPL so that you may benefit yourself from our work. The project is written from scratch, avoiding the inherent insta-
       bility under large loads which can be seen in many other irc server distributions which have the same featureset.

       The inspircd command starts the ircd server, using /etc/inspircd/inspircd.conf as its configuration file unless used with --config.

OPTIONS

       These programs follow the usual GNU command line syntax, with long options starting with  two  dashes  (`-').   A  summary  of  options	is
       included below.	For the complete documentation for inspircd, please see http://inspircd.org/wiki/Main_Page.

       --help Show summary of options.

       --version
	      Show the version and revision ID

       --config <config>
	      Change the file name used for the main configuration file

       --runasroot
	      Allow InspIRCd to run as root, after a short pause and a nag banner to prevent this being done accidentally (NOT RECOMMENDED OR SUP-
	      PORTED!)

       --nofork
	      Do not fork to the background on startup, useful for debugging modules

       --nolog
	      Do not write to the logfile, used mostly in conjunction with --debug

       --logfile <filename>
	      Change the logfile used

       --debug
	      Force debug logging, overriding the config setting. Usually used with --nolog by the debug launcher

       --testsuite
	      Test suite for debugging purpose

SEE ALSO

       InspIRCd is fully documented by the inspircd documentation team, which is viewable at http://wiki.inspircd.org/.

AUTHOR

       InspIRCd  was  written  by  Craig  Edwards   (Brain),   Craig   McLure	(FrostyCoolSlug),   Robin   Burchell   (w00t),	 and   more   (see
       http://www.inspircd.org/wiki/Credits).

       This manual page was written by Darren Blaber <dmbtech@gmail.com>, for the Debian project (but may be used by others).

								   June 11, 2007						       INSPIRCD(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to pass variable to SQLPLUS in a ksh script?

Discussion started by: rwunwla

2. UNIX for Dummies Questions & Answers

select count(*) in sqlplus into variable unix shell

Discussion started by: struggle

3. Shell Programming and Scripting

How to pass parameter from sqlplus(procedure completed) to your shell script

Discussion started by: sanora600

4. Shell Programming and Scripting

In a csh script, can I set a variable to the result of an SQLPLUS select query?

Discussion started by: gregrobinsonhd