Search Results

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

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

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

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

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

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