Search Results

Search: Posts Made By: gonchusirsa
11,602
Posted By gonchusirsa
Getting values of 2 columns from sql query in UNIX variables
Hi,

I have connected to oracle database with sqlplus -s / <<EOF

select ename, age from emp where empid=1234;

EOF

I want to save the values of ename and age in unix shell variables. Any...
1,880
Posted By gonchusirsa
[Solved] Help with vi editor
Hi,

In vi editor for search and replace , I used to use :%s/'thing-to-be-searched'/'replace-thing'/.

Now i came across this line :%s/^/##hello#/

Can someone help me decipher this line.
...
16,322
Posted By gonchusirsa
Hi, thanks for your reply. I am trying to...
Hi,
thanks for your reply.
I am trying to output the results in a log file for which i am doing
sqlplus uname/pwd@dbname << EOF > logfile

update 1. --This result should go in log file
!echo...
16,322
Posted By gonchusirsa
Hi, I did this #!/usr/bin/ksh ...
Hi,
I did this


#!/usr/bin/ksh



DB=abcd

USER=ghij
PASS=jjkil

DATA_PATH=./DATA
LOG_PATH=./LOG

SYear=`date +%Y`
SMonth=`date +%m`
SDay=`date +%d`
LOG_FILE=test.log
16,322
Posted By gonchusirsa
not able to get it
hi.
I have bulk updates running like

Update table1 set value1.....

!echo update completed at `date`

Update table 2 set value2..
!echo update completed at `date`

But both times date...
16,322
Posted By gonchusirsa
How to store results of multiple sql queries in shell variables in ksh?
Hi,

I have a script where I make a sqlplus connection. In the script I have multiple sql queries within that sqlplus connection. I want the result of the queries to be stored in shell variables...
Showing results 1 to 6 of 6

 
All times are GMT -4. The time now is 10:03 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy