Re: SQL-plus
From: Tim <jmeth111_at_yahoo.ca>
Date: Mon, 02 Mar 2009 10:31:30 -0500
Message-ID: <39199$49abfbd2$cef8ac46$22814_at_TEKSAVVY.COM>
> 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
>
> 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
Received on Mon Mar 02 2009 - 16:31:30 CET
Date: Mon, 02 Mar 2009 10:31:30 -0500
Message-ID: <39199$49abfbd2$cef8ac46$22814_at_TEKSAVVY.COM>
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_9ir2.htm#63430
>
> 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] >> 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
Received on Mon Mar 02 2009 - 16:31:30 CET