Re: SQL-plus
From: Tim <jmeth111_at_yahoo.ca>
Date: Mon, 02 Mar 2009 16:09:05 -0500
Message-ID: <bcefb$49ac4af0$cef8ac46$32281_at_TEKSAVVY.COM>
>> Michael Austin wrote:
>> 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.
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