How to execute 10 sql files from a folder through sqlplus in shell script?

Shell Programming and Scripting
1

I am new to shell scripting and i want to know how to execute the *.sql files from a folder through sqlplus in shell script and files should be execute in sequentially one by one while execution if any ORA error it has to exit from sqlplus session

1) scripts from external folder
2) logs has to go to folder
3) stop sqlplus session on SQL block or ORA error

Thanks & Regards,
Sreekanth.L

2

It is important here at UNIX.COM to post your own code (what you have tried on your own) before expecting others to code for you.