Home » SQL & PL/SQL » Client Tools » sql*plus (oracle 10.2.0.3)
sql*plus [message #474431] Mon, 06 September 2010 06:02 Go to next message
pointers
Messages: 350
Registered: May 2008
Senior Member
Hi,

Could you please share me the way to create a short cut on desktop to have an sql*plus (command line).
i.e. I want to have an short cut on desktop when I click that short cut that would connect me to a specific database with a username and password (which i supply while creating the shortcut-I would provide the database name, usename and password)

Thanks in advance.

Regards,
Pointers
Re: sql*plus [message #474441 is a reply to message #474431] Mon, 06 September 2010 07:43 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sqlplus.exe or sqlplusw.exe?

Regards
Michel
Re: sql*plus [message #474552 is a reply to message #474431] Tue, 07 September 2010 03:13 Go to previous messageGo to next message
pointers
Messages: 350
Registered: May 2008
Senior Member
From command line
like below

sqlplus scott/tiger@db

It is ok if i get for sqlplus.exe as well.

Thanks

Regards,
Pointers
Re: sql*plus [message #474554 is a reply to message #474552] Tue, 07 September 2010 03:40 Go to previous messageGo to next message
cookiemonster
Messages: 11070
Registered: September 2008
Location: Rainy Manchester
Senior Member
sqlplus.exe is the command line version.
Re: sql*plus [message #474555 is a reply to message #474431] Tue, 07 September 2010 03:45 Go to previous messageGo to next message
pointers
Messages: 350
Registered: May 2008
Senior Member
I want create a short cut on desktop to have an sql*plus (command line).
i.e. I want to have an short cut on desktop when I click that short cut that would connect me to a specific database with a username and password (which i supply while creating the shortcut- I would provide the database name, usename and password)

Please guide me for that

Regards,
Pointers
Re: sql*plus [message #474556 is a reply to message #474555] Tue, 07 September 2010 04:01 Go to previous messageGo to next message
ThomasG
Messages: 3101
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Create a new shortcut with the "target"

sqlplus.exe scott/tiger@db


If sqlplus.exe is not in the path you might have to specify the full path to the exe.

[Updated on: Tue, 07 September 2010 04:01]

Report message to a moderator

Re: sql*plus [message #474561 is a reply to message #474555] Tue, 07 September 2010 04:25 Go to previous messageGo to next message
Michel Cadot
Messages: 59414
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Right-click on the desktop, choose New -> shortcut, Browse for sqlplusw.exe in your Oracle home, then choose a name for your shortcut.

Then right click on the shortcut -> Properties and in command line, after sqlplusw.exe add "user/password@db"

Regards
Michel
Re: sql*plus [message #474568 is a reply to message #474561] Tue, 07 September 2010 04:46 Go to previous message
pointers
Messages: 350
Registered: May 2008
Senior Member
That worked very nice. Thanks a lot Thomas and Micheal.

Regards,
Pointers
Previous Topic: Oracle9i
Next Topic: Doubts on TOAD and SQL developer
Goto Forum:
  


Current Time: Tue Oct 21 20:40:29 CDT 2014

Total time taken to generate the page: 0.06668 seconds