Re: SQL-plus
From: Tim <jmeth111_at_yahoo.ca>
Date: Mon, 02 Mar 2009 14:56:20 -0500
Message-ID: <a6b5c$49ac39e4$cef8ac46$6549_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:
[Quoted] [Quoted] >>>> 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 14:56:20 -0500
Message-ID: <a6b5c$49ac39e4$cef8ac46$6549_at_TEKSAVVY.COM>
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:
[Quoted] [Quoted] >>>> 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?
Received on Mon Mar 02 2009 - 20:56:20 CET