Wednesday, June 1, 2016

Query variable is adding extra space in Unix(ksh)

> Set linesize variable to avoid unwanted spaces

Ex:
--
lc_rti_rec=`sqlplus -s $orauser_pwd <<+ENDOFSQL+
set feedback off
set echo off
set pages 0
set heading off
set verify off
set termout off
set feed off
set trimspool on
set trim on
set linesize 100
select fcr.outfile_name
       ||'#'||
       (select instance_name FROM v\\$instance)
  from fnd_concurrent_requests fcr
 where fcr.priority_request_id     = $ln_request_id;
exit
+ENDOFSQL+`

lc_out_file=`echo $lc_rti_rec | cut -f1 -d'#'`
echo "Output Directory>"
echo $lc_out_file
echo " "
lc_instance=`echo $lc_rti_rec | cut -f2 -d'#'`
echo "Instance>"
echo $lc_instance
echo " "
--



Ref: My Experience/Oracle Metalink/User Guides/Different other blogs available/Colleagues

No comments:

Post a Comment