Re: SQL-plus
From: Tim <jmeth111_at_yahoo.ca>
Date: Mon, 02 Mar 2009 18:37:23 -0500
Message-ID: <4dc8e$49ac6db3$cef8ac46$31772_at_TEKSAVVY.COM>
>
> 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...
Date: Mon, 02 Mar 2009 18:37:23 -0500
Message-ID: <4dc8e$49ac6db3$cef8ac46$31772_at_TEKSAVVY.COM>
Michael Austin wrote:
> 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) >>>> [Quoted] >>>> 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.
>
> 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...
[Quoted] Some places now give tests. I was asked to write some HTML code. I just gave the thing back and told them I don't write things from scratch. In another case, I was asked what folder a certain file was in. Received on Tue Mar 03 2009 - 00:37:23 CET