Re: SQL-plus
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Mon, 02 Mar 2009 17:31:05 -0600
Message-ID: <X0_ql.8550$%54.2947_at_nlpi070.nbdc.sbc.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 17:31:05 -0600
Message-ID: <X0_ql.8550$%54.2947_at_nlpi070.nbdc.sbc.com>
Tim wrote:
> 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. >>>>>>>>>>> >>>>>>>>>>> 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.
>> >> >> 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... > > Try going into an interview and say that.
[Quoted] I have and still do... I have forgotten more than most people asking the questions will know.... I give them concepts. Anyone can memorize the various permutations of this or that or the other. Very few can go beyond that to determine the real problem and it's real resolution. It's one of those things you can't memorize. As one that has recruited and hired in the past - I never ask "what's the command for..." I ask concept questions - there is a point at which you cannot bluff your way through those... Received on Tue Mar 03 2009 - 00:31:05 CET