Yes it seems so. I think I found the problem, bolded part is the problem which I did not include at the first post because I put here an example of my code, not itself...
Since I write this script in bash, I thought "#" would make that line commented but I forgot that I use SQL in those lines and I needed "--" to comment it...
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... (2 Replies)
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;... (7 Replies)
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 Replies)
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 Replies)
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... (2 Replies)
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... (2 Replies)
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
... (1 Reply)
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}'
... (8 Replies)
Discussion started by: Pratiksha Mehra
8 Replies
LEARN ABOUT LINUX
pid
pid(n) Tcl Built-In Commands pid(n)__________________________________________________________________________________________________________________________________________________NAME
pid - Retrieve process identifiers
SYNOPSIS
pid ?fileId?
_________________________________________________________________DESCRIPTION
If the fileId argument is given then it should normally refer to a process pipeline created with the open command. In this case the pid
command will return a list whose elements are the process identifiers of all the processes in the pipeline, in order. The list will be
empty if fileId refers to an open file that is not a process pipeline. If no fileId argument is given then pid returns the process identi-
fier of the current process. All process identifiers are returned as decimal strings.
EXAMPLE
Print process information about the processes in a pipeline using the SysV ps program before reading the output of that pipeline:
set pipeline [open "| zcat somefile.gz | grep foobar | sort -u"]
# Print process information
exec ps -fp [pid $pipeline] >@stdout
# Print a separator and then the output of the pipeline
puts [string repeat - 70]
puts [read $pipeline]
close $pipeline
SEE ALSO
exec(n), open(n)
KEYWORDS
file, pipeline, process identifier
Tcl 7.0 pid(n)