Hi ,
I have a code like this:
uid=scott
password=tiger
database=db01
cat >runid_val.sql<<-EOA
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
SELECT trim(runid_seq.nextval) FROM dual;
EXIT
EOA
echo `cat runid_val.sql`
V_RUNID=`sqlplus -s $uid/$password@$database @runid_val.sql`
echo V_RUNID:$V_RUNID
rundsjob -param runid=$V_RUNID
exit
I need to use this variable value in next command as shown above but its adding a space to out variable:
rundsjob -param runid= 26
and I wants like this: rundsjob -param runid=26
CAN ANYONE TELL ME HOW TO REMOVE THE SPACE in $V_RUNID?
Thanks & Regards,
VJ