How to Customize the sqlplus in 11g?
SHAN2009Apr 11 2010 — edited Apr 13 2010Hi all,
I am Using Oracle Database 11g R1 on Windows 2003 Server Edition R2.
1. I have Created a Batch file it call the sqlplus.exe file (i am using Silent Mode -s ) for Dropping and creating a user in My test DB, I want to Customize the DOS Window of Sqlplus.exe i am getting the Full Path of Sqlplus on Top of window i want to Change it to Show by default the Machine name and after connect to the DB it should shows DB host_Name,Instance_name,Current_User_Name/Schema_Name on the Top of Window.
2. In the Batch file i am passing Some user inputs some time i accidentally press enter twice so its skip to next user inputs and i can't enter previous inputs then i have to close the Batch file and open again, is there any way to force it i mean the input should entered then only it should allow to the next user inputs .
Please advice,
Thanks
Shan