ExecuteSQL()
{
sql_query=""
sql_query=$1
if [ "$sql_query" != "" ]
then
sqlplus -s $dbuser/$dbpass << END_OF_SQL
set pages 0;
set linesize 285;
set long 999999999;
set head off;
spool $logdir/$fileName;
select dbms_xmlgen.getxml( '$sql_query' )xmlrow from dual;
spool off;
/
END_OF_SQL
fi
}
sql="select * from table where to_date(moddate,'DD-MON-YY') in to_date('12-FEB-08','DD-MON-YY')"
ExecuteSQL sql 1 > $logdir/temp.xml 2 > $logdir/error.log
#!/bin/ksh
cat Script1.properties | head -n 1 | tail -n 1| read dirs
echo $dirs | awk -F "__" '{print $1}' | read logdir
cat Script1.properties | head -n 3 | tail -n 1| read args
echo $args | awk -F "__" '{print $1}' | read orainstance
echo $args | awk -F "__" '{print $2}' | read dbuser
echo $args | awk -F "__" '{print $3}' | read dbpass
echo $args | awk -F "__" '{print $4}' | read fileName
ExecuteSQL()
{
sql_query=""
sql_query=$1
if [ "$sql_query" != "" ]
then
sqlplus -s $dbuser/$dbpass << END_OF_SQL
set pages 0;
set linesize 285;
set long 999999999;
set head off;
spool $logdir/temp.xml
select dbms_xmlgen.getxml( '$sql_query' )xmlrow from dual;
spool off;
/
END_OF_SQL
fi
}
echo "Script Execution Started : $(date) on Host: $HOST" >> $logdir/output.log
export ORACLE_SID=$orainstance
sql="select * from table where to_date(moddate,'DD-MON-YY') in to_date('12-FEB-08','DD-MON-YY')"
ExecuteSQL sql 1 > $logdir/temp.xml 2 > $logdir/error.log
echo "Script Execution Ended : $(date) on Host: $HOST" >> $logdir/output.log
#!/bin/ksh
cat Script1.properties | head -n 1 | tail -n 1| read dirs
echo $dirs | awk -F "__" '{print $1}' | read logdir
cat Script1.properties | head -n 3 | tail -n 1| read args
echo $args | awk -F "__" '{print $1}' | read orainstance
echo $args | awk -F "__" '{print $2}' | read dbuser
echo $args | awk -F "__" '{print $3}' | read dbpass
echo $args | awk -F "__" '{print $4}' | read fileName
sql_query=""
ExecuteSQL()
{
if [ "$sql_query" != "" ]
then
echo "Query: $sql_query "
sqlplus -s $dbuser/$dbpass << END_OF_SQL
set pages 0;
set linesize 285;
set long 999999999;
set head off;
spool $logdir/temp.xml
select dbms_xmlgen.getxml( '$sql_query' )xmlrow from dual;
spool off;
/
END_OF_SQL
fi
}
export ORACLE_SID=$orainstance
sql_query='select * from tablename where to_date(moddate,''DD-MON-YY'') in to_date(''12-FEB-08'',''DD-MON-YY'')'
ExecuteSQL