11-23-2007
sqlplus '/ as sysdba' <<EOF > outfile
or use the sqlplus spool command.
Last edited by radoulov; 11-23-2007 at 09:57 AM..
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
LEARN ABOUT CENTOS
sigorset
SIGSETOPS(3) Linux Programmer's Manual SIGSETOPS(3)
NAME
sigemptyset, sigfillset, sigaddset, sigdelset, sigismember - POSIX signal set operations.
SYNOPSIS
#include <signal.h>
int sigemptyset(sigset_t *set);
int sigfillset(sigset_t *set);
int sigaddset(sigset_t *set, int signum);
int sigdelset(sigset_t *set, int signum);
int sigismember(const sigset_t *set, int signum);
Feature Test Macro Requirements for glibc (see feature_test_macros(7)):
sigemptyset(), sigfillset(), sigaddset(), sigdelset(), sigismember():
_POSIX_C_SOURCE >= 1 || _XOPEN_SOURCE || _POSIX_SOURCE
DESCRIPTION
These functions allow the manipulation of POSIX signal sets.
sigemptyset() initializes the signal set given by set to empty, with all signals excluded from the set.
sigfillset() initializes set to full, including all signals.
sigaddset() and sigdelset() add and delete respectively signal signum from set.
sigismember() tests whether signum is a member of set.
Objects of type sigset_t must be initialized by a call to either sigemptyset() or sigfillset() before being passed to the functions
sigaddset(), sigdelset() and sigismember() or the additional glibc functions described below (sigisemptyset(), sigandset(), and sig-
orset()). The results are undefined if this is not done.
RETURN VALUE
sigemptyset(), sigfillset(), sigaddset(), and sigdelset() return 0 on success and -1 on error.
sigismember() returns 1 if signum is a member of set, 0 if signum is not a member, and -1 on error. On error, these functions set errno to
indicate the cause.
ERRORS
EINVAL sig is not a valid signal.
CONFORMING TO
POSIX.1-2001.
NOTES
Glibc notes
If the _GNU_SOURCE feature test macro is defined, then <signal.h> exposes three other functions for manipulating signal sets.
int sigisemptyset(sigset_t *set);
returns 1 if set contains no signals, and 0 otherwise.
int sigorset(sigset_t *dest, sigset_t *left, sigset_t *right);
places the union of the sets left and right in dest.
int sigandset(sigset_t *dest, sigset_t *left, sigset_t *right);
places the intersection of the sets left and right in dest.
sigorset() and sigandset() return 0 on success, and -1 on failure.
These functions are nonstandard (a few other systems provide similar functions) and their use should be avoided in portable applications.
SEE ALSO
sigaction(2), sigpending(2), sigprocmask(2), sigsuspend(2)
COLOPHON
This page is part of release 3.53 of the Linux man-pages project. A description of the project, and information about reporting bugs, can
be found at http://www.kernel.org/doc/man-pages/.
Linux 2013-04-19 SIGSETOPS(3)