Re: SQL-plus
From: Tim <jmeth111_at_yahoo.ca>
Date: Mon, 02 Mar 2009 16:52:34 -0500
Message-ID: <2c85c$49ac5522$cef8ac46$19557_at_TEKSAVVY.COM>
>>>>>> On Mar 2, 8:02 am, Tim <jmeth..._at_yahoo.ca> wrote:
>>>>>> Comments embedded
>>>>>> Legion. The optimizer changed dramatically between 8i and 10g, and
>>>>>> other enhancements have also been provided. See here for 9i
>>>>>> improvements:
>>>>>> http://download.oracle.com/docs/cd/B10501_01/server.920/a96531/ch2_9i...
>>>>>> and here for 10g enhancements:
>>>>>> http://download.oracle.com/docs/cd/B19306_01/server.102/b14214/chapte...
>>>>>> You should also peruse "Cost-Based Oracle Fundamentals", by Jonathan
>>>>>> Lewis, to understand the changes in the optimizer which can affect
>>>>>> you.
>>>>>> It can, depending upon what you're doing. New syntax, such as the
>>>>>> WITH clause (for subquery factoring), may provide improved
>>>>>> performance
>>>>>> over in-line views.
>>>>>> Yes, as noted above. Check the documentation for other query
>>>>>> enhancements provided by a specific release.
>>>>>> - Hide quoted text -
>>>>>> David Fitzjarrell- Hide quoted text -
Date: Mon, 02 Mar 2009 16:52:34 -0500
Message-ID: <2c85c$49ac5522$cef8ac46$19557_at_TEKSAVVY.COM>
Shakespeare wrote:
> Tim schreef: >> Tim wrote: >>> ddf wrote: >>>> On Mar 2, 9:31 am, Tim <jmeth..._at_yahoo.ca> wrote: >>>>> ddf wrote:
>>>>>> On Mar 2, 8:02 am, Tim <jmeth..._at_yahoo.ca> wrote:
>>>>>>> Robert Klemme wrote: >>>>>>>> On 02.03.2009 13:49, Tim wrote: >>>>>>>>> Robert Klemme wrote: >>>>>>>>>> ... but be aware that SQL Developer has issues of its own. I >>>>>>>>>> recently hit a bug when it flagged a warning about a type >>>>>>>>>> issue in a >>>>>>>>>> trigger - which was utter nonsense. Also, with SQL Developer you >>>>>>>>>> still need to do the typing (although I'd concede that the auto >>>>>>>>>> completion usually works). The best thing that can be >>>>>>>>>> probably said >>>>>>>>>> about it is that you easily get an overview of all your database >>>>>>>>>> objects. >>>>>>>>> Exactly. If I want to look at the various tables and how they are >>>>>>>>> defined, I would rather click a few times than repeatedly type out >>>>>>>>> some command, regardless of how simple it is. >>>>>>>> Funny thing is, I am not a DBA either and although I do not work >>>>>>>> with >>>>>>>> Oracle very day I find using SQL Plus quite convenient. To see a >>>>>>>> description of a table's layout you just need "desc <table >>>>>>>> name>". With >>>>>>>> "ed" you can quite conveniently edit your SQL statement in your >>>>>>>> preferred text editor. And if you want to do some script based >>>>>>>> testing >>>>>>>> with time measurements and output saved, SQL Plus is unbeatable.
>>>>>> Comments embedded
>>>>>>>> Now, this is enough advertising. ;-) >>>>>>>> Kind regards >>>>>>>> robert >>>>>>> OK, here is another question. What is the difference, from a >>>>>>> developer's >>>>>>> point of view, between Oracle 8i, Oracle 9i and Oracle 10g?
>>>>>> Legion. The optimizer changed dramatically between 8i and 10g, and
>>>>>> other enhancements have also been provided. See here for 9i
>>>>>> improvements:
>>>>>> http://download.oracle.com/docs/cd/B10501_01/server.920/a96531/ch2_9i...
>>>>>>
>>>>>> and here for 10g enhancements:
>>>>>> http://download.oracle.com/docs/cd/B19306_01/server.102/b14214/chapte...
>>>>>>
>>>>>> You should also peruse "Cost-Based Oracle Fundamentals", by Jonathan
>>>>>> Lewis, to understand the changes in the optimizer which can affect
>>>>>> you.
>>>>>>> If I am just writing SQL statements does it really matter what >>>>>>> version I >>>>>>> use?
>>>>>> It can, depending upon what you're doing. New syntax, such as the
>>>>>> WITH clause (for subquery factoring), may provide improved
>>>>>> performance
>>>>>> over in-line views.
>>>>> Is that non-standard SQL then? >>>>> >>>>> >>>>> >>>>>>> Is there any added functionality that would change the actual SQL >>>>>>> statements?
>>>>>> Yes, as noted above. Check the documentation for other query
>>>>>> enhancements provided by a specific release.
>>>>>> - Hide quoted text -
>>>>>>> - Show quoted text -
>>>>>> David Fitzjarrell- Hide quoted text -
>>>>> - Show quoted text -- Hide quoted text - >>>>> >>>>> - Show quoted text - >>>> >>>> 'Non-standard SQL'? >>>> >>>> >>>> David Fitzjarrell >>> >>> Yes. Do they meet the SQL standards? There are standards to SQL, like >>> SQL99. >>> Not sure what the most recent version of that is called. >> >> So I removed 10g and tried to re-install 9i. I double click on the >> install.exe file and absolutely nothing happens. >> Is there a date limit as to when I can install this product or can I >> not go back a version? >> Any ideas? > > Why did you do that anyway? 10 g comes wit a sqlplusw as well! It's in > the ORACLE_HOME/bin directory.... > > Shakespeare
The folder that has sqlplus does not have sqlplusw in it. Received on Mon Mar 02 2009 - 22:52:34 CET