Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to call SQLPlus ? Diff between iSQL*Plus ans SQL*Plus ?

Re: How to call SQLPlus ? Diff between iSQL*Plus ans SQL*Plus ?

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 27 May 2007 10:30:37 -0700
Message-ID: <1180287037.174162@bubbleator.drizzle.com>


William Robertson wrote:

> On May 26, 5:30 pm, DA Morgan <damor..._at_psoug.org> wrote:
>> William Robertson wrote:

>>> On May 26, 1:14 am, DA Morgan <damor..._at_psoug.org> wrote:
>>>> William Robertson wrote:
>>>>> On May 15, 9:28 pm, DA Morgan <damor..._at_psoug.org> wrote:
>>>>>> There are three different tools:
>>>>>> sqlplus.exe
>>>>>> sqlplusw.exe
>>>>>> isqlplus
>>>>>> Most people use sqlplusw.exe
>>>>> Isn't sqlplusw.exe the crappy obsolete one? You'd hope they would have
>>>>> more sense.
>>>> No. sqlplusw is the executable behind the yellow plus sign sitting on
>>>> top of two bluish disks. It is the most common one on Windows.

>>> Yes, apologies, sardonic tone possibly lost on newsgroup.
>>> sqlplusw IS the crappy obsolescent one used by people who don't know
>>> any better. AFAIK its "File, Open" menu option is its one useful
>>> feature, and even then it's easy enough to drag & drop files into a
>>> sqlplus.exe session from an explorer window. It used to have online
>>> help too but I think that disappeared a long time ago.
>>> What I generally do is use its tombstone icon for my sqlplus.exe
>>> shortcuts:
>>> http://www.williamrobertson.net/documents/sqlplus_setup.html
>>> though in XE, sqlplus.exe finally comes with a nice "SQL>" icon (and
>>> no crappy pseudo-GUI version).
>> When in Windows it is my favorite tool. Fast, efficient, clean, and able
>> to execute any and all functionality.
> 
> except
> 
> "We haven't put any new features in sqlplusw.exe since at least around
> the 8i timeframe. The SET commands aren't up to date."
> 
> http://forums.oracle.com/forums/thread.jspa?threadID=292571
> 
> The output formatting sounds useful, I must check that when I'm back
> in Windows next week. Does it handle WITH clauses?

It handles everything TTBOMK. The statement you've quoted is, I believe, not accurate and dates back to when Alison was talking about dumping sqlplusw in favour of iSQLPlus.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun May 27 2007 - 12:30:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US