Passing parameter from shell script into sql script

Today I learn something good and simple. I will create a sql script to do some of oracle statement but I will drive it from shell script. Then I will pas some parameter from shell script to sql script. Following steps are what I've done, this one only sample :

1. Create shell script as interface
#!/bin/sh
ORACLE_HOME=/opt/oracle/product/10.2.0
export ORACLE_HOME
ORACLE_SID=JAJANGDB
export ORACLE_SID
echo "Begining update activity ..."
date
$ORACLE_HOME/bin/sqlplus -S jajang/jajang @/export/home/jajang/update_prefix/update_prefix.sql 20080711170 20080712170;
echo "Ending update activity ..."
date

2. Create sql script which read input parameter from shell script
select &1, &2 from dual;
exit;

3. Run and look the result
bash-2.05# ./update_prefix.sh >> update_prefix.log
bash-2.05# tail -f update_prefix.log
Mon Aug 25 14:43:04 WIT 2008
old 1: select &1, &2 from dual
new 1: select 20080711170, 20080712170 from dual

20080711170 20080712170
----------- -----------
2.0081E+10 2.0081E+10

Ending update activity ...
Mon Aug 25 14:43:04 WIT 2008