Hello Poonam,
The lines between <<EOF and EOF tags denotes the SQL commands being piped into the SQLPlus executable. Have a look at this[
^] article. It's not like a Database Connection available in most of the programming languages which you open once and reuse everywhere, It's a pipe command.
Regards,