Re: SQL-plus

From: Michael Austin <>
Date: Mon, 02 Mar 2009 14:35:04 -0600
Message-ID: <WrXql.8015$>

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.
>>>>>>>>> Why is there such a difference in this feature?
>>>>>>>> So, are you looking for something like Oracle SQLDeveloper?  It 
>>>>>>>> is a different product.
>>>>>>>> That is also why they have XE, PE, SE and EE.. they bundle 
>>>>>>>> different stuff together...
>>>>>>> Thanks. But other versions of Oracle had a version of SQL*Plus 
>>>>>>> that was a Windows version with a UI.
>>>>>> sqlplusw != sqlplus
>>>>> 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?
>>>> 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.
>>>> Just my 0.02EUR
>>>>     robert
>>> 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.
>> real DBAs don't GUI.... :)
>> 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.

[Quoted] 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... Received on Mon Mar 02 2009 - 21:35:04 CET

Original text of this message