Re: SQL-plus

From: Tim <jmeth111_at_yahoo.ca>
Date: Mon, 02 Mar 2009 16:52:34 -0500
Message-ID: <2c85c$49ac5522$cef8ac46$19557_at_TEKSAVVY.COM>

Shakespeare wrote:

> Tim schreef:
>> Tim wrote:
>>> ddf wrote:
>>>> 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?

>>>>>> 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:
>>>>>> 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
>>>>>> 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.
>>
>> So I removed 10g and tried to re-install 9i. I double click on the 
>> install.exe file and absolutely nothing happens.
>> Is there a date limit as to when I can install this product or can I 
>> not go back a version?
>> Any ideas?
> 
> Why did you do that anyway? 10 g comes wit a sqlplusw as well! It's in 
> the ORACLE_HOME/bin directory....
> 
> Shakespeare

The folder that has sqlplus does not have sqlplusw in it. Received on Mon Mar 02 2009 - 22:52:34 CET