linux sqlplus select results writes into file twice Post: 302513056

10 More Discussions You Might Find Interesting

1. 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

2. UNIX for Advanced & Expert Users

Set shell variables from SQLPLUS query results

Hi All, I needed to get the result of two sqlplus queris into shell variables. After days of looking for the ultimate solution to this problem.. i found this... sqlplus -s USER/PASS@DB <<EOF | awk '{if(NR==1) printf("%s ", $1); if(NR==2) printf("%s ", $1);}' | read VAR1 VAR2 set head off...

3. 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;...

4. Shell Programming and Scripting

sqlplus: could it be dirrected do not printout anything, beside results?

I try to prepare a sufficient function to execute a sql-statement, getting back ONLY retrieved results! What I can't figured out how to make the sqlplus not printing the 'Connected to ...', 'Disconnected from...' and the executed statements after 'SQL> '. I am under impression that having...

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. UNIX for Advanced & Expert Users

SQLPlus Select with Grep

I m trying to grep 'select * from' from a script, but the problem is with the * ... I think its taking * as some special character ... when I try to do grep '*' test (test is my test file) its displaying * But when I am trying to do grep 'select * from' test its not showing anything...

7. Shell Programming and Scripting

iterating over results from sqlplus

hi all, i am writing a ksh script, i am logging into an oracle db via sqlplus and running a select statement but i dont know how i can store the results from the sql so i can iterate over it and do more operations over it. I dont want to write a stored procedure with a cursor since i need to...

8. Shell Programming and Scripting

Connecting sqlplus from UNIX with multiple select statement

hi, i have a requirement where i need to connect sqlplus from unix and i am able to do so by following command: cust_count=`sqlplus -s $ORACLE_USER/$ORACLE_PASS@$ORACLE_SID << EOF set pagesize 0 set feedback off set verify off ...

9. Shell Programming and Scripting

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

echo "set echo off"; echo "set feedback off"; echo "set linesize 4000"; echo " set pagesize 0"; echo " set sqlprompt ''"; echo " set trimspool on"; Select statement is mentioned below echo "select res.ti_book_no from disney_ticket_history res where res.ti_status =${STATUS} and...

10. Shell Programming and Scripting

SQLPLUS command with more than 1 select statement

Hi all, I'm using below code processId=`sqlplus -s ${sysuser}/${syspwd} <<CHK_PROCESS whenever sqlerror exit sql.sqlcode; set head off feedback off echo off pages 0 SELECT PROCESS_ID FROM LSHADMIN.DATA_DOMAIN WHERE DOMAIN_NAME = '${tabname}' ...

LEARN ABOUT CENTOS

ypwhich

ypwhich(1)						      General Commands Manual							ypwhich(1)

NAME

       ypwhich - return name of NIS server or map master

SYNOPSIS

       ypwhich [ -d domain ] [ -Vn ] [ hostname ]
       ypwhich [ -d domain ] [ -t ] -m [ mname ]
       ypwhich -x

DESCRIPTION

       ypwhich	returns  the  name of the NIS server that supplies the NIS services to a NIS client, or which is the master for a map.	If invoked
       without arguments, it gives the NIS server for the local machine. If hostname is specified, that machine is queried to find out	which  NIS
       master it is using.

OPTIONS

       -d domain
	      Specify a domain other than the default domain.

       -t     This option inhibits map nickname translation.

       -m mname
	      Find  the  master  NIS server for a map.	No hostname can be specified with the -m option.  mname can be a mapname or nickname for a
	      map.  If mname is omitted, ypwhich will produce a list of available maps.

       -x     Display the map nickname translation table.

       -Vn    Version of ypbind(8), V2 is default.

FILES

       /var/yp/nicknames
	      map nickname translation table.

SEE ALSO

       domainname(8), nicknames(5), ypbind(8), ypcat(1), ypmatch(1), yppoll(8), ypserv(8), ypset(8)

AUTHOR

       ypwhich is part of the yp-tools package, which was written by Thorsten Kukuk <kukuk@linux-nis.org>.

YP Tools 2.14							    April 2010								ypwhich(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

select count(*) in sqlplus into variable unix shell

Discussion started by: struggle

2. UNIX for Advanced & Expert Users

Set shell variables from SQLPLUS query results

Discussion started by: pranavagarwal

3. 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

4. Shell Programming and Scripting

sqlplus: could it be dirrected do not printout anything, beside results?

Discussion started by: alex_5161