Re: SQL-plus
From: Tim <jmeth111_at_yahoo.ca>
Date: Mon, 02 Mar 2009 07:48:06 -0500
Message-ID: <1261c$49abd586$cef8ac46$14509_at_TEKSAVVY.COM>
>>>>>>>> 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?
Date: Mon, 02 Mar 2009 07:48:06 -0500
Message-ID: <1261c$49abd586$cef8ac46$14509_at_TEKSAVVY.COM>
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)
[Quoted] [Quoted] I'm not a DBA, I am a developer. And I don't have the memory to remember
[Quoted] 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.
Received on Mon Mar 02 2009 - 13:48:06 CET