Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: multiple queries in single sqlplus
Top Forums UNIX for Dummies Questions & Answers multiple queries in single sqlplus Post 302595060 by pandeesh on Thursday 2nd of February 2012 03:03:45 AM
Old 02-02-2012
multiple queries in single sqlplus
I need to connect a databas eusing sqlplus and i need to store the results of each query in separate file.
is it possible to achieve this usng single sqlplus?
i dont want to connect each time for each query.
thanks
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Multiple MySql queries in shell script?

Hi guys, i know how to run a single query using mysql embedded in a shell script as follows: `mysql -umyuser -pmypass --host myhost database<<SQL ${query}; quit SQL` However, how would i be able to run several queries within the same connection? The reason for this is i am creating... (3 Replies)
Discussion started by: muay_tb
3 Replies

2. UNIX for Advanced & Expert Users

Connecting once using sqlplus and doing multiple queries

Hello everyone, It's my first week using unix and shell scripting. I tried creating a script that has a function that execute SQL query. my script looks something like this: ---------------------------------------------------- #!/bin/sh tableName="myTable" secondTable="secondTable"... (2 Replies)
Discussion started by: edlin_r
2 Replies

3. Shell Programming and Scripting

SQL query in a loop with single sqlplus connection

Hi, I'm trying to build a shell script that reads a set of accounts from a file. For each account I need to perform a set of sql queries. So I have a loop with a set of sqlplus connections to retrieved my data. Is it possible to have a single sqlplus connection before entering the loop and... (4 Replies)
Discussion started by: lsantacana
4 Replies

4. Shell Programming and Scripting

Multiple lines in a single column to be merged as a single line for a record

Hi, I have a requirement with, No~Dt~Notes 1~2011/08/1~"aaa bbb ccc ddd eee fff ggg hhh" Single column alone got splitted into multiple lines. I require the output as No~Dt~Notes 1~2011/08/1~"aaa<>bbb<>ccc<>ddd<>eee<>fff<>ggg<>hhh" mean to say those new lines to be... (1 Reply)
Discussion started by: Bhuvaneswari
1 Replies

5. Shell Programming and Scripting

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 (6 Replies)
Discussion started by: gonchusirsa
6 Replies

6. Shell Programming and Scripting

Executing Multiple Queries in parallel in Shell

I have n number of SQL queries needs to executed in Shell. Result of this query need to assign in a variable. Once all the queries are executed script needs to exit. Sample Query: SQL 1: Select Count(*) from TABLE GROUP BY COL1,COL2 SQL 2: Select Count(*) from TABLE GROUP BY COL1,COL2 ... (2 Replies)
Discussion started by: Niranjancse
2 Replies

7. Linux

How to store count of multiple queries in variables in a shell script?

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

Help with storing the output of multiple sql queries to a file

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?

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

PSQL multiple queries output to file

Hi, I have a shell script containing multiple PSQL queries for which I want the output to be redirected to a text file. psql -U postgres -d database -o textfile.txt << EOF Query1; Query2; Query ....; EOF When executing the script, queries outputs are directed to textfile.txt, however... (2 Replies)
Discussion started by: nms
2 Replies

LEARN ABOUT SUSE

vtysh

VTYSH(1)							  Version 0.96.5							  VTYSH(1)

NAME

       vtysh - a integrated shell for Quagga routing software

SYNOPSIS

       vtysh [ -b ]
       vtysh [ -E ] [ -d daemon ] ] [ -c command ]

DESCRIPTION

       vtysh is a integrated shell for Quagga routing engine.

OPTIONS

       Options available for the vtysh command:

       -b, --boot
	      Execute  boot  startup configuration. It makes sense only if integrated config file is in use (not default in Quagga). See Info file
	      Quagga for more info.

       -c, --command command
	      Specify command to be executed under batch mode. It behaves like -c option in any other shell - command is executed and vtysh exits.

	      It's useful for gathering info from Quagga routing software or reconfiguring daemons from inside shell scripts, etc.  Note that mul-
	      tiple commands may be executed by using more than one -c option and/or embedding linefeed characters inside the command string.

       -d, --daemon daemon_name
	      Specify  which  daemon to connect to.  By default, vtysh attempts to connect to all Quagga daemons running on the system.  With this
	      flag, one can specify a single daemon to connect to instead.  For example, specifying '-d ospfd' will connect only to  ospfd.   This
	      can be particularly useful inside scripts with -c where the command is targeted for a single daemon.

       -e, --execute command
	      Alias  for  -c.  It's  here  only  for  compatibility with Zebra routing software and older Quagga versions. This will be removed in
	      future.

       -E, --echo
	      When the -c option is being used, this flag will cause the standard vtysh prompt and command to be echoed prior  to  displaying  the
	      results.	This is particularly useful to separate the results when executing multiple commands.

       -h, --help
	      Display a usage message on standard output and exit.

ENVIRONMENT VARIABLES

       VTYSH_PAGER
	      This should be the name of the pager to use. Default is more.

FILES

       /usr/local/etc/vtysh.conf
	      The default location of the vtysh config file.

       /usr/local/etc/Quagga.conf
	      The default location of the integrated Quagga routing engine config file if integrated config file is in use (not default).

WARNING

       This man page is intended to be a quick reference for command line options. The definitive document is the Info file Quagga.

SEE ALSO

       bgpd(8), ripd(8), ripngd(8), ospfd(8), ospf6d(8), isisd(8), zebra(8)

BUGS

       vtysh eats bugs for breakfast. If you have food for the maintainers try http://bugzilla.quagga.net

AUTHORS

       See http://www.zebra.org and http://www.quagga.net or the Info file for an accurate list of authors.

Quagga VTY shell						   27 July 2006 							  VTYSH(1)
All times are GMT -4. The time now is 01:01 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy