Linux

$$SChema_Name='ORCL'

   SQL> Select * from EMP;

 o/p Emp_No EMP_Name Location
         1         AAA          Tirupati
         2         BBB           Bangalore

Param_Sample1.prm
------------------
$$EMP_No=1
$$EMP_NAME='AAA'
$$EMP_Location=Tirupati
/* These three values should go to one file  and second record details should go to second param file like....*/

Param_Sample1.prm
------------------
$$EMP_No=2
$$EMP_NAME='BBB'
$$EMP_Location=Bangalore...

SEQ=0
while IFS=, read no name loc
do
        SEQ=$( expr $SEQ + 1 )
        {
         echo "\$\$EMP_No=$no"
         echo "\$\$EMP_Name=$name"
         echo "\$\$EMP_Location=$loc"
        } > Param_Sample${SEQ}.prm
done < EMP.csv