Re: SQL-plus

From: Tim <jmeth111_at_yahoo.ca>
Date: Mon, 02 Mar 2009 14:47:59 -0500
Message-ID: <9e294$49ac37ef$cef8ac46$5873_at_TEKSAVVY.COM>

ddf wrote:

> On Mar 2, 9:31 am, Tim <jmeth..._at_yahoo.ca> wrote:
>> ddf wrote:

[Quoted] >>> 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?

>>> 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: [Quoted]
>>> 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
[Quoted] >>> 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. Received on Mon Mar 02 2009 - 20:47:59 CET