10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
I need to call a function in database and update the return value of that function with a value in csv file.
test.csv
1,2,3,,5,,,8,9,10
1,2,3,4,5,,,8,9,10
1,2,3,,,,,8,9,10In the above file I want to replace column 2 with a value extracted from database
like (select student_id from... (3 Replies)
Discussion started by: kev94
3 Replies
2. Shell Programming and Scripting
Dear All,
I want to know how can i call oracle function from shell script code . My oracle function have around 5 input parameters and one return value.
for name in *.csv;
do
echo "connecting to DB and start processing '$name' file at "
echo "csv file name=$x"
sqlplus -s scoot/tiger <!... (2 Replies)
Discussion started by: Balraj
2 Replies
3. Shell Programming and Scripting
Hello,
I am trying to execute an SQL query from shell script.
A part of script is something like this:
fromDate=`echo $(date +"%F%T") | sed "s/-//g" | sed "s/://g"`
$ORACLE_HOME/sqlplus -s /nolog <<EOD1
connect $COSDBUID/$COSDBPWD@$COSDBSID
spool... (4 Replies)
Discussion started by: sanketpatel.86
4 Replies
4. Shell Programming and Scripting
This is my function which is creating three variables based on counter & writing these variable to database by calling another function writeRecord
but only one record is getting wrote in DB.... Please advise ASAP...:confused:
function InsertFtg
{
FTGSTR=""
echo "Saurabh is GREAT $#"
let... (2 Replies)
Discussion started by: omkar.sonawane
2 Replies
5. Shell Programming and Scripting
hi,
I am new script learner,
so my basic doubt is ,
how to store value of any command in a variable example
$ ls | wc -l
i want to stote the output of this in a variable c.
so that i can use c in if else loop.
and when do we use " ` " symbol in script..
can anyone also tell for... (5 Replies)
Discussion started by: hi2_t
5 Replies
6. Shell Programming and Scripting
Hi,
I'm a newbie in shell script.
I have a problem in running my a.out in a bash shell script named vetri . The following is the code.
#!bash/bin
./a.out abc.xyz
where ./a.out is a c++ bin file and abc.xyz is an argument. My ./a.out expects an input (cin >> temp). How can I give the... (5 Replies)
Discussion started by: lchokka
5 Replies
7. Shell Programming and Scripting
Hi,
While reading a shell script ,i have come accross the following statements.
script_name_full=$0
***script_name=${script_name_full##*\}
***script_name_noexst=${script_name%%\.ksh}
host_name=`hostname`
***host_name_short=${host_name%%\.*}
can anybody tell me what is the purpose of marked... (5 Replies)
Discussion started by: ravi raj kumar
5 Replies
8. Shell Programming and Scripting
i want to call a oracle function in my shell script (4 Replies)
Discussion started by: dineshr85
4 Replies
9. Shell Programming and Scripting
Hi all,
I am trying to run a script in crontab but I receive the email below. Note the empty variable SHELL. Apparently cron doesn't invoke a shell. That explains the errors in the script it is trying to execute. Anyone know what maybe wrong?
Subject: Output from cron job... (3 Replies)
Discussion started by: ivanushka
3 Replies
10. UNIX for Dummies Questions & Answers
....does the dbms_output.put_line work inside unix shell script?
i mean this is to be inside the sqlplus connection as follows!!
sqlplus -s $UP <<EOJ
..
..
..
dbms_output.put_line ('Insertion procedure failed for UPC BC : ' || wk_key_value || ' Sqlcode: ' || SQLCODE || ' Error... (2 Replies)
Discussion started by: mexx_freedom
2 Replies