| if you liked classic SQL Plus , what now? [message #527048] |
Fri, 14 October 2011 14:21  |
 |
BeckyinDC
Messages: 2
Registered: October 2011
Location: Washington DC
|
Junior Member |
|
|
I am not a DBA.
I was a very contented software tester with SQLPlus skills when I had access to the classic version.
I guess all things must come to an end as we have started seeing our systems under test migrate to 11g...and along comes the DOS prompt SQL*Plus.
Where I could previously ignore the cries that TOAD was better, I no longer have my right-click copy/paste option, and I don't know alot about the DOS prompt command line.
Our test lab administrator would like us to start working with SQL Developer for our testing needs...I am guessing because it installs automatically with the database. I read TOAD has a bit more functionality at this point(correct?)
What is better for a general database user with background of classic SQL Plus- the dos prompt SQL Plus or the more visual SQL developer?
|
|
|
|
| Re: if you liked classic SQL Plus , what now? [message #527050 is a reply to message #527048] |
Fri, 14 October 2011 14:32  |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Quote:I guess all things must come to an end as we have started seeing our systems under test migrate to 11g...and along comes the DOS prompt SQL*Plus.
Which existed far before 11g.
Tell me what are the differences between Windows SQL*Plus and DOS SQL*Plus that turn this latter one bad?
Quote:I no longer have my right-click copy/paste option, and I don't know alot about the DOS prompt command line.
You still have, it just needs you click on "c:\" icon top left, then on "Properties", "Options" tab and check something like "Fast edition mode" and clck on "OK".
Quote:the dos prompt SQL Plus or the more visual SQL developer?
No doubt from me, although I quite like SQL Developer, I still use and will use SQL*Plus forever.
Regards
Michel
|
|
|
|
|
|
| Re: if you liked classic SQL Plus , what now? [message #527089 is a reply to message #527053] |
Sat, 15 October 2011 01:55 |
|
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Yes, but it is in 3 steps: 1) you select, 2) you type on return, 3) you right-click instead of the select+right-click of Windows SQL*Plus.
In addition, you have a lines memory you can access with the up and bottom arrows and you can modify the current line with the left and right arrows, much better than the Windows SQL*Plus which just allows you to erase what you wrote using backspace.
This is not specific to SQL*Plus, this is DOS box properties and so you have it for any command in the DOS box in or outside a program.
Regards
Michel
|
|
|
|
| Re: if you liked classic SQL Plus , what now? [message #527232 is a reply to message #527089] |
Mon, 17 October 2011 02:49 |
Roachcoach
Messages: 1576
Registered: May 2010
Location: UK
|
Senior Member |
|
|
My dos box lets me select then two right clicks to paste it. First one copies, second one pastes.
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
There's also open source software called cygwin (http://www.cygwin.com/) - kind of mimics linux in windows. Given you're in testing I'm not sure you'd get a hold of it, but it is worth a look.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
