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 DEBIAN

asmping

asmping(1)						      General Commands Manual							asmping(1)

NAME

       asmping - check if you can receive IPv4/IPv6 multicast data from an internet host

SYNOPSIS

       asmping [ -46v ] [ -I interface ] [ -c count ] [ -s size ] group host

       ssmpingd

DESCRIPTION

       asmping	and  ssmpingd are network level multicast management tools that can be used to check whether one can receive multicast packets via
       ASM from a host.  The host target given to asmping must run the ssmpingd daemon, which listens on UDP port 4321 for IPv4 and  IPv6  unicast
       requests.   When  it  receives one, it responds to the specified multicast group which asmping just have joined.  Note that one can not use
       arbitrary groups. Independent of what group is specified, the last quarter of the address is forced to be 234 or ::4321:1234  for  IPv4	or
       IPv6 respectively.

OPTIONS

       For ssmpingd there are no options.  For asmping the options are as follows.

       -4     Force IPv4

       -6     Force IPv6

       -v     Print client and server version information.

       -I interface
	      Interface to join on

       -c count
	      Stop after sending (and receiving) count requests (and replies)

       -s size
	      Request replies to have a size of size bytes

SEE ALSO

       ssmping(1) a tool for checking whether can receive SSM.

       dbeacon(1) a distributed beacon multicast implementation.

BUGS

       Please report them to Stig Venaas <venaas@uninett.no>, the author of this tool.

HISTORY

       asmping and ssmpingd were developed by Stig Venaas during the early days of the m6bone, the IPv6 multicast backbone.

								   User Manuals 							asmping(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