Re: SQL-plus
From: Tim <jmeth111_at_yahoo.ca>
Date: Mon, 02 Mar 2009 11:10:17 -0500
Message-ID: <cb9bb$49ac04e8$cef8ac46$28179_at_TEKSAVVY.COM>
[Quoted] >> 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_9ir2.htm#63430
[Quoted] >> and here for 10g enhancements:
>> http://download.oracle.com/docs/cd/B19306_01/server.102/b14214/chapter1.htm#NEWFTCH1
>> 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
Date: Mon, 02 Mar 2009 11:10:17 -0500
Message-ID: <cb9bb$49ac04e8$cef8ac46$28179_at_TEKSAVVY.COM>
Tim wrote:
> ddf wrote:
[Quoted] >> 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_9ir2.htm#63430
>> >>
[Quoted] >> and here for 10g enhancements:
>>
>> http://download.oracle.com/docs/cd/B19306_01/server.102/b14214/chapter1.htm#NEWFTCH1
>> >>
>> You should also peruse "Cost-Based Oracle Fundamentals", by Jonathan
>> Lewis, to understand the changes in the optimizer which can affect
>> you.
>> [Quoted] [Quoted] >>> 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.
>> > [Quoted] > Is that non-standard SQL then? > [Quoted] [Quoted] >>> 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
[Quoted] Will an older version of sqlplusw.exe work with the newer database? Received on Mon Mar 02 2009 - 17:10:17 CET