Oracle linux script

[Natarajan]

Hi, I am just learning Linux , I have installed oracle in linux , I want to write a SQL script/procedure inside a shell script and want to add this script into CRON job, Can any one give me a small example for this (shell script).
I want to put a procedure inside the shell script and also a sql statement (select * from emp) ,I need the output of this SQL statement should go to a file .
(I don't want to use oracle job's)

Thanks,
Nat