Home » Other » 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: 451
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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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: 451
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: 13961
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: 451
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: 3212
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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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: 451
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: Sun Dec 22 06:55:01 CST 2024