11-23-2007
redirecting SQL output from within a shell script
Hi all
I would like to open a SQL session from within a shell script and then redirect the output of the SQL command to a file.
e.g.
#!/bin/bash
sqlplus "/ as sysdba" <<EOF
@$HOME/recovery_space.sql
EOF
I want to redirect the output of the SQL command to a temp file, because further down in the shell script I want to mail the contents of the temp file to the appropriate recipients.
Does anyone know how I can accomplish this?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Guys !
I am new to unix and want to find out how we can make sql statement data to shell script variable?
Any help/suggestion is greatly appreciated
-Chandra (1 Reply)
Discussion started by: kattics
1 Replies
2. Shell Programming and Scripting
I have this shell script where I have both pl/sql and sql.
But want to have a snigle output file where the result of each cursors are in HTML tables.
I was able to do that on my old script but it was only sql scripts (no pl/sql).
Can I do have such outputs now with my new script where I... (2 Replies)
Discussion started by: arobert
2 Replies
3. Shell Programming and Scripting
Hi,
I am executing sql files in my unix shell script. Now i want to find whether its a success or a failure record and redirect the success or failure to the respective files. meaning.
success records to success.log file
failure record to failure.log file.
As of now i am doing like... (1 Reply)
Discussion started by: sailaja_80
1 Replies
4. Shell Programming and Scripting
hi,
Could anyone tell me how to pass the output values of the PL/SQL procedure to Shell script and how to store that values in a shell script variable...
Thanks in advance... (5 Replies)
Discussion started by: funonnet
5 Replies
5. Shell Programming and Scripting
Hi,
I need to connect to the database and retrieve two variables from the database and store them in a variable,out of these two variables I need to get lastdigit appended to the variable 1 retrieved and variable 2 with out any modification
in short
select var,data from usage;
o/p=... (1 Reply)
Discussion started by: rkrish
1 Replies
6. Shell Programming and Scripting
In my korn shell - I have a sql with say 6 columns whose output i am redirecting to a file and attaching this file while sending a mail. While all this happens correctly, i face issues in the format of this file.
my intended output is
Column_1 Column_2 Column_3 Column_4 ... (7 Replies)
Discussion started by: qwertyu
7 Replies
7. Shell Programming and Scripting
Hello All,
I have some unique requirement.
I have written a very lengthy script which calls number of resource script to execute a particular task.
What I want is output of each command(called from main script and resource scripts) should go to a... (3 Replies)
Discussion started by: anand.shah
3 Replies
8. Shell Programming and Scripting
Hi All,
#!/bin/ksh
call_sql ()
{
sql=$1
sqlplus -s $sqlparam_sieb <<EOF
SET ECHO OFF;
SET NEWPAGE NONE;
SET SQLBL OFF;
SET VERIFY OFF;
SET LINESIZE 2000;
SET... (2 Replies)
Discussion started by: Kevin Tivoli
2 Replies
9. Shell Programming and Scripting
I am writing the following script to create the file v_out.txt.
sqlplus -s /nolog << EOF
CONNECT scott/tiger@orcl;
whenever sqlerror exit sql.sqlcode;
set newpage 0;
SET PAGESIZE 0;
SET ECHO OFF;
SET FEEDBACK OFF;
SET HEADING OFF;
SET VERIFY OFF;
SET LINESIZE 100;
set tab off;
set... (7 Replies)
Discussion started by: itzkashi
7 Replies
10. UNIX for Beginners Questions & Answers
I am trying to write SQL query output into a .csv file. But in the output columns are displaying in different lines instead of coming in one line.
Main Code shell script:
this is my code:
#!/bin/bash
file="db_detail.txt"
. $file
rm /batch/corpplan/bin/dan.csv... (6 Replies)
Discussion started by: sandeepgoli53
6 Replies
LISTEN(7) SQL Commands LISTEN(7)
NAME
LISTEN - listen for a notification
SYNOPSIS
LISTEN name
DESCRIPTION
LISTEN registers the current session as a listener on the notification condition name. If the current session is already registered as a
listener for this notification condition, nothing is done.
Whenever the command NOTIFY name is invoked, either by this session or another one connected to the same database, all the sessions cur-
rently listening on that notification condition are notified, and each will in turn notify its connected client application. See the dis-
cussion of NOTIFY for more information.
A session can be unregistered for a given notify condition with the UNLISTEN command. A session's listen registrations are automatically
cleared when the session ends.
The method a client application must use to detect notification events depends on which PostgreSQL application programming interface it
uses. With the libpq library, the application issues LISTEN as an ordinary SQL command, and then must periodically call the function PQno-
tifies to find out whether any notification events have been received. Other interfaces such as libpgtcl provide higher-level methods for
handling notify events; indeed, with libpgtcl the application programmer should not even issue LISTEN or UNLISTEN directly. See the docu-
mentation for the interface you are using for more details.
NOTIFY [notify(7)] contains a more extensive discussion of the use of LISTEN and NOTIFY.
PARAMETERS
name Name of a notify condition (any identifier).
EXAMPLES
Configure and execute a listen/notify sequence from psql:
LISTEN virtual;
NOTIFY virtual;
Asynchronous notification "virtual" received from server process with PID 8448.
COMPATIBILITY
There is no LISTEN statement in the SQL standard.
SEE ALSO
NOTIFY [notify(7)], UNLISTEN [unlisten(7)]
SQL - Language Statements 2010-05-14 LISTEN(7)