executing a SQL query in shell script

Hi ALL,

I need an help in connecting to oracle database, executing a select query and printing it on the screen. Can any one please write a simple code or psuedo code and let me know.

select query returns multiple values( say select name from emp)

Thanks in advance
LM

Lijju,
Yesterday you had a very similar post:

Beware of the rules: