11-24-2012
How to store results of multiple sql queries in shell variables in ksh?
Hi,
I have a script where I make a sqlplus connection. In the script I have multiple sql queries within that sqlplus connection. I want the result of the queries to be stored in shell variables declared earlier. I dont want to use procedures. Is there anyway else.
Thanks in advance..
Cheers
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi All,
I have written 4 sql queries . Now I want to write one SHELL SCRIPTING program for all these queries...
i.e
1.select * from head;
2. select * from detail;
3. delete from head;
4. delete from detail;
Please let me know how to write a shell script...
Thank you (1 Reply)
Discussion started by: user71408
1 Replies
2. UNIX for Dummies Questions & Answers
Hello Guys...
I want a small help from you guys.
Actually in Oracle, we are having a utlity called spool through which can store whatever SQL statements executed and other queries and the output of those queries in a file
So, similarly in Unix, if I start a session executing a number of Unix... (2 Replies)
Discussion started by: mraghunandanan
2 Replies
3. Shell Programming and Scripting
I'm having problems with writing my sql results to a file:
sqlplus -S username/password@DB <<!!
set echo off
set verify off
set showmode off
set feedback off
set timing off
set linesize 250
set wrap off
set pagesize 0
set newpage none
set tab off
set trimspool on
set colsep... (1 Reply)
Discussion started by: avillanueva
1 Replies
4. Shell Programming and Scripting
While assisting a forum member, I recommended running SQL/Plus in a coprocess (to make database connections and run a test script) for the duration of his script rather than starting/stopping it once for every row in a file he was processing.
I recalled I made a coprocess example for folks at... (2 Replies)
Discussion started by: gary_w
2 Replies
5. Shell Programming and Scripting
Hi,
I am new to linux...
How to Assign SQL Query Results to Variables in Linux,i want ti generate it in param files, Can anyone please explain me.
Ex: SQL> Select * from EMP;
O/P: Emp_No Emp_Name
1 AAA
2 BBB
3 CCC
and I want expected... (5 Replies)
Discussion started by: Sravana Kumar
5 Replies
6. Shell Programming and Scripting
Requirement 1) I need to execute 15 SQL queries in oracle through linux script. All these query results needs to be stored in array variables.
Requirement 2) And these 15 queries needs to be executed in parallel.
Requirement 3) Once all the queries executed then the shell script should... (3 Replies)
Discussion started by: Niranjancse
3 Replies
7. Linux
how to store the count of queries in variables inside a filein shell script
my output :
filename
-------
variable1=result from 1st query
variable2=result from 2nd query
.
.
.
. (3 Replies)
Discussion started by: sanvel
3 Replies
8. Shell Programming and Scripting
Hi All,
I have a file queries.txt as follows :
SELECT COLUMN1 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN1 FROM SCDEMA2.TABLE2;
SELECT COLUMN2 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN2 FROM SCDEMA2.TABLE2;
SELECT COLUMN3 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN3 FROM SCDEMA2.TABLE2;
SELECT... (2 Replies)
Discussion started by: SriRamKrish
2 Replies
9. Shell Programming and Scripting
How to run multiple Queries in a ksh Script
I have a KSH script that has one SQL Query and generates and emails output of the query in HTML format. I want to change the script so that it has three SQL queries and the last query generates and emails the HTML output page of just that query.
So far... (5 Replies)
Discussion started by: JolietJake
5 Replies
10. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
LEARN ABOUT REDHAT
adsl-connect
ADSL-CONNECT(8) System Manager's Manual ADSL-CONNECT(8)
NAME
adsl-connect - Shell script to manage a PPPoE link
SYNOPSIS
adsl-connect [config_file]
adsl-connect interface user [config_file]
DESCRIPTION
adsl-connect is a shell script which manages an ADSL connection using the Roaring Penguin user-space PPPoE client. If you omit con-
fig_file, the default file /etc/sysconfig/network-scripts/ifcfg-ppp0 is used. If you supply interface and user, then they override the
Ethernet interface and user-name settings in the configuration file.
Note that normally, you should not invoke adsl-connect directly. Instead, use adsl-start to bring up the ADSL connection.
adsl-connect first reads a configuration file. It then brings up a PPPoE connection. If the connection ever drops, a message is logged to
syslog, and adsl-connect re-establishes the connection. In addition, each time the connection is dropped or cannot be established, adsl-
connect executes the script /etc/ppp/adsl-lost if it exists and is executable.
The shell script adsl-stop causes adsl-connect to break out of its loop, bring the connection down, and exit.
TECHNICAL DETAILS
adsl-connect uses the following shell variables from the configuration file:
ETH The Ethernet interface connected to the ADSL modem (for example, eth0).
USER The ADSL user-id (for example, b1xxnxnx@sympatico.ca).
PIDFILE
A file in which to write the process-ID of the adsl-connect process (for example, /var/run/pppoe.pid). Two additional files ($PID-
FILE.pppd and $PIDFILE.pppoe) hold the process-ID's of the pppd and pppoe processes, respectively.
By using different configuration files with different PIDFILE settings, you can manage multiple PPPoE connections. Just specify the con-
figuration file as an argument to adsl-start and adsl-stop.
AUTHOR
adsl-connect was written by David F. Skoll <dfs@roaringpenguin.com>.
The pppoe home page is http://www.roaringpenguin.com/pppoe/.
SEE ALSO
pppoe(8), adsl-start(8), adsl-stop(8), pppd(8), pppoe.conf(5), adsl-setup(8), adsl-status(8), pppoe-sniff(8), pppoe-server(8), pppoe-
relay(8)
4th Berkeley Distribution 21 February 2000 ADSL-CONNECT(8)