Re: SQL-plus
Date: Mon, 2 Mar 2009 11:33:41 -0800 (PST)
Message-ID: <38d23007-5f8e-4b3d-b22a-d3fbecf52944_at_r34g2000vbp.googlegroups.com>
On Mar 2, 10:10 am, Tim <jmeth..._at_yahoo.ca> wrote:
> Tim 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:
>
> >>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
> >> enhancements provided by a specific release.
>
> >> - Hide quoted text -
> >>> - Show quoted text -
>
> >> David Fitzjarrell
>
> Will an older version of sqlplusw.exe work with the newer database?- Hide quoted text -
>
> - Show quoted text -
It should. It may depend upon how much older that release of sqlplusw.exe is relative to the database to which you're trying to connect.
David Fitzjarrell Received on Mon Mar 02 2009 - 20:33:41 CET