Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambrium.nl!feed.tweaknews.nl!postnews.google.com!e2g2000vbe.googlegroups.com!not-for-mail
From: ddf <oratune@msn.com>
Newsgroups: comp.databases.oracle.tools
Subject: Re: SQL-plus
Date: Mon, 2 Mar 2009 07:05:01 -0800 (PST)
Organization: http://groups.google.com
Lines: 71
Message-ID: <a651b22b-f9eb-47be-8a21-23ad918f5849@e2g2000vbe.googlegroups.com>
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>
NNTP-Posting-Host: 138.32.32.166
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1236006302 1994 127.0.0.1 (2 Mar 2009 15:05:02 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 2 Mar 2009 15:05:02 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: e2g2000vbe.googlegroups.com; posting-host=138.32.32.166; 
 posting-account=KXUmygkAAABvBFmgDBe4RBLFwhTRAMZC
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; 
 Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) ;  Embedded Web 
 Browser from: http://bsalsa.com/; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET 
 CLR 3.0.4506.2152; .NET CLR 3.5.30729),gzip(gfe),gzip(gfe)
Xref:  news.cambrium.nl

On Mar 2, 8:02=A0am, 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. =A0I
> >>> recently hit a bug when it flagged a warning about a type issue in a
> >>> trigger - which was utter nonsense. =A0Also, with SQL Developer you
> >>> still need to do the typing (although I'd concede that the auto
> >>> completion usually works). =A0The best thing that can be probably sai=
d
> >>> about it is that you easily get an overview of all your database
> >>> objects.
>
> >> Exactly. If I =A0want 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. =A0To see a
> > description of a table's layout you just need "desc <table name>". =A0W=
ith
> > "ed" you can quite conveniently edit your SQL statement in your
> > preferred text editor. =A0And if you want to do some script based testi=
ng
> > with time measurements and output saved, SQL Plus is unbeatable.
>
Comments embedded
> > Now, this is enough advertising. ;-)
>
> > Kind regards
>
> > =A0 =A0 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.

> 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 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