Re: SQL-plus
Date: Mon, 2 Mar 2009 11:29:56 -0800 (PST)
Message-ID: <9be42641-7d18-48c8-9612-6a1e542bc48d_at_r29g2000vbp.googlegroups.com>
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?
>> > other enhancements have also been provided. See here for 9i
> > Legion. The optimizer changed dramatically between 8i and 10g, and
> > improvements:
>
[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...
>> > Lewis, to understand the changes in the optimizer which can affect
> > You should also peruse "Cost-Based Oracle Fundamentals", by Jonathan
> > you.
>
> >> If I am just writing SQL statements does it really matter what version I
> >> use?
>> > WITH clause (for subquery factoring), may provide improved performance
> > It can, depending upon what you're doing. New syntax, such as the
> > 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
[Quoted] > > enhancements provided by a specific release.
>
> > - Hide quoted text -
> >> - Show quoted text -
>
[Quoted] [Quoted] > > David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -- Hide quoted text -
>
> - Show quoted text -
'Non-standard SQL'?
David Fitzjarrell Received on Mon Mar 02 2009 - 20:29:56 CET