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

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 26 May 2007 15:11:39 -0800
Message-ID: <4658b09b$1@news.victoria.tc.ca>

DA Morgan (damorgan_at_psoug.org) wrote:

: sybrandb_at_hccnet.nl wrote:

: > On Fri, 25 May 2007 17:14:46 -0700, DA Morgan <damorgan_at_psoug.org>
: > wrote:
: >

: >> 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.

: >
: > This may be true, but is obsoleted by Oracle, as it is a *windows
: > specific* executable. sqlplusw will disappear, and is going to be
: > replaced by isqlplus.

: They tried that once. The loud noise they heard was their customers.

Such as myself.

sqlplus.exe has just as many bugs as sqlplusw.exe, and isqlplus is a totally different kettle of fish.

sqlplusw has a nice "spreadsheet-ish", rectangular, block mode way of displaying data which cannot be replicated with cmd line sqlplus. For example, scrolling the displayed data using the keys.

I notice that many other tools really just provide fancy versions of that same rectangularism as the basic way of working with data.

I use both, plus other tools when the whim strikes, but I find having sqlplusw on part of the screen, a notepad editor in another, and a cmd line window in the corner, provides a perfectly good IDE environment for much oracle work on windows.

$0.10 Received on Sat May 26 2007 - 18:11:39 CDT