Re: SQL-plus

From: Tim <>
Date: Mon, 02 Mar 2009 11:10:17 -0500
Message-ID: <cb9bb$49ac04e8$cef8ac46$28179_at_TEKSAVVY.COM>

Tim wrote:

> ddf wrote:

[Quoted] >> On Mar 2, 8:02 am, Tim <> 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] >> and here for 10g enhancements:


>> You should also peruse "Cost-Based Oracle Fundamentals", by Jonathan
>> Lewis, to understand the changes in the optimizer which can affect
>> you.
[Quoted] [Quoted] >>> 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.
[Quoted] > Is that non-standard SQL then?
[Quoted] [Quoted] >>> 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

[Quoted] Will an older version of sqlplusw.exe work with the newer database? Received on Mon Mar 02 2009 - 17:10:17 CET

Original text of this message