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

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? Received on Sat May 26 2007 - 17:54:36 CDT