You may have occasionally needed to customize your connection to your Oracle database using SQL*Plus; in this post , I’ll walk post through the basics of how to do it.

Follow this link:
Customizing SQL*Plus The Database Blog