while loop help
Hi All,
can any one help me regarding the following sample code ..,
i just want to repeat the sql query 7 times as mentioned below ..,but it's getting failed.
selet*REF_DATE='03-MAY-08'*
select*REF_DATE='04-MAY-08'*
select REF_DATE='05-MAY-08'*
--
--
select*REF_DATE='10-MAY-08'*
SQL_FILE=sqlfile.sql
COUNTER=3
echo "SET NEWPAGE 0
SET SPACE 0
SET PAGESIZE 0
SET ECHO OFF
SET FEEDBACK OFF
SET HEADING OFF
SET TERMOUT OFF
SET FLUSH OFF
SET TRIMS ON
SET VERIFY OFF
SET MAYKUP HTML OFF SPOOL OFF
set linesize 250 " > $SQL_FILE
while [ $COUNTER <= 10 ]; do
echo "select 'TIMESTAMP, CALLING_NUMBER, CALLED_NUMBER, DURATION(MINUTES), TRUNKIN, TRUNKOUT, VIOLATIONFLAG,CIRCLE,POICODE,INOPERATOR,SERVICE,RATE' from dual;
SELECT RATED35||','||RATED36||','||RATED37||','||round((RATED23/60),2)||','||RATED17||','||RATED18||','||RATED54||','||RATED11||','||RATED46||','||RATED1||',
'||RATED2||','||trim(round(rated12,2)) FROM TRAFFIC WHERE REF_DATE='{$COUNTER}-MAY-08' AND FILE_ID IN ( (SELECT fileid FROM FILE_DISTR WHERE fileid >= 121423
8 AND fileid <= 1239493 AND SUBSTR ( SUBSTR (filename, INSTR (filename, '_', 1, 5) + 1),1,INSTR ( SUBSTR (filename,INSTR (filename, '_', 1, 5) + 1),'_',1,1)-
1) IN ( SELECT DISTINCT mod_code FROM file_recon WHERE ref_date = '31-may-08' AND POI_CODE IN ('DVGEWD','HBOCBT','HSNOCB','KLROCB','KLROCB','MCROCB','MDYOCB
','MRTAX','MRTAX','MYOCB','MYOCB','TMROCB','TMROCB','CENTAX','CENTAX','CENTAX','WMSOCB','WMSOCB','WM SOCB','WMSOCB','WMSOCB')))) and rated20 like '%USC%'; " >> $SQL_FILE
let COUNTER=COUNTER+1
done
echo "spool off
exit" >> $SQL_FILE
Last edited by prasanth_babu; 06-17-2008 at 11:33 AM..