Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Customize the sqlplus in 11g?

SHAN2009Apr 11 2010 — edited Apr 13 2010
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 11 2010
Added on Apr 11 2010
7 comments
1,512 views