Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feeder8.cambrium.nl!feed.tweaknews.nl!newsfeed.xs4all.nl!newsfeed5.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Date: Mon, 02 Mar 2009 21:05:21 +0100
From: Shakespeare <whatsin@xs4all.nl>
User-Agent: Thunderbird 2.0.0.19 (Windows/20081209)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.tools
Subject: Re: SQL-plus
References: <b76e$49aad877$cef8ac46$19494@TEKSAVVY.COM> <jQCql.21425$Ws1.16964@nlpi064.nbdc.sbc.com> 	<3bac4$49aafda6$cef8ac46$1930@TEKSAVVY.COM> <3MDql.13082$8_3.11345@flpi147.ffdc.sbc.com> 	<be9a$49ab0e7c$cef8ac46$15924@TEKSAVVY.COM> <710i76FiahloU1@mid.individual.net> 	<30a62$49ab138f$cef8ac46$12367@TEKSAVVY.COM> <3pJql.13111$8_3.12736@flpi147.ffdc.sbc.com> 	<711j1mFigeo6U1@mid.individual.net> <31b5a$49abd5f3$cef8ac46$14509@TEKSAVVY.COM> 	<7125vrFiab48U1@mid.individual.net> <24b41$49abe6f8$cef8ac46$23188@TEKSAVVY.COM> 	<a651b22b-f9eb-47be-8a21-23ad918f5849@e2g2000vbe.googlegroups.com> 	<39199$49abfbd2$cef8ac46$22814@TEKSAVVY.COM> <9be42641-7d18-48c8-9612-6a1e542bc48d@r29g2000vbp.googlegroups.com> <9e294$49ac37ef$cef8ac46$5873@TEKSAVVY.COM> <a6b5c$49ac39e4$cef8ac46$6549@TEKSAVVY.COM>
In-Reply-To: <a6b5c$49ac39e4$cef8ac46$6549@TEKSAVVY.COM>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 88
Message-ID: <49ac3bfd$0$198$e4fe514c@news.xs4all.nl>
NNTP-Posting-Host: 82.95.215.210
X-Trace: 1236024317 news.xs4all.nl 198 [::ffff:82.95.215.210]:50105
X-Complaints-To: abuse@xs4all.nl
Xref:  news.cambrium.nl

Tim schreef:
> Tim wrote:
>> ddf wrote:
>>> On Mar 2, 9:31 am, Tim <jmeth...@yahoo.ca> wrote:
>>>> ddf wrote:
>>>>> On Mar 2, 8:02 am, Tim <jmeth...@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