Re: SQL-plus

From: Tim <>
Date: Mon, 02 Mar 2009 16:09:05 -0500
Message-ID: <bcefb$49ac4af0$cef8ac46$32281_at_TEKSAVVY.COM>

Michael Austin wrote:

> Tim wrote:

>> Michael Austin wrote:
>>> Tim wrote:
>>>> Robert Klemme wrote:
>>>>> On 01.03.2009 23:38, Tim wrote:
>>>>>> Michael Austin wrote:
>>>>>>> Tim wrote:
>>>>>>>> Michael Austin wrote:
>>>>>>>>> Tim wrote:
>>>>>>>>>> Why do I get different types of interfaces when I install 
>>>>>>>>>> different versions of Oracle?
>>>>>>>>>> I just installed a version of 10g, personal edition and the 
>>>>>>>>>> interface for SQL-plus is just a windows command prompt.
>>>>>>>>>> Other times, with different versions, there were actual 
>>>>>>>>>> applications that had buttons for executing statements or 
>>>>>>>>>> retrieving statements.
[Quoted] >>>>>>>>>> Why is there such a difference in this feature?
[Quoted] >>>>>>>>> So, are you looking for something like Oracle SQLDeveloper?  It 
>>>>>>>>> is a different product.
[Quoted] >>>>>>>>> That is also why they have XE, PE, SE and EE.. they bundle 
>>>>>>>>> different stuff together...
[Quoted] >>>>>>>> Thanks. But other versions of Oracle had a version of SQL*Plus 
>>>>>>>> that was a Windows version with a UI.
>>>>>>> sqlplusw != sqlplus
[Quoted] >>>>>> Well OK, although I think it was referred to as such. Is there any 
>>>>>> way I can get a sqlplusw.exe for my version of Oracle 10g?
[Quoted] >>>>> I'd rather not want to.  The Windows application is flawed.  The 
>>>>> command line version is much better, for example, it has command 
>>>>> history.  Just forget this Windows thing.  I am hearing, Oracle 
>>>>> removed it in 11g anyway.
[Quoted] >>>>> Just my 0.02EUR
>>>>>     robert
[Quoted] >>>> Well thanks for your advice but, since no one else has convinced me 
>>>> to prefer command line tools, I think I will continue to use the UI 
>>>> based one. It is much better.
[Quoted] >>> real DBAs don't GUI.... :)
[Quoted] >>> but if you must, download Oracle's SQLDeveloper (also works with DB2 
>>> and  SQL Server) - I also have used DBVizualizer (free download)

>> I'm not a DBA, I am a developer. And I don't have the memory to
>> remember all of the commands for Oracle, and all of the other things I
>> have to know to develop J2EE applications.
>> If that is your main focus, you can remember it because you are using
>> it every day. I am using Javascript, JSP, Java, Hibernate, JDBC, etc.
> remember it all???  I still use google - after many many years as a dba 
> -- I take the Einstien approach - try not to remember anything I can 
> look up...

[Quoted] Try going into an interview and say that. Received on Mon Mar 02 2009 - 22:09:05 CET

Original text of this message